I am trying to modify the "web-hourly category and website hits" dataset so that I can list some specific time periods to run on a per-user basis to get all their URL and Category hits for that timeframe
eg: 08:20 - 08:55, User, URL, Category.
Could anyone help me out please?
Many thanks.
Robert
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.
Here is what I ended up using, just in case this can help anyone else:
select hostname, url, catdesc, to_char(from_dtime("dtime"), 'HH24:MI' ) as hour from $log where $filter and to_char(from_dtime("dtime"), 'HH24:MI') between '8:20' and '08:55' and hostname is not null order by hour;
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 |
---|---|
1733 | |
1106 | |
752 | |
447 | |
240 |
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.