I needed to build a chart, that replicates the FortiView Vpn stats page
for an older version of the analyzer. I'm really close, but it's not
showing user names --- can someone help find the mistake? select
coalesce(xauthuser, user, ipstr(`remip`)) as...
On just about everything there is a comment field, is there a way to
display those in a report, ie: using the below select from_dtime(dtime)
as time, devid, `user` as user, action, cfgobj, msg from $log-event
where $filter and type='event' and subtyp...
I have built the following data set: Log - Web Filterselect
$calendar_time as time, srcip, catdesc, dstip, hostname from $log where
$filter and action='blocked' group by time, srcip, catdesc, dstip,
hostname order by time, srcip, catdesc, dstip, host...
So after uninstalling and reinstalling the stand alone client I can no
longer modify the web categories - I have web security enabled - - when
I goto Protection by site Category the Categories are blank like not
there... any ideas?
Hi all, I'm wanting to create a report that details each time an IPsec
tunnel has an up/down event. Ideally the out up would be close
to:date/time | tunnel id | up/down | duration so when the logs have a
change state it would look like:time | 123456 ...
working with Fortinet - we corrected a couple mistakes in the dataset.
the below takes the top authenticated vpn logins default chart, and
breaks it down. The Top Authenticated is the VPN - Summary View, and
this is what you get when you 'dig down'. ...
Hey there you could try something close to this - (I'm not near my
analyzers at the moment) select srcip as source, srccountry as
source_country, srcintf, count(*) as count, action from $log where
$filter and srcip is not null and srccountry is not n...
hz, Not sure if this will make a dif the analyzer in question is VFaz
5.2.4. I've gone ahead and done the remove hcache and still returns
blank. I did test this on our demo 1000D on 5.4.0 and it works. So not
sure why the 5.2.4 is being a pita.
Hz, Thanks. This however, returned the ssl vpn tunnels, I need our
static tunnels we have set up as interfaces, that are found in the
system log - these will show the p1/p2 negotiates in the event log, is
there a way to see their total down times lik...
