need help in getting database instance orphan records through database view

[priyanka chodip]

Hi,

my requirement is to get the database instance orphan records through database view, I have never worked on it.
I have added relationship table and database instance table but the issue is am confused with the where clause.
if anyone has any idea of getting orphan data please let me know.

Thankyou,
Priyanka

[Jaspal Singh]

Hi,

Try blow for cmdb_ci_db_instance where clause

db.sys_id=rel.parent || db.sys_id=rel.child

& Left join: True

[priyanka chodip]

Hi Jaspal,
I tried but its taking forever to load so i cancelled the transaction.
do you have any idea why?

[Jaspal Singh]

Becasue of No. of records. You can set the Left Join to False and load.

[priyanka chodip]

its weird even if i set left join to false, its taking lot of time to load. i waited more than 10 min and its not getting the records.