Managing Reports

Query Report function, the Administrator can output the result of the query (SQL statement) desired by the Administrator as an Excel file in the report format. Query Reports define the report by setting up the query statement, and the report is created by the file creation operation on the defined report.

Generate Query Report

  1. Go to Log > Report in the top panel.
  2. Go to Tasks > Generate Query Report.

Under General:

  1. For Title, type unique name.
  2. For Description, type what this report will do.
  3. For Status, select Enabled.
  4. For Auto Generating, select Enable for executing at set times.

Under Advanced:

  1. For File Format, choose Excel or CSV from drop-down.
  2. For Query, add custom query.
  3. Click Save.

Example Queries

Collect Open Ports Of Nodes

SELECT NL_IPSTR as IP, NL_MAC as MAC, NL_FQDN as HOSTNAME, GROUP_CONCAT(NI_PORT) as OPENPORT
  from vwNODELIST_ALL JOIN NODEINFOALL_OPENPORT ON (NI_NODEID = NL_NODEID)
  where NL_ACTIVE = ‘1’
  GROUP BY NL_NODEID

List Of IPs With The Same MAC

SELECT * FROM (
  SELECT NL_IPSTR, COUNT(NL_MAC) CNT
    from vwNODELIST_VALID
    GROUP BY NL_IP
    ORDER BY NL_IP
) A WHERE CNT > 1

The Administrator uses the Time Graph Report to show the information about the
Node Group and the whole Node, the operation, the Agent installation, and the
number of operation Agent Nodes in a Graph Format.

Generate Time Graph Report

  1. Go to Log > Report in the top panel.
  2. Go to Tasks > Generate Node Report.

Under General:

  1. For Title, type unique name.
  2. For Description, type what this report will do.
  3. For Status, select Enabled.
  4. For Auto Generating, select Enable for executing at set times.

Under Advanced:

Note

Repeat these steps under Advanced to add more Node Options to the report.

  1. For Node Options, select All Nodes or Node Group from drop-down.
  2. If Node Group is selected then for Node Group select desired group from drop-down.
  3. For Criteria, select what to report on.
  4. For Name, use default or type unique name.
  5. For Description, type what this report will do.
  6. For Graph Type, select Line, Bar, or Face graph from drop-down.
  7. For Graph Color, select desired color from drop-down.
  8. For Generating Logs, select desired criteria from drop-down.
  9. Click Add then Update.
  10. Go to Report Definition >Time Graph Report.

Under Graph tab:

  1. Select desired Time Period and click Generate

Under Table tab

  1. Select desired Time Period and click Generate.
  2. Click Export to export report locally in Excel format.

Create Automatic Reports

Automatic Report creation is the automatic generation and emailing portion of the Query Report.

Note

To send emails notifications, Outbound email and admin email notification settings must both be configured. See Setting up Outbound Email Server , Administrator Accounts.

  1. Go to Log > Report in the top panel.
  2. Go to Automatic Report in left Report panel.
  3. Go to Tasks > Create to create Automatic Report.

Under General:

  1. For Name, type unique name.
  2. For Description, type what this report will do.
  3. For Recipient, select Administrator or Admin Role.
  4. Double click available names in left column.
  5. For Report, Double click available reports.
  6. For Auto-generating, select Enable from drop-down and choose how often to run this report.
  7. Click Save.

Exporting Reports

  1. Go to Log > Report in the top panel.
  2. Go to Report Definition, click on desired Report name in left Report panel.
  3. Click Tasks > Generate Report. (File should appear to click on)
  4. Click on Report Filename to download. (e.g. 20180801110000.xlsx)
  5. Open Report Filename and save locally.

How to Delete Reports

  1. Go to Log > Report in the top panel.
  2. Find Report Definition in the main window and click Checkbox.
  3. Go to Tasks > Delete.
  4. Click OK to verify deletion.