Report snapshot limits
Hello:
How can I tell which reports have "history" or "snapshots". Currently our setting for report history is set to UNLIMITED. I want to set it to 10 or less, but want to see what reports will be affected so I can notify the users.
Is there a query that I can run against the RS DB to find out this info?
Thanks
February 18th, 2011 6:12pm
Hi,
Please try this query script:
SELECT b.PATH,
b.name
FROM (SELECT reportid
FROM dbo.history
GROUP BY reportid
HAVING COUNT(0) > 10) AS a
JOIN dbo.catalog b
ON a.reportid = b.itemid
No matter whether it works, please tell me the result.
Thanks,
Albert Ye
Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2011 3:13am
This did not work. It did not error out, but it didn't show any results.
March 16th, 2011 5:00pm
This did not work. It did not error out, but it didn't show any results.
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2011 5:00pm