report server execution log to find used and unused reports

find, usage of reports from report server.

–Server:Report server
–Database: ReportServer

select c.*
from ExecutionLog e
inner join Catalog c ON c.ItemID = e.ReportID