Tranquil IT Forum

Published: **September 26, 2024 - 12:30 PM**

Hello,

I created an application group named PC-2024, and I would like to generate a report listing the computers that are not part of this group. Could you help me?

Thank you.

Published: **January 15, 2025 - 10:54 AM**

Good morning,

I think you can use a query like the one below:

Code: Select all

SELECT hosts.computer_name
FROM hosts
WHERE 0 = (select count(hostpackagesstatus.host_id)
FROM hostpackagesstatus
WHERE hostpackagesstatus.package ilike 'PC-2024'
AND hosts.uuid = hostpackagesstatus.host_id)

Tranquil IT Forum

[SOLVED] Query - List of PCs without a software group

[SOLVED] Query - List of PCs without a software group

Re: Request - List of PCs without a software group