Welcome to Community Answers

Question

Solved Maintenance Mode Dash Board

1

rtbywalski 243 Rep. 12 Feb, 2018

Has anybody ever created a dashboard to show what is in maintenance mode. I was thinking that might be a good one to set up so people can know what is being worked on. Any tips on how to do this.

dashboards scom-2016 squared-up

rtbywalski edited question 07 Jun, 2018

Best answer

1

MatthewBrown 18 Rep. 13 Feb, 2018

Hi rtbywalski, I also found that having a Maintenance mode dashboard to be of value. Here is what I did. Best of luck. Matthew

I created a Dashboard named ‘Maintenance Mode History’ with two sections “Objects in Maintenance Mode” and “Maintenance Mode History”. The first section is a Status Tile (Icons) scoped to Class ‘Windows Computer’ with Critera “InMaintenanceMode=1 OR HealthState=0”. The second section is a SQL Tile (grid). Connection string “Data Source=[your data source];Initial Catalog=OperationsManager;Integrated Security=True”. Here is my SQL query:

Use [OperationsManager]
SELECT FullName as [object in maintenance],
CONCAT(CONVERT(VARCHAR(24),StartTime, 113), ‘ UTC’) As ‘start time’,
CONCAT(CONVERT(VARCHAR(24),ScheduledEndTime, 113), ‘ UTC’) As ‘scheduled end time’,
dbo.MaintenanceMode.[User] as [user],
Case ReasonCode
When 0 then ‘Other (Planned)’
When 1 then ‘Other (Unplanned)’
When 2 then ‘Hardware: Maintenance (Planned)’
When 3 then ‘Hardware: Maintenance (Unplanned)’
When 4 then ‘Hardware: Installation (Planned)’
When 5 then ‘Hardware: Installation (Unplanned)’
When 6 then ‘Operating System: Reconfiguration (Planned)’
When 7 then ‘Operating System: Reconfiguration (Unplanned)’
When 8 then ‘Application: Maintenance (Planned)’
When 9 then ‘Application: Maintenance (Unplanned)’
When 10 then ‘Application: Installation (Planned)’
When 11 then ‘Application: Unresponsive’
When 12 then ‘Application: Unstable’
When 13 then ‘Security issue’
When 14 then ‘Loss of network connectivity (Unplanned)’
End as [reason for maintenance],
Comments
FROM BaseManagedEntity
INNER JOIN
MaintenanceMode ON BaseManagedEntity.BaseManagedEntityId = MaintenanceMode.BaseManagedEntityId
WHERE IsInMaintenanceMode = 1
AND FullName like ‘Microsoft.Windows.Computer:%’