[RESOLVED] Specific package reporting

Questions about WAPT Packaging / Requests and help regarding Wapt packages.
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Locked
lutech
Messages: 4
Registration: February 22, 2022 - 10:27

April 19, 2022 - 10:46

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
Last edited by lutech on 20 Apr 2022 - 14:55, edited 1 time.
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

April 20, 2022 - 1:58 PM

Hello,

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

Simon
lutech
Messages: 4
Registration: February 22, 2022 - 10:27

April 20, 2022 - 2:31 PM

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.
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

April 20, 2022 - 2:48 PM

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%%' 
lutech
Messages: 4
Registration: February 22, 2022 - 10:27

April 20, 2022 - 2:55 PM

Functional request.

Thank you.
Locked