Fortinet black logo

CLI Reference

report dataset

report dataset

Use the following command to configure report data sets.

You can configure existing data sets or add new ones, by creating SQL queries.

config report dataset
    edit {name}
    # Report dataset configuration.
        set name {string}   Name. size[71]
        set policy {integer}   Used by monitor policy. range[0-4294967295]
        set query {string}   SQL query statement. size[2303]
        config field
            edit {id}
            # Fields.
                set id {integer}   Field ID (1 to number of columns in SQL result). range[0-4294967295]
                set type {text | integer | double}   Field type.
                        text     Text.
                        integer  Integer.
                        double   Double.
                set name {string}   Name. size[71]
                set displayname {string}   Display name. size[127]
            next
        config parameters
            edit {id}
            # Parameters.
                set id {integer}   Parameter ID (1 to number of columns in SQL result). range[0-4294967295]
                set display-name {string}   Display name. size[127]
                set field {string}   SQL field name. size[127]
                set data-type {option}   Data type.
                        text          Text.
                        integer       Integer.
                        double        Double.
                        long-integer  Long integer.
                        date-time     Date and time.
            next
    next
end

report dataset

Use the following command to configure report data sets.

You can configure existing data sets or add new ones, by creating SQL queries.

config report dataset
    edit {name}
    # Report dataset configuration.
        set name {string}   Name. size[71]
        set policy {integer}   Used by monitor policy. range[0-4294967295]
        set query {string}   SQL query statement. size[2303]
        config field
            edit {id}
            # Fields.
                set id {integer}   Field ID (1 to number of columns in SQL result). range[0-4294967295]
                set type {text | integer | double}   Field type.
                        text     Text.
                        integer  Integer.
                        double   Double.
                set name {string}   Name. size[71]
                set displayname {string}   Display name. size[127]
            next
        config parameters
            edit {id}
            # Parameters.
                set id {integer}   Parameter ID (1 to number of columns in SQL result). range[0-4294967295]
                set display-name {string}   Display name. size[127]
                set field {string}   SQL field name. size[127]
                set data-type {option}   Data type.
                        text          Text.
                        integer       Integer.
                        double        Double.
                        long-integer  Long integer.
                        date-time     Date and time.
            next
    next
end