Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS history


SSRS history

Author
Message
Blair McKeever
Blair McKeever
Mr or Mrs. 500
Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)

Group: General Forum Members
Points: 522 Visits: 668
The reports being run by SSRS are not being logged in the ExecutionLog table correctly any more. It used to log every report execution but approx three months ago it stopped logging all reports and now only logs those reports run by scheduled job. I have checked the equivalent non production installation whoch should be configured the same but it works fine. I assume that some miscreant has made a change that has stopped it working, but now I need to find the change and make it go again. I have checked everything that I can think of but have come up blank Sad Can anyone please point me in the right direction?

Cheers,
Blair
robert.gerald.taylor
robert.gerald.taylor
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1326 Visits: 1399
Blair McKeever (11/3/2013)
The reports being run by SSRS are not being logged in the ExecutionLog table correctly any more. It used to log every report execution but approx three months ago it stopped logging all reports and now only logs those reports run by scheduled job. I have checked the equivalent non production installation whoch should be configured the same but it works fine. I assume that some miscreant has made a change that has stopped it working, but now I need to find the change and make it go again. I have checked everything that I can think of but have come up blank Sad Can anyone please point me in the right direction?

I don't have a 2005 box to check, but take a look at this link: http://technet.microsoft.com/en-us/library/ms159110(v=sql.90).aspx

You can turn report execution logging on or off by selecting options in Report Manager on the Site Settings page. On this page, you can also specify how long you want to keep log entries. By default, this value is 60 days. Entries that exceed this date are removed at 2:00 A.M. every day.

Though when I look at the Site Settings on my SSRS 2008 R2 box, nothing jumps out at me where you'd specify this.

Good luck,
Rob
Blair McKeever
Blair McKeever
Mr or Mrs. 500
Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)

Group: General Forum Members
Points: 522 Visits: 668
Hi Robert,
Thanks for your reply. After much digging (and cursing) I have found out what is going on. A number of months ago someone migrated SSRS to a new SQL 2008 server (excluding a handful of scheduled reports and my RS history database and scripts). So now the RS history is only reporting on the few scheudled reports left behind and is blissfully ignorant of what's going on on the new server. I need to re-create my RS history setup and point the reports to the new server, but there is now a sizable hole in the history data Sad

Cheers,
Blair
Blair McKeever
Blair McKeever
Mr or Mrs. 500
Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)

Group: General Forum Members
Points: 522 Visits: 668
Oh yes, this topic can now be closed..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search