create custom report for youtube

Here are a couple of Youtube queries I have created

This one lists all YouTube Videos played and embeds a hyperlink to take you straight to the video:

select `user` AS "Username", filename as "Name of Video",  concat(   '<a href="'    ,  '[link]https://', [/link] hostname, url,    '">',    concat(hostname, substring(url from 1 for 20),       '</a>')) AS  "YouTube URL"

from $log

where app = 'YouTube_Video.Access'

and filename is not null

This one shows the top watched Youtube videos by play count:

select filename AS "YouTube Video", count (filename) as "Number of Times Watched"

from $log

where app = 'YouTube_Video.Access'

and filename is not null

group by filename

order by "Number of Times Watched" desc;

As Youtube is https now, you need SSL Inspection enabled to be able to log the video name.