Hi There, Would anyone have a report that would query the reportserver database that would which reports are never being used (we need to find out to remove them) and also those that haven't been used in the past year? Thanks, R

Hi , Use the below query to query the reportserver database : Include this query in dataset : SELECT CAT.Name AS ReportName,MAX(TimeEnd) AS LastUsed FROM dbo.ExecutionLog EXELOG INNER JOIN dbo.Catalog CAT ON CAT.ItemID=EXELOG.ReportID WHERE CAT.Type=2 GROUP BY CAT.Name and then Use a table in Report and add the fields ,after that add a filter on that table as shown below : Month(Fields!LastUsed.Value)< Month(Globals!ExecutionTime)-6 it will give you the reports which has not been used for last 6 months .....similarly you can do it for years,quarters ....

I have and alternative method, that gets me that information and much more. One thing; I have reports that are run only 4x or even once a year, and they are still very important reports of course.The method I use for this is to log report request to a separate database. Basically this has four parts 1) Collect the information I want2) Call a stored proc to write the information to the database3) Continue with the report run4) Write the end time to the report row in the report database. Step 4 allows me to collect the end time, without holding a lock of the report table.Now I can report off of the report log anytime I wish, and show when the report ran, who ran it, how long it ran, and what criterion was used to run it. Of this information the report run times help us most with performance monitoring.HTHJohn

Hi John, I'm a newbie in ssrs. do you mind providing me with your instructions and how to do this and your sp?? --anna (amcwa)