select src, user, hostname, url, req_type, FROM_UNIXTIME(itime) as Logtime from $log where $filter and req_type=directI am using an external MySQL server. If you are using the internal Postresql server in the FAZ, then I believe you want to change the from_unixtime to to_timestamp. The " Test" button in the Dataset area is very useful for debugging SQL statements like this to get them right. Once you get the dataset down, the Charting part is relatively simple. You create a new chart with the Data Set and a Graph Type of Table. In the Data Bindings section, display data in Raw form. Click " Add Column" to add the additional columns to your report. Deselect the option in the first column that says Only Show First 3 Items. Then just add the Chart to a custom report via drag and drop. Hope that helps.
Bill ========== Fortigate 600C 5.0.12, 111C 5.0.2 Logstash 1.4.1
The word on the street is that FAZ 5.0 is not ready for prime time yet.As someone who walked down that street I can confirm the word. We upgraded our FAZ to 5 in hopes of better reporting, but ran into bugs specifically related to UTM and the webfilter logs (it accepts them but won' t run reports against them). Other' s mileage may vary as you say, of course, but our FAZ100C was basically non-functional on 5.
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.