Hi Everyone,
I have searched the internet far and wide and have been unable to find some really useful datasets and I was wondering if a more skilled mind could assist me.
I was searching for the following simple datasets -
Weekly report of top users for youtube bandwidth usage
weekly report for top users of facebook usage
Thankyou
Hi there,
Weekly report can be configured during report generation under Report ->Configuration
Log Type: taffic
Facebook:
select coalesce(nullifna(`user`), nullifna(`unauthuser`), ipstr(`srcip`)) as user_src, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log where $filter and logid_to_int(logid) not in (4, 7, 14) and (app like 'Facebook%' or hostname like '%facebook.com') group by user_src having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by bandwidth desc
YouTube:
select coalesce(nullifna(`user`), nullifna(`unauthuser`), ipstr(`srcip`)) as user_src, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log where $filter and logid_to_int(logid) not in (4, 7, 14) and (app like 'YouTube%' or hostname like '%youtube.com') group by user_src having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by bandwidth desc
regards,
hz
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
