[SOLVED] Packetless machine request

[lelongg]

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?

[yann83]

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

[dcardon]

Hello everyone,

thank you Yann83 for sharing this.

I'm marking the topic as resolved.

Regards,

Denis