Re: filter out duplicated DB by using TQL of uCMDB
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.