Page 1 of 1

[SOLVED] Creating reports for external users

Published: November 22, 2024 - 2:56 PM
by yann83
Hello, I

have a WAPT Enterprise server (version 2.5.5, build 15697) on a CentOS 7 server with Windows 10 22H2 clients.

I want to allow people who don't have console access to view installation reports for specific software.

I considered using the /api/v3/reporting_exec API, for example, which works well in Python but can't be implemented in PHP due to certificate issues.
I also thought about accessing the PostgreSQL database, but it's not accessible externally.

The goal isn't to manually retrieve the results of a query every morning, but to automate the entire process.

Perhaps a bit naively, I envision it as a web page showing that Firefox installation was at x% on certain dates.

If you have any suggestions or ideas, I'd appreciate them.

Re: Creating reports for external users

Published: November 25, 2024 - 10:25 AM
by dcardon
Hello Yann,
yann83 wrote: Nov 22, 2024 - 2:56 PM WAPT enterprise server 2.5.5 15697 on a CentOS 7 server with Windows 10 22H2 clients.

I want to allow people who don't have console access to view installation reports for specific software.

I thought about using the /api/v3/reporting_exec API, for example, which works well in Python but can't be implemented in PHP, for example, because of certificates.
With all the security measures that have been put in place (especially for passing certifications), it's quite complicated now to authenticate without using the official API. However, you could use a Python script to handle the extraction and PHP to display your web pages.
I thought about accessing the postgresql database, but it is not accessible from the outside.
You can create a readonly user on the database (preferably) and modify the postgresql.conf and pg_hba.conf files to open a connection to the database, and the appropriate firewall configuration if necessary.

Sincerely,

Denis

Re: Creating reports for external users

Published: November 25, 2024 - 1:56 PM
by yann83
Thank you for your feedback