Reports¶
You can generate the System Configuration report and Core Usage report for all locally and remotely managed servers. To generate this report, select Reports from the Management Menu.
Reports has following options:
Alert History Report (JSON)
System Configuration Report (JSON)
System Configuration Report (HTML)
Core Usage Report (JSON)
Core Usage Report (HTML)
Please note that only superusers or the users with the pem_admin role permission can download the System Configuration or Core Usage reports.
Also note that information in these reports will reflect the latest probe run time.
Alert History Report¶
The Alert History Report provides detailed information about the alerts history at the agent or server level in JSON format.
Go to Management menu, select Reports then select Alert History Report. A new dialogue box opens:
Alert History Report - General¶
Agent/Server Name - Select the agents and servers from the drop-down list. Overall System Report option is also available to generate a report for all the registered and active agents and servers.
Timeframe - Select the required timeframe from the drop-down list.
Download Alerts - Select the alert types you wish to generate the alert history report for.
System Configuration Report¶
The System Configuration Report provides detailed information about the PEM Agents group, PEM Server directory group and custom groups listed under browser tree. These groups can contain Postgres Enterprise Manager, PEM Agents and Database servers. You can download this report in HTML as well as in JSON format.
The Postgres Enterprise Manager Summary provides details about:
The Postgres Enterprise Manager backend database server version
Application Version
User name accessing the application
Python version
Flask version
Platform specific information
The Summary, details about the number of agents and servers are provided.
System Configuration Report - PEM Summary and Summary¶
The Group: PEM Agents, details about PEM Agent, CPU, Disk Utilization as well as Memory details are provided.
System Configuration Report - PEM Agents¶
The Group: PEM Server Directory, provides details about:
The database server version
Host
Port
Database name
Database size
Tablespace size
System Configuration Report - Group Server Name¶
Please note that here Group Server Name depends on the group name to which the server is added.
Core Usage Report¶
The Core Usage report provides detailed information about number of cores specific to:
The server type
Database version
Platform and group name
Also, gives detailed information about locally managed servers with:
Type
Host
Port
Platform
Cores
RAM
Core Usage Report¶