Overall Report Usage

(3 posts) (2 voices)


  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;


You must log in to post.