Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of time a report is run 1

Status
Not open for further replies.
darwin101

darwin101

Programmer
Mar 7, 2001
156
US
Hi all

Is there a way to tell how many time a report has been run in SRS Report manager? and maybe other related stats.
thanks
 
Sort by date Sort by votes
You can write SELECT queries against the tables in the ReportServer database.

It sounds like you want to query the table named ExecutionLog ... just make sure you don't change any data, only look at it with SELECT.
 
Upvote 0 Downvote
i see the join is to the catalog table. thanks, now i can see what reports are really being used :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
777
PeterDimitrov
PeterDimitrov
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
646
Theresajn
Theresajn
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
614
Ashajohn2021
Ashajohn2021
arunaramana
  • Locked
  • Question
difference ways of creatin
Replies
1
Views
664
MarkSweetland
MarkSweetland
kjv1611
  • Locked
  • Question
Create a "Jeopardy board" out of SQL Results - I'll explain
Replies
2
Views
703
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top