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?

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.

-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'
  • 1
    The information has been removed from the Catalog. – JHFB Apr 29 '15 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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