HiWe have an active passive working Fortigate 1500D (6.2.4 version)
cluster.Our problem is, ipsec vpn's in passive devices suddenly become
passive and do not change status up. Ipsec VPNs are up on the active
device. "session pickup enable" on HA conf...
Hi i'm using below dataset. My problem is timestamp. Example user ihsan
connected today but log show date August 28.I connected August 28 and
August 31. I want to see last connection time. Can you help me? select
coalesce(xauthuser_agg, user_agg, ips...
Hi i can use on below dataset. My problem same user and same destination
see a few times. How can edit this dataset for this problem? SELECT
TO_CHAR(TO_TIMESTAMP(`itime`)::timestamp, 'YYYY-MM-DD HH24:MI') AS time,
COALESCE(NULLIFNA(UPPER(`user`)), IP...
Hi We have two location and we are using fortigate devices on this
locations. My problem is releated sflow data. I send sFlow over switch
behind the firewall. We can not send sFlow data between the two
locations but we can send the sflow the same loc...
Hi I want to add user column below dataset. I didn't add user column.
Can you help me for this dataset. select domain, sum(bandwidth) as
bandwidth from (###(select coalesce(nullifna(hostname), ipstr(`srcip`))
as domain, sum(coalesce(sentbyte, 0)+coal...
