How to configure a sql_response profile that monitors active robots with cdm probe instances?
Article ID: 261060
Updated On:
Products
Issue/Introduction
- How can we configure the sql_response probe to monitors number of active robots with cdm probe instances within a UIM domain?
- The goal is to generate a sql_reponse probe alarm when the cdm probe count drops below an expected value.
Environment
- Any SQL_RESPONSE version and UIM configured with MS SQL Server database
Resolution
1. Run query below to validate the number of cdm instances with OC SLM -> SQL Query Editor, SQL Server Management Studio, or similar tool.
Note, that the result will vary if robots are added, deleted or robot/cdm probe are in a failed state.
select count (*) as count from cm_nimbus_probe package join cm_nimbus_robot robot on package.robot_id = robot.robot_id join CM_COMPUTER_SYSTEM ccs on robot.ip = ccs.ip and probe_name='cdm' and robot_active = 1
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 value returned
select count (*) as count from cm_nimbus_probe package join cm_nimbus_robot robot on package.robot_id = robot.robot_id join CM_COMPUTER_SYSTEM ccs on robot.ip = ccs.ip and probe_name='cdm' and robot_active = 1
5. Click on the Value menu, enable Alarm and QOS
6. Add a new alarm in the Alarm List; select count for Column, add appropriate threshold values and Message variables, Click OK.
7. Click on the QOS List icon and add a New QOS
8. Enter appropriate QOS values and OK to save settings
9. Wait several poll cycles and use Metric Views to confirm sql_response metrics are displayed under the robot with the sql_response probe
Additional Information
Feedback
