Report Management

Administrators can output the result values for desired queries (SQL statements) as reports in Excel format. Query reports are created by setting queries to define the report, and then generating the file from the defined report.

Creating Query Reports

  1. Go to Audit > Report in the top panel.
  2. Go to Custom Reports on the left.
  3. Go to Select Action > Add Query Report.

Basic Settings

  1. For Report Title, enter a unique name.
  2. For Report Description, enter a description for this report.
  3. For Application Mode, select Enabled.
  4. For Auto Generation, select Enabled to run at the set time.

Detailed Settings

  1. For Output File, select Excel or CSV from the dropdown.
  2. For Email Reception, it can be sent to the administrator's email address.
  3. For Execution Query, add a custom query.
  4. Click Create.

Example Queries

Retrieve Node's Open Port Information

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

Retrieve IP List Using 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

 Administrators can use node reports to display information about node groups and all nodes,
 and display the number of operations, agent installations, and active agent nodes in graph format.

Creating Node Reports

  1. Go to Audit > Report in the top panel.
  2. Go to Custom Reports on the left.
  3. Go to Select Action > Add Node Report.

Basic Settings

  1. For Report Title, enter a unique name.
  2. For Report Description, enter a description for this report.
  3. For Application Mode, select Enabled.
  4. For Auto Generation, select Enabled to run at the set time.

Detailed Settings

Note

Repeat the following steps to add Collection Targets to the report.

  1. For Collection Target, select All Nodes or Node Group from the dropdown.
  2. If Node Group is selected, choose the desired group from the Target Settings dropdown.
  3. For Item, select the report target.
  4. For Output Name, use the default value or enter a unique name.
  5. For Description, enter a description for the option being configured.
  6. For Chart Type, select Line, Bar, or Area Graph from the dropdown.
  7. For Chart Color, select the desired color from the dropdown.
  8. For Audit Log, select the desired criteria from the dropdown.
  9. Click Add and then Create.
  10. Click Report Definition > Newly Created Node Report Name.

In the Chart tab,

  1. Select the desired Period and click Change.

Under the Table tab,

  1. Select the desired Period and click Change.
  2. To export the report locally in Excel format, click the Export icon.

Creating Log Reports

  1. Go to Audit > Report in the top panel.
  2. Go to Custom Reports on the left.
  3. Go to Select Action > Add Node Report.

Basic Settings

  1. For Report Title, enter a unique name.
  2. For Report Description, enter a description for this report.
  3. For Application Mode, select Enabled.
  4. For Auto Generation, select Enabled to run at the set time.

Detailed Settings

  1. For Audit Log Filter, select which filter to apply.
  2. For Output File, select the file type of the output file.
  3. For Email Reception, it can be sent to the administrator's email address.

Creating Dashboard Reports

  1. Go to Audit > Report in the top panel.
  2. Go to Custom Reports on the left.
  3. Go to Select Action > Add Dashboard Report.

Basic Settings

  1. For Report Title, enter a unique name.
  2. For Report Description, enter a description for this report.
  3. For Application Mode, select Enabled.
  4. For Auto Generation, select Enabled to run at the set time.

Detailed Settings

  1. For Dashboard Tab, set dashboard tabs such as Overview, Anomaly.
  2. For Output File, select the file type of the output file.
  3. For Email Reception, it can be sent to the administrator's email address.

Exporting Reports

  1. Go to Audit > Report in the top panel.
  2. Go to Email Dispatch and click the desired Report Name.
  3. Click Select Action > Perform Immediately (by clicking the file) to send the report via email.

How to Delete Reports

  1. Go to Audit > Report in the top panel.
  2. In the main window, find the Report Name to delete and click the checkbox.
  3. Click Select Action > Delete.