select coalesce(nullifna(`user`), `srcip`) as user,to_timestamp(`itime`)::timestamp with time zone as time,`hostname`||`url` as url,`catdesc` from $log where $filterI added this dataset to a chart and set the max rows to something like 1000000 (you need a value). When you add the chart to a report, you can specify the user in the " filter" section.
AtiT
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.