Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Query Fortianalyzer
Hi Everyone,
I am new to this forum and was hopping that someone can help me with the following issue.
I want to make a line chart in FortiAnalyzer that shows me the blocked traffic from the outside world of the past month.
Now I have this following query:
SELECT itime, action
FROM $log
WHERE srcintf='wan1'
See below what I get in return:
[image][/image]
So far so good. Itime I can format with the option in chart settings, but action does not count.
[image][/image]
I am not a SQL hero (I know the basics), but I was wonder if anybody can help me with this problem.
How can I get a nice line chart that tells me how many Deny there a each day of the past month.
Thanks in advance,
0 REPLIES 0
