[RESOLVED] - Script Reporting

Share your tips or issues concerning the WAPT Console or WAPT Agent here
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
Answer
User avatar
Geoffroy
Messages: 75
Registration: June 28, 2022 - 3:34 PM

January 26, 2024 - 1:48 PM

Hello everyone.

Server: WAPT Enterprise 2.5.2.15207 on Debian.
Consoles: Windows 10 & 11.
Infrastructure: Windows.


Thanks again, Denis, for the answer on the Maturity tab.

I'm preparing a reporting script for the console and I found the function in Structure DB to get the processor model for each host.
In this query, I would like to get the processor model/name.
SELECT computer_name, productname, computer_ad_ou, wapt_version, uuid, serialnr, computer_ad_site
FROM hosts
Server: WAPT Enterprise 2.6.0.17226 on Debian 12;
Consoles: Windows 11
; Infrastructure: Windows
Answer