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 dataset name.

<device/group name>

Enter the name of the device or device group.

<faz/dev>

Enter the name of the FortiAnalyzer.

<start-time>

Enter the log start time.

<end-time>

Enter the log end time.

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 dataset name.

<device/group name>

Enter the name of the device or device group.

<faz/dev>

Enter the name of the FortiAnalyzer.

<start-time>

Enter the log start time.

<end-time>

Enter the log end time.