Hi, I'm using fortianlyzer and have a question during dataset creation
for report output.I wrote the query below to create a forticlient uuid
for the logged-in vpn user and it works fine.Below is an example of a
table made of query statements and que...
hello, @Anthony_E I solved this problem with a sub query. Please refer
to the query below SELECTfrom_itime(itime) AS
itime,`user`,`fctuid`FROM$logWHERE$filterAND (((lower(logid) =
lower('0107045124'))))AND `fctuid` IN (SELECT `fctuid`FROM $logWHERE
$...
