Fortinet white logo
Fortinet white logo

CLI Reference

config report dataset

config report dataset

Note

This command is available for model(s): FortiGate 1000D, FortiGate 101E, FortiGate 101F, FortiGate 1101E, FortiGate 1200D, FortiGate 1500DT, FortiGate 1500D, FortiGate 1801F, FortiGate 2000E, FortiGate 201E, FortiGate 201F, FortiGate 2201E, FortiGate 2500E, FortiGate 2600F, FortiGate 2601F, FortiGate 3000D, FortiGate 301E, FortiGate 3100D, FortiGate 3200D, FortiGate 3301E, FortiGate 3401E, FortiGate 3601E, FortiGate 3700D, FortiGate 3800D, FortiGate 3810D, FortiGate 3815D, FortiGate 401E, FortiGate 4201F, FortiGate 4401F, FortiGate 5001D, FortiGate 5001E1, FortiGate 501E, FortiGate 600D, FortiGate 601E, FortiGate 61E, FortiGate 61F, FortiGate 800D, FortiGate 81E-POE, FortiGate 81E, FortiGate 81F-POE, FortiGate 81F, FortiGate 900D, FortiGate 91E, FortiGate-VM64 ALI, FortiGate-VM64 AWS, FortiGate-VM64 AZURE, FortiGate-VM64 GCP, FortiGate-VM64 OPC, FortiGate-VM64, FortiWiFi 61E, FortiWiFi 61F, FortiWiFi 81F 2R 3G4G-POE, FortiWiFi 81F 2R-POE, FortiWiFi 81F 2R.

It is not available for: FortiGate 100EF, FortiGate 100E, FortiGate 100F, FortiGate 1100E, FortiGate 140E-POE, FortiGate 140E, FortiGate 1800F, FortiGate 200E, FortiGate 200F, FortiGate 2200E, FortiGate 300E, FortiGate 3300E, FortiGate 3400E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400E Bypass, FortiGate 400E, FortiGate 40F 3G4G, FortiGate 40F, FortiGate 4200F, FortiGate 4400F, FortiGate 5001E, FortiGate 500E, FortiGate 600E, FortiGate 60E DSLJ, FortiGate 60E DSL, FortiGate 60E-POE, FortiGate 60E, FortiGate 60F, FortiGate 80E-POE, FortiGate 80E, FortiGate 80F Bypass, FortiGate 80F-POE, FortiGate 80F, FortiGate 90E, FortiGateRugged 60F 3G4G, FortiGateRugged 60F, FortiWiFi 40F 3G4G, FortiWiFi 40F, FortiWiFi 60E DSLJ, FortiWiFi 60E DSL, FortiWiFi 60E, FortiWiFi 60F, FortiWiFi 80F 2R.

Report dataset configuration.

config report dataset
    Description: Report dataset configuration.
    edit <name>
        config field
            Description: Fields.
            edit <id>
                set displayname {string}
                set name {string}
                set type [text|integer|...]
            next
        end
        config parameters
            Description: Parameters.
            edit <id>
                set data-type [text|integer|...]
                set display-name {string}
                set field {string}
            next
        end
        set policy {integer}
        set query {string}
    next
end

config report dataset

Parameter

Description

Type

Size

Default

name

Name.

string

Maximum length: 71

policy

Used by monitor policy. Read-only.

integer

Minimum value: 0 Maximum value: 4294967295

0

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

Default

displayname

Display name.

string

Maximum length: 127

id

Field ID (1 to number of columns in SQL result).

integer

Minimum value: 0 Maximum value: 4294967295

0

name

Name.

string

Maximum length: 71

type

Field type.

option

-

text

Option

Description

text

Text.

integer

Integer.

double

Double.

config parameters

Parameter

Description

Type

Size

Default

data-type

Data type.

option

-

Option

Description

text

Text.

integer

Integer.

double

Double.

long-integer

Long integer.

date-time

Date and time.

display-name

Display name.

string

Maximum length: 127

field

SQL field name.

string

Maximum length: 127

id

Parameter ID (1 to number of columns in SQL result).

integer

