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 2000E, FortiGate 201E, FortiGate 201F, FortiGate 2201E, FortiGate 2500E, FortiGate 3000D, FortiGate 300D, FortiGate 301E, FortiGate 3100D, FortiGate 3200D, FortiGate 3301E, FortiGate 3401E, FortiGate 3601E, FortiGate 3700D, FortiGate 3800D, FortiGate 3815D, FortiGate 401E, FortiGate 4201F, FortiGate 4401F, FortiGate 5001D, FortiGate 5001E1, FortiGate 500D, 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, 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 200E, FortiGate 200F, FortiGate 2200E, FortiGate 300E, FortiGate 3300E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400D, 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 type [text|integer|...]
                set name {string}
                set displayname {string}
            next
        end
        config parameters
            Description: Parameters.
            edit <id>
                set display-name {string}
                set field {string}
                set data-type [text|integer|...]
            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.

integer

Minimum value: 0 Maximum value: 4294967295

0

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

Default

id

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

integer

Minimum value: 0 Maximum value: 4294967295

0

type

Field type.

option

-

text

Option

Description

text

Text.

integer

Integer.

double

Double.

name

Name.

string

Maximum length: 71

displayname

Display name.

string

Maximum length: 127

config parameters

Parameter

Description

Type

Size

Default

id

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

integer

Minimum value: 0 Maximum value: 4294967295

0

display-name

Display name.

string

Maximum length: 127

field

SQL field name.

string

Maximum length: 127

data-type

Data type.

option

-

Option

Description

text

Text.

integer

Integer.

double

Double.

long-integer

Long integer.

date-time

Date and time.

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 2000E, FortiGate 201E, FortiGate 201F, FortiGate 2201E, FortiGate 2500E, FortiGate 3000D, FortiGate 300D, FortiGate 301E, FortiGate 3100D, FortiGate 3200D, FortiGate 3301E, FortiGate 3401E, FortiGate 3601E, FortiGate 3700D, FortiGate 3800D, FortiGate 3815D, FortiGate 401E, FortiGate 4201F, FortiGate 4401F, FortiGate 5001D, FortiGate 5001E1, FortiGate 500D, 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, 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 200E, FortiGate 200F, FortiGate 2200E, FortiGate 300E, FortiGate 3300E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400D, 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 type [text|integer|...]
                set name {string}
                set displayname {string}
            next
        end
        config parameters
            Description: Parameters.
            edit <id>
                set display-name {string}
                set field {string}
                set data-type [text|integer|...]
            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.

integer

Minimum value: 0 Maximum value: 4294967295

0

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

Default

id

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

integer

Minimum value: 0 Maximum value: 4294967295

0

type

Field type.

option

-

text

Option

Description

text

Text.

integer

Integer.

double

Double.

name

Name.

string

Maximum length: 71

displayname

Display name.

string

Maximum length: 127

config parameters

Parameter

Description

Type

Size

Default

id

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

integer

Minimum value: 0 Maximum value: 4294967295

0

display-name

Display name.

string

Maximum length: 127

field

SQL field name.

string

Maximum length: 127

data-type

Data type.

option

-

Option

Description

text

Text.

integer

Integer.

double

Double.

long-integer

Long integer.

date-time

Date and time.