Database View of Incident table and CI Relationship Table

[naveenahr]

Hi,

How to create the Database view of Incident and CI Relationship table.

we have to see the parent CI of the particular CI which we selected while creating the Incident.

Please help.

Thanks in advance,

Naveena

[SanjivMeher · Accepted solution]

You can create a database view by navigating to System Definition->Database view

First table should be incident with name 'im'. Add view fields such as sys_id, cmdb_ci, short_description etc.

Now create the 2nd table view record on CI relationship table with name 'cirel'. Add view fields such as child, parent to it. And add the condition im_cmdb_ci==cirel_child

[naveenahr]

Hi Sanjiv,

I tried, but it is showing empty table, when I try it.

is that I'm missing something?

Please help,

Thank you,

Naveena

[SanjivMeher]

Can you post a screenshot of your database view?

[naveenahr]

Hi Sanjiv,

I didn't select the fields to display in table,

Now it's working.

Thank you,

Navenea