Maintenance mode – tying the text of the category to the database
I havent seen this discussed before – so I figured I would post this.
In the OpsDB and DWDB – we keep some tables names MaintenanceMode and MaintenanceModeHistory.
When you place an object into maintenance mode – we will log a row in the database for this object. You could potentially write reports against this data in the data warehouse, and report on MM history.
From the following query:
select * from dbo.vMaintenanceModeHistory
There is a column named “ReasonCode” This has a numeric value. However – in the UI – this correlates to the “Category” that you must select when you place an object into MM:
Here is a table which sorts out the numeric reason code vs the text in the UI:
| Other (Planned) | 0 |
| Other (Unplanned) | 1 |
| Hardware: Maintenance (Planned) | 2 |
| Hardware: Maintenance (Unplanned) | 3 |
| Hardware: Installation (Planned) | 4 |
| Hardware: Installation (Unplanned) | 5 |
| Operating System: Reconfiguration (Planned) | 6 |
| Operating System: Reconfiguration (Unplanned) | 7 |
| Application: Maintenance (Planned) | 8 |
| Application: Maintenance (Unplanned) | 9 |
| Application: Installation (Planned) | 10 |
| Application: Unresponsive | 11 |
| Application: Unstable | 12 |
| Security Issue | 13 |
| Loss of network connectivity (Unplanned) | 14 |
