How to get History of Maintenance Schedule

Document ID : KB000046514
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

Is there a way we can check the history of the maintenance schedule in UIM?

 

Answer:

 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
ON CM_DEVICE.dev_id=MAINTENANCE_WINDOW.DEV_ID
order by START_TIME desc;

 
If maintenance schedule is deleted from USM maintenance view, SCHEDULE_ID will have NULL value.