Information on when a system is added to an existing MM schedule

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Need a query or way to see when a source was added to a maintenance mode schedule.

Environment

• DX Unified Infrastructure Management (UIM)
• Operator Console

Resolution

SELECT 
    ms.schedule_id, 
    ms.start_time,
    ms.duration,
    cd.dev_id,
    cd.cs_id,
    cd.dev_name,
    mwh.START_TIME AS TIME_ADDED
FROM maintenance_schedule ms
JOIN Maintenance_schedule_members msm 
    ON msm.schedule_id = ms.schedule_id
JOIN cm_device cd 
    ON cd.cs_id = msm.cs_id 
LEFT JOIN MAINTENANCE_WINDOW_HISTORY mwh 
    ON mwh.schedule_id = ms.schedule_id
   AND mwh.dev_id LIKE CONCAT(cd.dev_id, '%')
WHERE cd.cs_id IN (
    SELECT DISTINCT sub_cd.cs_id 
    FROM cm_device sub_cd 
    WHERE sub_cd.dev_name LIKE '%<hostname>%'
);