Fortinet black logo

CLI Reference

system sql

system sql

Use this command to view SQL configuration.

Syntax

get system sql

Example

This example shows the output for get system sql:

custom-index:

prompt-sql-upgrade : enable

status : local

text-search-index : disable

ts-index-field:

== [ FGT-app-ctrl ]

category: FGT-app-ctrl value: user,group,srcip,dstip,dstport,service,app,action,hostname

== [ FGT-attack ]

category: FGT-attack value: severity,srcip,dstip,action,user,attack

== [ FGT-content ]

category: FGT-content value: from,to,subject,action,srcip,dstip,hostname,status

== [ FGT-dlp ]

category: FGT-dlp value: user,srcip,service,action,filename

== [ FGT-emailfilter ]

category: FGT-emailfilter value: user,srcip,from,to,subject

== [ FGT-event ]

category: FGT-event value: subtype,ui,action,msg

== [ FGT-traffic ]

category: FGT-traffic value: user,srcip,dstip,service,app,utmaction

== [ FGT-virus ]

category: FGT-virus value: service,srcip,dstip,action,filename,virus,user

== [ FGT-voip ]

category: FGT-voip value: action,user,src,dst,from,to

== [ FGT-webfilter ]

category: FGT-webfilter value: user,srcip,dstip,service,action,catdesc,hostname

== [ FGT-netscan ]

category: FGT-netscan value: user,dstip,vuln,severity,os

== [ FGT-fct-event ]

category: FGT-fct-event value: (null)

== [ FGT-fct-traffic ]

category: FGT-fct-traffic value: (null)

== [ FGT-fct-netscan ]

category: FGT-fct-netscan value: (null)

== [ FGT-waf ]

category: FGT-waf value: user,srcip,dstip,service,action

== [ FGT-gtp ]

category: FGT-gtp value: msisdn,from,to,status

== [ FGT-dns ]

category: FGT-dns value: (null)

== [ FGT-ssh ]

category: FGT-ssh value: (null)

== [ FML-emailfilter ]

category: FML-emailfilter value: client_name,dst_ip,from,to,subject

== [ FML-event ]

category: FML-event value: subtype,msg

== [ FML-history ]

category: FML-history value: classifier,disposition,from,to,client_name,direction,domain,virus

== [ FML-virus ]

category: FML-virus value: src,msg,from,to

== [ FWB-attack ]

category: FWB-attack value: http_host,http_url,src,dst,msg,action

== [ FWB-event ]

category: FWB-event value: ui,action,msg

== [ FWB-traffic ]

category: FWB-traffic value: src,dst,service,http_method,msg

background-rebuild : enable

database-type : postgres

device-count-high : disable

event-table-partition-time: 0

fct-table-partition-time: 240

rebuild-event : enable

rebuild-event-start-time: 00:00 2000/01/01

start-time : 00:00 2000/01/01

traffic-table-partition-time: 0

utm-table-partition-time: 0

system sql

Use this command to view SQL configuration.

Syntax

get system sql

Example

This example shows the output for get system sql:

custom-index:

prompt-sql-upgrade : enable

status : local

text-search-index : disable

ts-index-field:

== [ FGT-app-ctrl ]

category: FGT-app-ctrl value: user,group,srcip,dstip,dstport,service,app,action,hostname

== [ FGT-attack ]

category: FGT-attack value: severity,srcip,dstip,action,user,attack

== [ FGT-content ]

category: FGT-content value: from,to,subject,action,srcip,dstip,hostname,status

== [ FGT-dlp ]

category: FGT-dlp value: user,srcip,service,action,filename

== [ FGT-emailfilter ]

category: FGT-emailfilter value: user,srcip,from,to,subject

== [ FGT-event ]

category: FGT-event value: subtype,ui,action,msg

== [ FGT-traffic ]

category: FGT-traffic value: user,srcip,dstip,service,app,utmaction

== [ FGT-virus ]

category: FGT-virus value: service,srcip,dstip,action,filename,virus,user

== [ FGT-voip ]

category: FGT-voip value: action,user,src,dst,from,to

== [ FGT-webfilter ]

category: FGT-webfilter value: user,srcip,dstip,service,action,catdesc,hostname

== [ FGT-netscan ]

category: FGT-netscan value: user,dstip,vuln,severity,os

== [ FGT-fct-event ]

category: FGT-fct-event value: (null)

== [ FGT-fct-traffic ]

category: FGT-fct-traffic value: (null)

== [ FGT-fct-netscan ]

category: FGT-fct-netscan value: (null)

== [ FGT-waf ]

category: FGT-waf value: user,srcip,dstip,service,action

== [ FGT-gtp ]

category: FGT-gtp value: msisdn,from,to,status

== [ FGT-dns ]

category: FGT-dns value: (null)

== [ FGT-ssh ]

category: FGT-ssh value: (null)

== [ FML-emailfilter ]

category: FML-emailfilter value: client_name,dst_ip,from,to,subject

== [ FML-event ]

category: FML-event value: subtype,msg

== [ FML-history ]

category: FML-history value: classifier,disposition,from,to,client_name,direction,domain,virus

== [ FML-virus ]

category: FML-virus value: src,msg,from,to

== [ FWB-attack ]

category: FWB-attack value: http_host,http_url,src,dst,msg,action

== [ FWB-event ]

category: FWB-event value: ui,action,msg

== [ FWB-traffic ]

category: FWB-traffic value: src,dst,service,http_method,msg

background-rebuild : enable

database-type : postgres

device-count-high : disable

event-table-partition-time: 0

fct-table-partition-time: 240

rebuild-event : enable

rebuild-event-start-time: 00:00 2000/01/01

start-time : 00:00 2000/01/01

traffic-table-partition-time: 0

utm-table-partition-time: 0