Creating Useful Custom Reports in OpsMgr: How to make my custom report publicly available within my organization
This blog series includes the following posts:
Part 1 – Gathering Custom Performance Counters in OpsMgr
Part 2 – How to create a free disk space report
Part 3 – How to create a processor utilization report for a group of servers
Part 4 – How to create a custom performance counters report for a group of servers
Part 5 – How to make my custom report publicly available
Part 6 – How to schedule my custom report for delivery
Now that we have created our own custom reports it may be useful to provide them within the URL which is available for reporting.
How to make my custom report publicly available via the reporting URL
1. Open Internet Explorer, and open the SQL Server Reporting Services (SSRS) homepage by entering the following URL: |localhost>/reports">|localhost>/reports">http://<servername>|localhost>/reports
2. On the SQL Server Reporting Services Home page, click New Folder.
3. If the folder does not exist on the top level page, fill in a Name and a Description for the new folder and then click OK.
4. Back on the Home page, select the My Reports folder and on the My Reports page, click your published report to run the report (if you do not see your reports here, go back to the earlier steps and make sure that you published them in addition to putting them into your favorites).
5. In the report results page, select Properties.
6. On the General page, click Move and then select the custom folder that you previously created. Click OK. Click Home to go back to the Home page.
7. On the Home page, click the My Reports folder and press Ok to move the report.
8. Open the Operations Manager reporting website and verify the new report exists as it is expected to.
9. The report is displayed in the results pane, and is now available to all users with appropriate reporting access in Operations Manager.
For larger organizations it may be useful to create subfolders on a per-team basis so that all of the team’s reports are in the same folder. This approach provides as easy way for users of Operations Manager to open reports without having to access the console. Through providing the reports via a URL all the user needs is a web browser to access their own custom reports. Reports can also be added into management packs within the Operations Manager console to make them available both within the reporting URL and within the Operations Manager console / Reporting section. I prefer the above approach as I have seen issues with attempting to get some of my reports to add correctly via the add to management pack functionality.
In the next part of this series we will discuss how to schedule custom reports for delivery!