Fortinet black logo

Administration Guide

Viewing the SQL query of an existing dataset

Viewing the SQL query of an existing dataset

You can view the SQL query for a dataset, and test the query against specific devices or all devices.

To view the SQL query for an existing dataset:
  1. If using ADOMs, ensure that you are in the correct ADOM.
  2. Go to Reports > Report Definitions > Datasets.
  3. Hover the mouse cursor over the dataset on the dataset list. The SQL query is displayed as a tooltip.

    You can also open the dataset to view the Query field.

Tooltip

The SQL dataset test function can be used to determine if any errors are present in the SQL format. It should not be used to test returned values as those may be different than the ones used in reports.

Viewing the SQL query of an existing dataset

You can view the SQL query for a dataset, and test the query against specific devices or all devices.

To view the SQL query for an existing dataset:
  1. If using ADOMs, ensure that you are in the correct ADOM.
  2. Go to Reports > Report Definitions > Datasets.
  3. Hover the mouse cursor over the dataset on the dataset list. The SQL query is displayed as a tooltip.

    You can also open the dataset to view the Query field.

Tooltip

The SQL dataset test function can be used to determine if any errors are present in the SQL format. It should not be used to test returned values as those may be different than the ones used in reports.