(ask) Fortianalyzer create custom report with postgress.schema

[tronton_team]

hello i want to ask,

i want to create custom report from fortianalyzer with postress sql,

i have downloaded FortiAnalyzer-build1662-postgres.schema but i dont know how to use it,

can anybody teach me?

sorry for my bad english

[chall_FTNT]

You may wish to start by using chart builder if you are unfamiliar with SQL.

But if you decide you want to learn SQL & customize datasets manually, you can study the predefined datasets for ideas.  The point of the schema is primarily to show you which fields are available for each log type.  Usually a dataset will only query a single log type.

[tronton_team]

thanks for your answer, so basically the postgress.schema is just a table for reference my query if i want to build custom report ?