Hi all, Sorry if this has been asked but I couldn' t find any info on
it. I have a FortiClient to FortiGate IPSec VPN set up and working, with
traffic initiated from both directions. Should multiple FortiClient
endpoints be able to talk to each other...
It seems something has changed with postgres under FA5.2. You can' t use
coalesce with different data types any more so you need to cast srcip to
text. This: coalesce(nullifna(`user`), `srcip`) needs to be changed to:
coalesce(nullifna(`user`), text(...
I love how I keep getting notified that my 800B is end of life, and the
product that replaces it does not have the same functionality. Give me
my generic syslog back, PLEASE.
The only way the SQL query can help with that is if there is a table
field that you can use to limit the data. I' m not sure that the
Fortigates even differentiate real clicks from page requests.
Here is the query I used in the dataset: select
coalesce(nullifna(`user`), `srcip`) as
user,to_timestamp(`itime`)::timestamp with time zone as
time,`hostname`||`url` as url,`catdesc` from $log where $filter I added
this dataset to a chart and set the...
I think this is the problem: AND `type`=' webfilter' because in this
log, the type is utm and subtype is webfilter. If you have selected the
right log to query against, then you don' t need this at all because
$log will be the webfilter log. In any c...