Just Learned - SSRS - Report History is still maintained even after deleting the report from Report Manager

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

SSRS - Report History is still maintained even after deleting the report from Report Manager

Jan 31 2012 12:00AM by Dattatrey Sindol (Datta)

Reporting Services has a system database called "ReportServer" (default) which it uses to store the information related to reports, data sources, report execution etc. stored/accessed on the Report Server.

A table called "Catalog" stores the information related to various objects hosted on the Report Server like Reports, Linked Reports, Data Sources etc. A table called "ExecutionLogStorage" stores the information related to execution/generation of reports etc.

When a report is added to Report Server, an entry will be made into "Catalog" table and when it is executed, an entry is made into "ExecutionLogStorage" table. Interestingly, when a report is deleted from the Report Server, the entry from "Catalog" table is deleted but the entry in the "ExecutionLogStorage" table is still retained.

Use the following query to verify it on your own.

SELECT *
FROM ExecutionLogStorage
WHERE ReportID NOT IN (SELECT ItemID FROM Catalog WHERE Type = 2)

Note: Table names are as per the SSRS 2008 version.

1 Comments

To the Admins:

Please Please Please fix your site so that the emails come from webmaster@beyond.... and not make it look like the person that is posting the comment. Otherwise it will get confused as junk mail from an unknown person.

commented on Jan 31 2012 7:20AM

mbova407

320 · 0% · 132

Your Comment

Sign Up or Login to post a comment.

"SSRS - Report History is still maintained even after deleting the report from Report Manager" rated 5 out of 5 by 10 readers