Is there a way we can check the history of the maintenance schedule in UIM?
The query below shows history of maintenance schedule which is already performed, along with device IP address and name.
select distinct cm_device.dev_ip, cm_device.dev_name, MAINTENANCE_WINDOW.SCHEDULE_ID, MAINTENANCE_WINDOW.START_TIME, MAINTENANCE_WINDOW.END_TIME
from CM_DEVICE INNER JOIN MAINTENANCE_WINDOW
order by START_TIME desc;
If maintenance schedule is deleted from USM maintenance view, SCHEDULE_ID will have NULL value.