3

In SSRS, once a report is deleted, the ItemPath no longer appears in the ExecutionLog because the Catalog no longer has the report information. I can track down the ReportID, but I can't find anywhere with the history of the report name.

Is there anywhere I could find the name and path of the deleted report? If not, any suggestions on how to best stash the information moving forward?

Improve this question

2 Answers 2

Reset to default
1

If you need to get the information restore a backup taken prior to removing the report into a different environment and get it from there.

Improve this answer
-1

To see what SQL Server knows about your report you can try:

select * from Reportserver.dbo.Catalog where name='xxx'

select * from Reportserver.dbo.Catalog where name='project name'
Improve this answer
1
  • 1
    The information has been removed from the Catalog.
    – JHFB
    Apr 29, 2015 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.