11-16-2016 10:40 PM
Hello everyone,
Our site is currently running a trial for allowing access to Youtube. At the end of the trial I would like to create a number of reports to illustrate how this has impacted usage. I can grab the data volumes easily enough but I am really struggling to come up with a way to create a report that will allow me to extract the titles of the videos that have been viewed.
The obvious solution would be to run a report on all the Youtube URL's and isolate all the the video_ID's (https://www.youtube.com/watch?v=ySfSsn70rgU) then use google api’s to translate that into a title; however I can’t find a way to get the full URL from the logs.
Happy to say I am always learning, am I missing something simple here?
11-16-2016 11:00 PM
The YouTube traffic is likely transported inside of SSL or Quic. Are you doing SSL Decryption and have you blocked the "quic" Application?
11-16-2016 11:37 PM - edited 11-16-2016 11:39 PM
Hi There,
Even with decryption switched on and blocking quic ye still only get the code which you would have to translate to video using the api.
The Firewall just logs the url the users navigate to which doesn't include the video title. Using decryption mirrior may be one route ye could take but would seem over the top for this scenario. You would need other third party devices and to request the free licence from PAN. Then in theory ye can replay or analyis the decrypted packets and see what videos being played. Your suggestion of using the api seems the lesser of these two evils...
If its a concern users are watching unsuitable content, ye can switch on safesearch through url filtering. This not only applies safesearch settings to browsers, it also does for youtube.
article on blocking youtube, except for one video
article on youtube safesearch
decryption mirror
best regards,
robert D
11-17-2016 04:32 PM
Thanks guys. Unfortunately we have a large fleet of iPads so decryption is not really an option as it breaks many iOS apps (which is another discussion really). I guess I can look into selectively decrypting youtube traffic... Thanks for the pointers!
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!
