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

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

book

Article ID: 235626

calendar_today

Updated On:

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')