Infrastructure – System Center Operations Manager – SQL Query for SCOM Maintenance mode schedules

SCOM maintenance schedules list views only display names and comments. In order to view affected objects you are required to open the schedules to see the server list. This SQL query will display semicolon delimited list of the affects objects for each schedule. Below is a SQL query you can utilize to see all SCOM … Continue reading Infrastructure – System Center Operations Manager – SQL Query for SCOM Maintenance mode schedules