Dataset for facebook and youtube usage

[bgardiner]

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 

[bgardiner · Accepted solution]

Any help would be much appreciated 

[bgardiner · Accepted solution]

Any help would be much appreciated 

[hzhao_FTNT · Accepted solution]

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

[sub7even]

Hi Gurus,

Does this query working for ver 5.6?

Regards,