Page 1 of 1

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

Published: September 26, 2024 - 12:30 PM
by bruno67
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.

Re: Request - List of PCs without a software group

Published: January 15, 2025 - 10:54 AM
by italbot
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)