[SOLVED] Number of workstations to which a packet group is assigned

Renaud Villet · January 23, 2020 - 2:17 PM

Hello,
I'd like to create a query that will give me the number of machines on which a package group is installed...is that possible?
Thanks

Mathieu · February 3, 2020 - 10:08 AM

There is this script that you can modify according to what you want to display.

select package,version,architecture,description,section,package_uuid,count(*)
from hostpackagesstatus s
where section not in ('host','unit','group')
group by 1,2,3,4,5,6

You replace 'group' with 'base' to display only package groups

Renaud Villet · February 4, 2020 - 4:58 PM

Yes, it works, thank you!
Now for the trickier part: is it possible to get the number of computers to which a particular package group has been assigned, sorted by domain?

Thank you.

Mathieu · February 5, 2020 - 9:44 AM

I don't have that one in my list that I got through Tranquil IT, sorry

eblaudy · February 17, 2020 - 4:50 PM

Good morning,
Here's what you're looking for:

Code: Select all

SELECT hosts.dnsdomain, COUNT(hosts.uuid)
FROM hosts, hostpackagesstatus
WHERE hosts.uuid = hostpackagesstatus.host_id AND hostpackagesstatus.package = 'tis-wsl-debian'
GROUP BY hosts.dnsdomain
ORDER BY 2 DESC

Simply replace "tis-wsl-debian" with the name of your package group.

This works for any package name

Group or not!

Have a good rest of the day