Skip to main content
angie1996
angie1996
New Member
January 4, 2021
Question

can I generate reports in the fortianalyzer

  • January 4, 2021
  • 1 reply
  • 2914 views
Hello everyone, how can I generate reports in the fortianalyzer? is there a guide to learn? I am new to the topic!

    1 reply

    ede_pfau
    SuperUser
    ede_pfau
    SuperUser
    January 5, 2021

    hi,

     

    do a search in the KB (kb.fortinet.com) for "fortianalyzer report".

    See as example https://kb.fortinet.com/kb/documentLink.do?externalID=FD44745

    Then, as reports are based on datasets, you may find this interesting:

    https://docs.fortinet.com/document/fortianalyzer/6.4.4/dataset-reference

     

    In general, use FAZ interactively, that is, filter data as you wish, create a chart, and save the result as a report. Only if you have more requirements than which are offered in the GUI, and you speak SQL fluently, you turn to datasets and macros and create your reports from scratch, as scripts.

     

    HTH.

    ede_pfau
    SuperUser
    ede_pfau
    SuperUser
    January 5, 2021

    here's an example of a FAZ script:

    SELECT user_src,
      domain,
      browsetime 
      FROM ###(
      SELECT
       coalesce(nullifna(`user`), IPSTR(`srcip`)) as user_src,
       sum($browse_time) as delta,
       sum($browse_time) as browsetime,
       coalesce(root_domain(hostname), 'unknown') as domain
      FROM $log
      WHERE $filter
      GROUP BY
       user_src, domain having sum($browse_time)>0
      ORDER BY 
       delta ASC)### t
    GROUP BY user_src, domain, browsetime
    ORDER BY user_src, browsetime DESC

    from [link]https://forum.fortinet.com/tm.aspx?m=107233[/link]

    Terms & ConditionsAccessibility statement