Disable alert for DB restoration state

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

DB restoration state is not required, there are many scheduled SQL job to perform DB restoration. While DB restore it’s an intermediate state for DB where alert is not required. Please let us know if there is any option to exclude the restoration (1) state as well along with online (0). As of now only online state (0) is excluded.

 

Environment

Release: Any UIM GA

Component: Sqlserver probe

Resolution

As of today that is not available OOTB with the probe GUI.

Can create one custom check point and write a manual query for both != 0 and restore, it will alarm

 

SELECT name as Database_Name, state_desc as Database_Status FROM sys.databases