AnsweredAssumed Answered

Fetching Monitored Targets information From UIM DB

Question asked by Rajashekar Allala on Jan 31, 2017
Latest reply on Feb 5, 2017 by Garin

Hi All,

 

We are monitoring different databases using UIM DB probes. Our requirement is to query the UIM database to list the database names and the server names where the databases are hosted.

 

I tried fetching this information from S_QOS_DATA table using the below queries.

 

To list MS SQL Databases Information:

*******************************************

SELECT REGEXP_SUBSTR(TARGET, '[^\]+', 1, 1) DBSERVER,

                   REGEXP_SUBSTR(TARGET, '[^\]+', 1, 2) DBNAME

FROM S_QOS_DATA Where QOS Like 'QOS_SQLSERVER_DATABASE_STATE%' AND CI_METRIC_ID IS NOT NULL

 

To List ORACLE Databases Information:

*********************************************

SELECT REGEXP_SUBSTR(TARGET, '[^-]+', 1, 1) DBSERVER,

REGEXP_SUBSTR(TARGET, '[^-]+', 1, 2) DBNAME

FROM S_QOS_DATA Where QOS Like 'QOS_ORACLE_CHECK_DBALIVE%' AND CI_METRIC_ID IS NOT NULL

 

But these queries are taking long time to get the required information (say above 1 min). This is expected as S_QOS_DATA is a huge table in UIM DB which contains more records for each QOS.

 

As this query output is fed to other tool where the users select the data from a drop down. Because of this, it should not be recommended to use above query as it is long time to populate the information.

 

Is there any alternate table that we can query against or suggest an alternate method?

 

Regards,

Rajashekar

Outcomes