Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
brancott
New Contributor

Fail to create a custom report

I'm having troubles with custom reports. It seems to be an easy task, I just wanna see violations of a single policy so I create new blank report, choose period and devices, add filters - Policy ID equal to 208 (btw what is the difference between policy_id and policyid? I tried both) and it seems to be all I need, right? But when I run this report it comes out just blank.

Is there anything else I need to configure? Do I have to add something on Layout page to make it work? Please help, I couldn't find any detailed tutorials, just do 1,2,3 and here are your report, that's what I do and it doesn't work.

2 REPLIES 2
brazz_FTNT
Staff
Staff

Hello, 

 

 

When dealing with Custom reports , we need to pay attention to couple of points here:

[ul]
  • The  Dataset should  return some data
  • Chart shouled be verified  
  • Desired chart must be inserted to the Report[/ul]

     

    I have created below dataset , you may try this one:

     

     

    SELECT policyid AS "PolicyId" , devname as "DeviceName", count(*) AS "#PolicyBeingUsed"
    FROM $log
    WHERE $filter AND policyid!=0
    GROUP BY "PolicyId", "DeviceName"
    ORDER BY "#PolicyBeingUsed" desc

     

     

     

    Let me know how it goes. 

     

     

    Cheers

     

  • ysato

    What version of FAZ are you using?

    v6.0.0?

     

     

    Announcements

    Select Forum Responses to become Knowledge Articles!

    Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

    Labels
    Top Kudoed Authors