We are currently monitoring Oracle, MSSQL, Sybase, DB2 instances in UIM. The customer requires a listing of all DB Instances currently monitored in UIM.
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')