How to create a custom dashboard that shows the servers in an active maintenance schedule

Document ID : KB000072693
Last Modified Date : 12/03/2018
Show Technical Document Details
Question:
There is the need to have a dashboard showing all the systems in an active maintenance schedule, but there isn't one.
How can one be created? 
Answer:
1- The first thing needed is a query that will show all the systems in an active maintenance schedule, and that is available in this tech doc. 
How to run a query to show devices in maintenance mode
Document ID:  KB000033948
2- Then UMP > Design > Dashboard Designer > New > drag 'SQL Table' over from the right 
3- On the right click the wrench icon 
4- Scroll down to Data Source > Type > SQL 
5- Click the + icon 
6- Enter a name 
7- For Database select nis 
Type: SQL statement 
Query from KB000033948
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() 

Now save the dashboard.