list of Fortianalyzer functions and tables

[Agent_1994]

Hello,

 I'm trying -with no success- to find a list of FortiAnalyzer functions (such as root_domain, from_dtime, etc.) and tables (such as app_mdata, ips_mdata). All i was able to find via Google is the dataset reference. 

 Thanks in advance

[chall_FTNT]

There is no public documentation so far although there is an optional SQL module in the NSE5 training material which does cover it.  I have made an internal request to document some of this information in the future.

[akesterg]

You can use the following command from the FortiAnalyzer CLI to list all tables:

execute sql-query-generic "select * from pg_catalog.pg_tables"