Hello,The only reference I managed to find on FAZ CLI commands usable
for placing SQL queries was the outdated Version 4.0 MR2 -- SQL Log
Database Query Technical Note. The database schema is no longer visible
with "get report database schema" in 5.2...
In case you need to know the database schema (log tables field
definitions), here is a method:Replace "tlog" in the command "postgres=#
\d+ "FGTADOMxxx-tlog-yyy" with the following*alog* for IPS attack
logs*elog* for event logs*rlog* for app-ctrl log...
Hello Zhao,In this case, it means that the utmaction-based report
contains partial and erroneous information, in the sense that-it
includes sessions that have been blocked due to security events totally
not related to web filtering (like viruses and ...
Actually, the search format "-=NULL" may not work, it depends
on the data type of the field. For instance, such a query does not work
in $log-traffic for the array-type fields (like threats, threatcnts,
threattyps). These fields are described in the ...