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

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

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

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 PEM Server Directory

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

Core Usage Report