Is there a way to monitor CDM probe data being collected and alarm if expected amount is lower?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

How can we configure the sql_response to monitor the total QOS (a total of all cdm metrics currently collected within a UIM domain) collected by the cdm probe for the last hour?

The goal is to generate sql_reponse probe alarm when the expected cdm QOS count drops below an expected value.

Environment

Any SQL_RESPONSE version

Resolution

1. Run query below to validate the amount of CDM QOS collected in the last hour with OC SQL, SQL Server Management Studio, or similar tool.

Note, that the result will vary if robot are added, deleted or robot/cdm probe are in a failed state.

select table_id from S_QOS_SNAPSHOT WHERE sampletime > dateadd(hour, -1, getdate()) and table_id in (select table_id from S_QOS_DATA where probe = 'cdm')

2. Create a database connection to the UIM Database on the sql_response probe

3. Create a new profile and select the UIM Database connection

4. Click on the SQL Query menu and enter the query below in the Simple Query field and run Test to confirm that rows are returned.

select table_id from S_QOS_SNAPSHOT WHERE sampletime > dateadd(hour, -1, getdate()) and table_id in (select table_id from S_QOS_DATA where probe = 'cdm')

The following Test pop up message can be ignored as interface only displays 50 rows

5. Click on the Row count menu, enable Alarm, QOS and set Operator to <=

Set the appropriate threshold values and save the profile.

 

5. Wait server poll cycles and confirm if the SQL Server device in OC displays the sql_response metrics