Page 1 of 1

[RESOLVED] Specific package reporting

Published: April 19, 2022 - 10:46 AM
by lutech
Hello,

I'm looking for a query in the Reporting function that will allow me to retrieve a list of PCs that have a specific package installed. In my case, it's a package that modifies the registry.


Thank you for your help.

Have a good day.

WAPT version: 2.1.2 Enterprise
Server OS: Debian 10
Administration/Package Creation Machine OS: Windows 10 Pro

Re: Reporting specific package

Published: April 20, 2022 - 1:58 PM
by sfonteneau
Hello,

an example is already available here: viewtopic.php?t=1842

Simon

Re: Reporting specific package

Published: April 20, 2022 - 2:31 PM
by lutech
Hello,

thank you for your reply.
I had already come across this query in my searches.
However, my WAPT package in question does not appear on the client machine as software, because it is a configuration package.

Re: Reporting specific package

Published: April 20, 2022 - 2:48 PM
by sfonteneau

Code: Select all

SELECT uuid,computer_name,package,install_status FROM hosts h
LEFT JOIN hostpackagesstatus hps
ON h.uuid = hps.host_id
WHERE package LIKE 'tis-config%%' 

Re: Reporting specific package

Published: April 20, 2022 - 2:55 PM
by lutech
Functional request.

Thank you.