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 maintenance schedules in your Operations Manager Management Group.
Use OperationsManager SELECT [ScheduleName] , ( SELECT BaseManagedEntity.DisplayName + '; ' FROM BaseManagedEntity with (NOLOCK) left join [OperationsManager].[dbo].[ScheduleEntity] on BaseManagedEntity.BaseManagedEntityId = ScheduleEntity.BaseManagedEntityId where ScheduleEntity.ScheduleId = MMS.ScheduleId FOR XML PATH('') ) as ObjectName , case when Recursive = 0 then 'False' when Recursive = 1 then 'True' else 'Undefined' end as "Recursive" , case when IsEnabled = 0 then 'False' when IsEnabled = 1 then 'True' else 'Undefined' end as "IsEnabled" , case when Status = 0 then 'Not Running' when Status = 1 then 'Running' else 'Running' end as "Status" , case when IsRecurrence = 0 then 'False' when IsRecurrence = 1 then 'True' else 'Undefined' end as "IsRecurrence" ,[Duration] ,[Comments] ,[User] ,[NextRunTIme] ,[LastRunTIme] FROM [OperationsManager].[dbo].[MaintenanceModeSchedule] as MMS with (NOLOCK)
Note that the object names are semicolon delimited to show you the systems that are included in the named maintenance schedule.
I hope you find this query useful in your daily SCOM routine.