Minimum value: 0 Maximum value: 4294967295

0

config report dataset

config report dataset

Note

This command is available for model(s): FortiGate 1000D, FortiGate 101E, FortiGate 101F, FortiGate 1101E, FortiGate 1200D, FortiGate 1500DT, FortiGate 1500D, FortiGate 1801F, FortiGate 2000E, FortiGate 201E, FortiGate 201F, FortiGate 2201E, FortiGate 2500E, FortiGate 2600F, FortiGate 2601F, FortiGate 3000D, FortiGate 301E, FortiGate 3100D, FortiGate 3200D, FortiGate 3301E, FortiGate 3401E, FortiGate 3601E, FortiGate 3700D, FortiGate 3800D, FortiGate 3810D, FortiGate 3815D, FortiGate 401E, FortiGate 4201F, FortiGate 4401F, FortiGate 5001D, FortiGate 5001E1, FortiGate 501E, FortiGate 600D, FortiGate 601E, FortiGate 61E, FortiGate 61F, FortiGate 800D, FortiGate 81E-POE, FortiGate 81E, FortiGate 81F-POE, FortiGate 81F, FortiGate 900D, FortiGate 91E, FortiGate-VM64 ALI, FortiGate-VM64 AWS, FortiGate-VM64 AZURE, FortiGate-VM64 GCP, FortiGate-VM64 OPC, FortiGate-VM64, FortiWiFi 61E, FortiWiFi 61F, FortiWiFi 81F 2R 3G4G-POE, FortiWiFi 81F 2R-POE, FortiWiFi 81F 2R.

It is not available for: FortiGate 100EF, FortiGate 100E, FortiGate 100F, FortiGate 1100E, FortiGate 140E-POE, FortiGate 140E, FortiGate 1800F, FortiGate 200E, FortiGate 200F, FortiGate 2200E, FortiGate 300E, FortiGate 3300E, FortiGate 3400E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400E Bypass, FortiGate 400E, FortiGate 40F 3G4G, FortiGate 40F, FortiGate 4200F, FortiGate 4400F, FortiGate 5001E, FortiGate 500E, FortiGate 600E, FortiGate 60E DSLJ, FortiGate 60E DSL, FortiGate 60E-POE, FortiGate 60E, FortiGate 60F, FortiGate 80E-POE, FortiGate 80E, FortiGate 80F Bypass, FortiGate 80F-POE, FortiGate 80F, FortiGate 90E, FortiGateRugged 60F 3G4G, FortiGateRugged 60F, FortiWiFi 40F 3G4G, FortiWiFi 40F, FortiWiFi 60E DSLJ, FortiWiFi 60E DSL, FortiWiFi 60E, FortiWiFi 60F, FortiWiFi 80F 2R.

Report dataset configuration.

config report dataset
    Description: Report dataset configuration.
    edit <name>
        config field
            Description: Fields.
            edit <id>
                set displayname {string}
                set name {string}
                set type [text|integer|...]
            next
        end
        config parameters
            Description: Parameters.
            edit <id>
                set data-type [text|integer|...]
                set display-name {string}
                set field {string}
            next
        end
        set policy {integer}
        set query {string}
    next
end

config report dataset

Parameter

Description

Type

Size

Default

name

Name.

string

Maximum length: 71

policy

Used by monitor policy. Read-only.

integer

Minimum value: 0 Maximum value: 4294967295

0

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

Default

displayname

Display name.

string

Maximum length: 127

id

Field ID (1 to number of columns in SQL result).

integer

Minimum value: 0 Maximum value: 4294967295

0

name

Name.

string

Maximum length: 71

type

Field type.

option

-

text

Option

Description

text

Text.

integer

Integer.

double

Double.

config parameters

Parameter

Description

Type

Size

Default

data-type

Data type.

option

-

Option

Description

text

Text.

integer

Integer.

double

Double.

long-integer

Long integer.

date-time

Date and time.

display-name

Display name.

string

Maximum length: 127

field

SQL field name.

string

Maximum length: 127

id

Parameter ID (1 to number of columns in SQL result).

integer

Minimum value: 0 Maximum value: 4294967295

0