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:

 

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

Comments (2)

  1. Chris says:

    What about determining who put the server into maintenance mode, as in a DomainAlias format?

  2. Hemant says:

    Hi Kevin,

    I did search a while to find the exact post for my problem, but could not hence raising it here. I have a problem in SCOM. After I put the node in outage and remove it from outage the alerts get created in the event viewer for events (specially Biztalk) during the outage period becomes active in SCOM console while ideally I think it should not report alerts to console for events that occured during the outage period.

    Also checked that the maintenance mode events 1215 and 1216 are getting created in event viewer of the node for outage duration at correct times. Any advice would be high appreciated.

    Many thanks in advance,

    Hemant

Skip to main content