Tranquil IT Forum

Published: **March 7, 2024 - 12:16**

Hello,

In order to discover the machines that have a bulk agent, I am looking to make a query that displays the machines that are part of the AD OU, that are seen, that have an OK status and no associated/installed packages.

Is this possible?

Published: **April 26, 2024 - 2:21 PM**

Good morning

Try this:

Code: Select all

SELECT
hosts.computer_name as NomPC,
COUNT(hostpackagesstatus.name) as nb_logiciels_installes
FROM hosts
LEFT JOIN hostpackagesstatus ON hosts.uuid = hostpackagesstatus.host_id
GROUP BY hosts.computer_name
having count(hostpackagesstatus.name) = 0
ORDER BY hosts.computer_name ASC

Published: **May 3, 2024 - 4:26 PM**

Hello everyone,

thank you Yann83 for sharing this.

I'm marking the topic as resolved.

Regards,

Denis

Tranquil IT Forum

[SOLVED] Packetless machine request

[SOLVED] Packetless machine request

Re: Query for packetless machines

Re: Query for packetless machines