Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
RobertReynolds
Contributor

Custom Dataset: URL and Category By Hour per user

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

1 REPLY 1
RobertReynolds
Contributor

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;

Announcements

Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Labels
Top Kudoed Authors