List all reports in Ops Mgr 2007

If you want to get a complete list of the reports in your Operations Manager environment, you can use the following queries. Run these queries against the reportserver database. The first query gets all reports and the second query gets all reports with a name like SQL.

Select * from catalog where hidden = '0' and (type='2' or type='4')

Select * from catalog where hidden = '0' and name like '%sql%' and (type='2' or type='4')

Leave a Reply

Your email address will not be published. Required fields are marked *