Fortinet black logo

CLI Reference

sql-query-dataset

sql-query-dataset

Use this command to execute a SQL dataset against the FortiManager system.

Syntax

execute sql-query-dataset <adom_name> <dataset-name> <device/group name> <faz/dev> <start-time> <end-time>

Variable

Description

<adom_name>

Enter the ADOM name.

<dataset-name>

Enter the SQL dataset name.

<device/group name>

Enter the name of the device or device group.

<faz/dev>

Enter the reference time: FortiAnalyzer time or device time.

<start-time>

Enter the log start time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<end-time>

Enter the log end time (timestamp or <yyyy-mm-dd hh:mm:ss>).

sql-query-dataset

Use this command to execute a SQL dataset against the FortiManager system.

Syntax

execute sql-query-dataset <adom_name> <dataset-name> <device/group name> <faz/dev> <start-time> <end-time>

Variable

Description

<adom_name>

Enter the ADOM name.

<dataset-name>

Enter the SQL dataset name.

<device/group name>

Enter the name of the device or device group.

<faz/dev>

Enter the reference time: FortiAnalyzer time or device time.

<start-time>

Enter the log start time (timestamp or <yyyy-mm-dd hh:mm:ss>).

<end-time>

Enter the log end time (timestamp or <yyyy-mm-dd hh:mm:ss>).