Find parent and child table name from a report

[Rahul Gaur]

Hello All, 

The attached 2 screenshot are of 2 different reports.

In this report "Primary parent.Managed by" is being called out from a different table. Referred as Primary Parent.

I would like to know and learn, how can I find the name of Primary parent table?

Similarly 

in this report "Parent.NBS Sys ID", "Parent.Class", "Child.NBS Sys ID" and "Child.Class" are being called out from a different (Parent and Child) tables.

I would like to know and learn, how can I find the name of Parent and Child table?

[AndersBGS]

Hi @Rahul Gaur ,

From what I can see from your screenshot is, that your reports are based on the cmdb_rel_ci table which is a many to many table. Try looking up this table from your application menu, then it will give you a pretty good overview of what it contains (class = CMDB table extension e.g. cmdb_ci_computer

[Rahul Gaur]

Hello AndersBGS

Thank you for responding.

Regards

Rahul Gaur

[Rahul Gaur · Accepted solution]

Hello All, 

In the first report screenshot.

I have checked Table (via sys_db_object.list) to see the table named “Service” (cmdb_ci_service) and column names in it.

I found that the “Primary parent” (parent) is listed as a column and referenced to another table named "Configuration Item" (cmdb_ci).

In the second report screenshot.

I have checked Table (via sys_db_object.list) to see the table named “CI Relationship” (cmdb_rel_ci) and column names in it.

I found that the “Parent” (parent) and “Child” (child) are listed as column names and referenced to another table named "Configuration Item" (cmdb_ci).

I feel this is the information I was looking for.