search cancel

use custom checkpoint for monitoring different items as separate targets with sqlserver/oracle_monitor

book

Article ID: 254309

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We would like to create, using sqlserver and oracle_monitor probe some custom checkpoints, using a custom query to monitor the counts of some jobs based on failed status and store the count value.  

The challenge is that there are a very large number of different items to monitor (200+) in this case jobs.
Is there a way to use only one checkpoint to monitor all the different jobs and store the count separately?

Environment

Release : UIM 20.x 

Probe: sqlserver, oracle_monitor any version 

Cause

Guidance

Resolution

This is possible using a custom query checkpoint and defining the appropriate variables and creating a named customer QOS for your custom query. 

 

For this exercise I have set this up with the sqlserver robe but this is applicable to the oracle_monitor probe too as they are structured similarly. 

 

For simulating your scenario I have used the following query:

USE CA_UIM   
select profileName,  count (*) as count from SSRV2Profile group by profilename

 

Which provides the following output: 

 

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=CrOJi/tpryxtBx+ohGOFFw==

We will create a monitor to store the count of each of the grouped SSRV2 profiles  (MCS has nothing to do and only taken as example of table to extract and monitor) 

 

Once you create the query it's important to set the Row identification and the message variables: 

 

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=T0js0wQwvOTUbq6gvMH2OA==

 

 

And Set the Variables

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=IQkjbXuoaI0RViFqeEOkiw==

 

It is also important to create the QOS in General TAB >>  QOS List where you select the metric (in this case the "count" is the metric)  

 

 

After this one single target is created for each "ProfileName" 

 

The below is just the output from my DB which shows different targets created for the custom QOS Created:

 

And here is how they are visible in PRD: 

 

Additional Information

oracle (Oracle Database Monitoring) Release Notes (broadcom.com)

sqlserver (SQL Server Monitoring) Release Notes (broadcom.com)

Attachments