Recieving alerts from Maintenance servers in SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Is there a way to export the list of maintenance servers and the associated Maintenance schedule?

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Please run below SQL query against SAMStore DB

select SC.ScheduleID, SC.Description, SCR.CIID from Schedule SC, ScheduleRelationship SCR
where SC.ScheduleID = scr.ScheduleID

From the above query result, you may identify the Maintenance Schedule name and then remove CIs from them