Please help me to get youtube URL report. Which i am getting attached image. Kindly help
Go to Solution.
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"
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"
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.
View solution in original post
What versions of firmware are you running these queries on?
Also get "No Data" when running it, would love to use them
Mine is on:
Fortigate 300D 5.4.4
Hello dear, thank you for detailed explaination. Could you please update for FortiAnalyzer-400E v7.0.2 GA build0180 I tried your config but doesn't work. Regards,
Thanks to reply. I tried to apply this query. But not working.It's showing no data. Could you help me to enable ssl inspection in fortigate. i am using fortigate 300c
These Cookbook articles should help
After enable the SSL/SSH Inspection, same page only came now (no data).
what fimrware are you running on FGT / FAZ?
your screenshot didnt attach
FGT300c / FAZ200D
what about the FortiOS versions?
5.2.x / 5.4.x / 5.6.x ?
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2023 Fortinet, Inc. All Rights Reserved.