ForitClient/FortiAnalyzer Reporting

Hi All,

I have a Fortigate/Analyzer (5.2 train) setup solely for managing the advanced XML profiles for FortiClient users. All logs level (6) are being sent through to the FAZ and the only information I am getting out of the device so far is the canned FortiClient Report.

Wondering if anyone has created some new SQL queries to provide data about the Vulnerability Scanning they are wiling to share and also getting some Web Categorization Field results within the fct-Web-Filter-Violations dataset?

Thankyou in advance.

Dan