UCMDB and UD Practitioners Forum (Previously CMS)
cancel

filter out duplicated DB by using TQL of uCMDB

SOLVED
Go to solution
Highlighted
chi.zhang
Honored Contributor.

filter out duplicated DB by using TQL of uCMDB

Hello there:

I have a scenario to filter out CIs in uCMDB, please help to find a clue on that.

For example: there is a host h001, it is linked with DB instances db001,db002,db003,db001.domain.com, db004,db005.

We regard db001 and db001.domain.com the same CI. So we want to create a TQL to show how many such records we have (a view just show h001, db001 and db001.domain.com).

How should the TQL be addressed?

 

 

P.S. This thread has been moevd from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

3 REPLIES
NagendraPaladi
Honored Contributor.
Solution

Re: filter out duplicated DB by using TQL of uCMDB

Hi,

Based on one instance we will not be able to understand the duplicated DB CI's senario. For this you need to gothrough all the senrios.

For the above senario which you have specified we can make create a TQL with a virtual join.

New TQL --> drag two DBs --> Create a virtual join between these --> Condition will be Display Label of DB1 is a substring of Display Label of DB2 --> Drag the Host CI and create a contains relationship with the DBs.

Regards,
Nagenda Swamy.
chi.zhang
Honored Contributor.

Re: filter out duplicated DB by using TQL of uCMDB

That is great. thanks indeed for your answer.
chi.zhang
Honored Contributor.

Re: filter out duplicated DB by using TQL of uCMDB

solved