DX Infrastructure Manager

Expand all | Collapse all

Getting list of servers in USM maintenance mode

  • 1.  Getting list of servers in USM maintenance mode

    Posted 02-29-2016 11:00 AM

    Is there a call back to get the current listing of servers in the USM maintenance mode? We currently do this by getting the robot's status but the USM maintenance mode doesn't seem to affect an individual server's status.



  • 2.  Re: Getting list of servers in USM maintenance mode

    Posted 02-29-2016 12:29 PM

    I found this on another posting and it returns the list of servers but it'd still be easier to work with a callback or api.

     

    select distinct cs.name, cs.ip, cs.origin, ms.SCHEDULE_NAME, ms.DESCRIPTION, CONVERT(VARCHAR(50), mw.START_TIME,100) as 'Start Time', CONVERT(VARCHAR(50), mw.END_TIME, 100) as 'End Time' from CM_COMPUTER_SYSTEM cs 

    INNER JOIN MAINTENANCE_SCHEDULE_MEMBERS msm 

    ON cs.cs_id=msm.CS_ID

    INNER JOIN MAINTENANCE_WINDOW mw 

    ON msm.SCHEDULE_ID=mw.SCHEDULE_ID 

    INNER JOIN MAINTENANCE_SCHEDULE ms 

    ON msm.SCHEDULE_ID=ms.SCHEDULE_ID 

    WHERE mw.END_TIME >=GETDATE()