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')
Recent Comments