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 140D-POE, FortiGate 140D, FortiGate 1500DT, FortiGate 1500D, FortiGate 2000E, FortiGate 201E, 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 3810D, FortiGate 3815D, FortiGate 401E, FortiGate 5001D, FortiGate 5001E1, FortiGate 500D, FortiGate 501E, FortiGate 51E, FortiGate 52E, 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 92D, FortiGate VM64, FortiWiFi 51E, FortiWiFi 61E, FortiWiFi 61F, 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 2200E, FortiGate 300E, FortiGate 30E 3G4G GBL, FortiGate 30E 3G4G INTL, FortiGate 30E 3G4G NAM, FortiGate 30E, FortiGate 3300E, FortiGate 3400E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400D, FortiGate 400E Bypass, FortiGate 400E, FortiGate 40F 3G4G, FortiGate 40F, FortiGate 5001E, FortiGate 500E, FortiGate 50E, FortiGate 600E, FortiGate 60E DSLJ, FortiGate 60E-POE, FortiGate 60E, FortiGate 60F, FortiGate 80E-POE, FortiGate 80E, FortiGate 80F Bypass, FortiGate 80F-POE, FortiGate 80F, FortiGate 90E, FortiGateRugged 30D, FortiGateRugged 35D, FortiGateRugged 60F 3G4G, FortiGateRugged 60F, FortiGateRugged 90D, FortiWiFi 30E 3G4G INTL, FortiWiFi 30E 3G4G NAM, FortiWiFi 30E, FortiWiFi 40F 3G4G, FortiWiFi 40F, FortiWiFi 50E 2R, FortiWiFi 50E, FortiWiFi 60E DSLJ, 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

name

Name.

string

Maximum length: 71

policy

Used by monitor policy.

integer

Minimum value: 0 Maximum value: 4294967295

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

id

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

integer

Minimum value: 0 Maximum value: 4294967295

type

Field type.

option

-

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

id

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

integer

Minimum value: 0 Maximum value: 4294967295

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 140D-POE, FortiGate 140D, FortiGate 1500DT, FortiGate 1500D, FortiGate 2000E, FortiGate 201E, 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 3810D, FortiGate 3815D, FortiGate 401E, FortiGate 5001D, FortiGate 5001E1, FortiGate 500D, FortiGate 501E, FortiGate 51E, FortiGate 52E, 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 92D, FortiGate VM64, FortiWiFi 51E, FortiWiFi 61E, FortiWiFi 61F, 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 2200E, FortiGate 300E, FortiGate 30E 3G4G GBL, FortiGate 30E 3G4G INTL, FortiGate 30E 3G4G NAM, FortiGate 30E, FortiGate 3300E, FortiGate 3400E, FortiGate 3600E, FortiGate 3960E, FortiGate 3980E, FortiGate 400D, FortiGate 400E Bypass, FortiGate 400E, FortiGate 40F 3G4G, FortiGate 40F, FortiGate 5001E, FortiGate 500E, FortiGate 50E, FortiGate 600E, FortiGate 60E DSLJ, FortiGate 60E-POE, FortiGate 60E, FortiGate 60F, FortiGate 80E-POE, FortiGate 80E, FortiGate 80F Bypass, FortiGate 80F-POE, FortiGate 80F, FortiGate 90E, FortiGateRugged 30D, FortiGateRugged 35D, FortiGateRugged 60F 3G4G, FortiGateRugged 60F, FortiGateRugged 90D, FortiWiFi 30E 3G4G INTL, FortiWiFi 30E 3G4G NAM, FortiWiFi 30E, FortiWiFi 40F 3G4G, FortiWiFi 40F, FortiWiFi 50E 2R, FortiWiFi 50E, FortiWiFi 60E DSLJ, 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

name

Name.

string

Maximum length: 71

policy

Used by monitor policy.

integer

Minimum value: 0 Maximum value: 4294967295

query

SQL query statement.

string

Maximum length: 2303

config field

Parameter

Description

Type

Size

id

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

integer

Minimum value: 0 Maximum value: 4294967295

type

Field type.

option

-

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

id

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

integer

Minimum value: 0 Maximum value: 4294967295

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.