Installation inventory of a specific package on the network

[jacky35]

Good morning,
Here is a query that allows you to retrieve all the machines that have installed a certain package.

Code: Select all

SELECT hostpackagesstatus.version,hosts.computer_name,hostpackagesstatus.host_id
FROM hostpackagesstatus
INNER JOIN packages ON hostpackagesstatus.package_uuid = packages.package_uuid
INNER JOIN hosts ON hosts.uuid = hostpackagesstatus.host_id
WHERE packages.package LIKE 'tis-7zip';

Thanks to Jimmy from Tranquil IT

Jacky

[florentR2]

Thank you. A feature request would be to be able to see the deployment status of a package directly from the VS console, for example, the number of PCs in a unit.