OpsMgr 2007: How to create reports that can be viewed in IE rather than the console

Some users may need to have reports that can be looked at regularly but they don't want to install the SCOM console on a bunch of machines and have all those connections to the SDK.  So what can you do?  One way around this is to create reports that can be viewed in IE.  Below is an example I recently used to create a Disk Usage report for Exchange Servers that can be run by the Exchange Admins:

1. Go to Reporting in SCOM Admin Console.

2. Open the report you want to publish and fill in the parameters. When specifying the date, use Advanced and then Today Minus 7 (for weekly) etc.

3. Run the report. When finished select Publish.

4. Open SQL Management Studio and create a Reporting Services connection to the SRS box (In Server Type select Reporting Services instead of Database Engine).

5. Create a new folder for the reports (ie Exchange Admin Reports).

6. Expand the Home folder, then Users Folders, then the user who created the report.

7. In their My Reports folder, right click on the report file, select Move and browse to newly created folder. Do the same for the rpdl file.

8. Connect to the report in IE by typing /Reports">https://<machinename>/Reports.

9. Browse to the new folder, click on the report.

10. Copy the link from the report and email as link to the appropriate group of people.

Note: If you want to hide the parameters fields in the header area, right click on the reports in SQL Management Studio and select Properties. Click on Parameters and then check the box to Hide whichever fields you want hidden. Also, if you don't want the user to see the default tabs in the top of the report (which allows them to go to properties etc. in IE) browse to the report by going to /Reportserver">https://<Machinename>/Reportserver then drill down to the report and use this link.

Hope this helps,

Sam Allen | Senior Support Escalation Engineer