Hello, I am trying to create a Dataset to list the number of unique
source IPs which communicated with each destination IP but for some
reason it is not working, i already have a good Dataset with all
destination IPs and the total number of sessions,...
I am trying to generate a report to show the top applications by session
count and the destination IPs. Essentially I have :Dataset 1 to show top
applications by sessions.select appid, app, appcat, (case when
(utmaction in ('block', 'blocked') or act...
We have a Fortigate-1500D running on 5.6.8 which is averaging CPU usage
around 50%, some days ago there was a huge peak in the CPU usage which
went up to 90%. I took some screenshots from the device's web interface
shortly after issue was reported an...
Many thanks xsilver for your input, I will check what can be applied to
our environment.I am sure your answers will be useful to everyone here
as well :)
Hello xsilver, Thank you for your reply but the setup requirements
require no modification at all to the DCs so DC Agent installation is
not possible, logs have to be natively forwarded from the DC event log
syslog style.
That worked! You are definitely great and saved me How long did it take
you to figure those queries? Do you often need to edit/create datasets
and you are already an SQL expert? I would really love to thank you
personally, I will be in prague later t...
Hi AtiT, Actually the test button is not working for me on this
FortiAnalyzer, does not return anything so I cannot use it. Why are you
asking about the "test button" results anyways? Would it be a difference
between using it and the data returned in...
Hello again AtiT, Actually I noticed a small issue with the table, some
entries for same app, same destination IP and same hostname are not
grouped together and appear in different rows. I have tried to figure
out anything that might be causing this ...
