DX Unified Infrastructure Management

Hi,

Is there any option to get list of Robots under maintenance mode + option to find history of maintenance window of Robots.

please help.

Example query I use to have a list of devices currently under maintenance:

select distinct cs.name, cs.ip, cs.origin,ms.schedule_id, ms.SCHEDULE_NAME, ms.DESCRIPTION, max(CONVERT(VARCHAR(50), ms.START_TIME,111)) as 'Start Date',
max(CONVERT(VARCHAR(50), ms.START_TIME,108)) as 'Start Time', max(CONVERT(VARCHAR(50), mw.END_TIME, 111)) as 'End Date', max(CONVERT(VARCHAR(50), mw.END_TIME, 108)) as 'End Time'
from CM_COMPUTER_SYSTEM cs with(nolock)
INNER JOIN MAINTENANCE_SCHEDULE_MEMBERS msm with(nolock)  ON cs.cs_id=msm.CS_ID  
INNER JOIN MAINTENANCE_WINDOW mw with(nolock)  ON msm.SCHEDULE_ID=mw.SCHEDULE_ID  
INNER JOIN MAINTENANCE_SCHEDULE ms with(nolock)  ON msm.SCHEDULE_ID=ms.SCHEDULE_ID  
WHERE mw.END_TIME >=GETDATE()  
group by name,ip,origin,ms.schedule_id,ms.SCHEDULE_NAME,ms.DESCRIPTION

For history of maintenance schedule , you can try the below 

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;

For details see..

How to get History of Maintenance Schedule 

btw, I have a couple of ideas open on this to provide the option out of the box without running queries , please vote if it helps 

UIM - History of Maintenance Schedule 

UIM: Track user who created maintenance schedule  

Hey UIM Product Owners, this would be a very helpful feature to add since many are asking for this. What robots are part of which maintenance group(s), history of maintenance, upcoming maintenance windows.... etc

There is lots lacking with the Maintenance feature.