Database view between cmdb_ci and cmdb_rel_ci tables

[geet]

Hi All,

I am trying to create a database view by joining cmdb_ci & cmdb_rel_ci tables.

Purpose of this join is to find out which all CI have got relationship created and which all doesn't have relationship yet.

I created a database view as follows but it is not working. When I try it, it says no record to display.

Please advice what is wrong here?

[Jaspal Singh]

Hi Geet,

Try below

[geet]

Hi,

I tried it but the transaction getting failed everytime and it doesn't load the data.

Please suggest if it can be implemented in another way.