SELECT vd, policyid, srcip, dstip, itime, service, count(*) AS numoftimes, from_itime(itime) as date_time FROM $log where $filter GROUP BY vd, policyid, srcip, dstip, itime, service ORDER BY numoftimes DESC
itime does not dispaly as date and time, is there anyway I can convert so the report displays date/time
my synatx test works, but displays numbers rather than hour of the day etc
thanks
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
SELECT vd, policyid, srcip, dstip, to_char(from_itime("itime"), 'HH24:MI' ) as hour, service, count(*) AS numoftimes, from_itime(itime) as date_time FROM $log where $filter GROUP BY vd, policyid, srcip, dstip, itime, service ORDER BY numoftimes DESC
Thanks worked like a peach!
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1528 | |
1020 | |
749 | |
443 | |
209 |
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.