Skip to main content
tronton_team
New Member
June 25, 2018
Question

(ask) fortianalyzer custom report

  • June 25, 2018
  • 1 reply
  • 3406 views

hello, i want to ask

i have a fortigate with fortianalyzer and i want to create custom report with scenario like this :

 

1. Network A 1.a. user/ip 1 | browse to what website 1.b. user/ip 2 | browse to what website 2. Network B 2.a. user/ip1 | browse to what website

2.a. user/ip1 | browse to what website

2.b. user/ip 2 | browse to what website

 

can i create custom report like that with fortianalyzer ?

sorry for my bad english

    1 reply

    chall_FTNT
    Staff
    Staff
    June 25, 2018

    Should be possible assuming your are comfortable designing SQL queries.  To extract the network portion of an IP address, you should be able to use the function network(inet).

     

    https://www.postgresql.or...tic/functions-net.html

     

    note: for those less familiar with SQL, the Chart Builder tool (FAZ 5.6 & later) can take you part of the way.  But that tool, only allows you to choose from available fields, without using functions.  You need to manually modify the SQL query in a dataset to include a function.