Menu Close

Maintenance mode – tying the text of the category to the database

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:

 

image

 

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *