Skip to main content
tronton_team
tronton_team
New Member
May 15, 2018
Question

(ask) Fortianalyzer create custom report with postgress.schema

  • May 15, 2018
  • 1 reply
  • 3583 views

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

    1 reply

    chall_FTNT
    Staff
    chall_FTNT
    Staff
    May 15, 2018

    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
    tronton_teamAuthor
    New Member
    May 17, 2018

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

    Terms & ConditionsAccessibility statement