1. 

   thewah, Member

   Wondering if there's an easy way to see overall report usage across the whole db, not just one report.

   I've been tasked with cleaning up a reporting server, and was hoping there's a fairly simple query that will tell me overall usage of all reports by report name with a count per month on their usage.

   Thanks for any insight.
2. 

   myDBR Team, Key Master

   myDBR reports report usage into table mydbr_statistics. You can run reports against it.

   --
   myDBR Team
3. 

   thewah, Member

   Thanks...here's what I'm using...

   select r.name,r.proc_name,count(*)

   from mydbr_reports r join mydbr_statistics s on r.proc_name = s.proc_name where s.start_time between '2012-09-01' and '2012-12-07' group by r.name, r.proc_name order by 3 desc;

Reply

You must log in to post.