By default, SCOM schedules are only displayed for the ones that you create as a SCOM operator. SCOM admins will see all SCOM Schedules created by all users.
I thought of options to allow for this and came up with this example management pack that uses a custom report and a web browser widget to provide a direct link to the report contained in this management pack.
Let’s walk through configuring the management pack in your environment.
First, Import this example management pack bundle created with Visual studio authoring extensions and SQL Report builder 2016.
Select Administration – Installed Management packs and right click. Select Import Management packs…
Select Add from disk.
Select No to not search catalog.
Navigate to where you copied the example MP.
Select Open to import.
Select Install to import MP.
Select Close when import completes.
At this point we have the MP imported, however report will fail to run, some additional configuration is required.
Second, Use report viewer 2016 configure dataset.
Download link if you do not currently have it installed. https://www.microsoft.com/en-us/download/details.aspx?id=53613
Logon to your SCOM reporting server where you installed Report Builder and run report builder.
Select Open report and type in http://localhost/reportserver and select open
Navigate to MaintenanceModeScheduleReport folder and select Custom.Report.MaintMode
Select Open to edit the report datasource.
Expand data sources and right click on DataSource1
Select Data Source properties.
Select below options on Credentials tab and enter user name and password of a windows account that has sufficient permissions to run query. In this example I use my SDK account and password.
Select the general tab.
Change Connection string to your SQL dataset server that hosts the Operations Manager Database (not the datawarehouse server) and click test connection to verify credentials work.
Click Save disk icon at top left corner of report builder to save changes. Note my screen capture tools changed the icon. It will appear differently.
At this point the report should run and populate with any Maintenance mode schedules that you have created.
Lastly, Edit custom view to specify your report server.
This will allow the Monitoring view to see Maintenance schedules and users that are not SCOM Admins to see Maintenance schedules that were not created by them and allow for viewing data within the SCOM Web console.
Select Monitoring and expand folder All Scheduled Maint mode.
Click lower wrench and then clear contents.
Select Ok to remove widget.
Delete below
Wait for a minute or two and when you see click to add widget, select it.
Select Web Browser widget and select Next.
Enter a name and select next.
Enter below link in the Web Page URL changing scom19db2 string below with your reporting server name.
“http://scom19db2/ReportServer/Pages/ReportViewer.aspx?%2fMaintenanceModeScheduleReport%2fCustom.Report.MaintMode&rs:Command=Render”
Select Next.
Select Create to add the widget to the dashboard.
Select Close once it is successfully created.
Select the view again and when prompted for your credentials for reporting server type them in and select OK.
Select Close to continue.
If your browser security settings require, select click here to run scripts.
Click ok if any additional internet warning appear.
Note you can scroll to see additional fields if needed.
I added a testuser account with SCOM operator and SCOM report Operator roles.
Now, when I run SCOM console as test user they can now view SCOM Maintenance Schedules.
Hope you find this useful in the event you need anyone other than SCOM administrators to view all SCOM maintenance schedules.