Fortinet black logo

CLI Reference

sql-query-dataset

sql-query-dataset

Use this command to execute a SQL dataset against the FortiAnalyzersystem.

Syntax

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

Variable

Description

<adom>

Enter an ADOM name.

<dataset-name>

Enter the dataset name.

<device/group name>

Enter the name of the device. Example: FWF40C3911000061

<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 FortiAnalyzersystem.

Syntax

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

Variable

Description

<adom>

Enter an ADOM name.

<dataset-name>

Enter the dataset name.

<device/group name>

Enter the name of the device. Example: FWF40C3911000061

<faz/dev>

Enter the name of the FortiAnalyzer.

<start-time>

Enter the log start time.

<end-time>

Enter the log end time.