topic Re: Extract Youtube video titles that have been viewed in General Topics

Extract Youtube video titles that have been viewed

stuart.l — Thu, 17 Nov 2016 06:40:33 GMT

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?

Re: Extract Youtube video titles that have been viewed

jvalentine — Thu, 17 Nov 2016 07:00:01 GMT

The YouTube traffic is likely transported inside of SSL or Quic. Are you doing SSL Decryption and have you blocked the "quic" Application?

Re: Extract Youtube video titles that have been viewed

DonohoeRobert — Thu, 17 Nov 2016 07:39:31 GMT

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

https://live.paloaltonetworks.com/t5/Configuration-Articles/How-to-Allow-a-Single-YouTube-Video-and-Block-All-Other-Videos/ta-p/58944

article on youtube safesearch

https://live.paloaltonetworks.com/t5/Management-Articles/How-To-Control-YouTube-with-Safe-Search-Enforcement/ta-p/55049

decryption mirror

https://www.paloaltonetworks.com/documentation/60/pan-os/newfeaturesguide/networking-features/decryption-port-mirror

best regards,

robert D

Re: Extract Youtube video titles that have been viewed

stuart.l — Fri, 18 Nov 2016 00:32:52 GMT

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!