Installation inventory of a specific package on the network
Published: October 13, 2023 - 09:32
Good morning,
Here is a query that allows you to retrieve all the machines that have installed a certain package.
Thanks to Jimmy from Tranquil IT
Jacky
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';Jacky