List of probe instances monitored that have current data in UIM via query

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are currently monitoring Oracle, MSSQL, Sybase, DB2 instances in UIM. The customer requires a listing of all DB Instances currently monitored in UIM. 

Environment

• Release: UIM 20.3 or higher
• Component: UNIFIED INFRASTRUCTURE MGMT

Cause

• query guidance

Resolution

SELECT

def.source as robot,

rob.hub,

def.probe,

cb.met_description,

def.target,

def.qos,

snap.samplevalue,

snap.sampletime,

def.r_table,

def.table_id,

def.probe

FROM S_QOS_DATA AS def

join cm_configuration_item_metric cm on cm.ci_metric_id=def.ci_metric_id

join cm_configuration_item_metric_definition cb on cm.ci_metric_type=cb.met_type

JOIN S_QOS_SNAPSHOT AS snap ON snap.table_id = def.table_id

join cm_nimbus_robot AS rob on rob.robot=def.source

WHERE snap.[sampletime] > dateadd(hour, -5, getdate())

AND def.probe in ('mysql','sqlserver','db2','oracle','sybase')

order by def.target, def.probe asc

Additional Information

The S_QOS_SNAPSHOT table stores the currently collected samplevalues so if QOS is being collected that would end up in the results.

To view the snapshot table and how far the data goes back, run:

select * from S_QOS_SNAPSHOT order by sampletime ASC

You could comment out the

--AND def.probe in ('mysql','sqlserver','db2','oracle','sybase')

and it will pull everything even unrelated to DBs.

or change it and limit it to a single database, e.g.,

AND def.probe in ('sqlserver')