For the sqlserver probe, client would like to get alert for the checkpoint database_state except 0 and 6

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

For the sqlserver probe, client would like to get alert for the checkpoint database_state except 0 and 6

Objective: The ability for the sqlserver probe: generate majoralarms for the checkpoint database_state: if state is not 0 and not 6

 

Environment

Release : 20.4

Component : UIM - SQLSERVER

Resolution

To do this the Admin Console configure GUI must be used since it is not supported via the IM console GUI. 

Based on the Customer requirement, we can follow the below steps to generate the alarm when the database state is neither '0' (online) nor '6' (offline).
Navigate to the probe configuration in Admin Console and select the 'database_state' checkpoint under the Checkpoints node.
Change the checkpoint condition to equals to '=' (by default, it is !=)

Navigate to the 'Monitors' section under the database_state checkpoint from the left panel, and update the thresholds for database states '1','2','3','4','5','7' and '10'. Remove the default threshold object created for database_state '0'. Save the configuration.