How do I create a three tier view using the CI Relations table?

Robert Campbell
Tera Guru

‎08-10-2023 09:53 AM

I need to create a view to show cmdb_ci_business_application -> cmdb_ci_service -> cmdb_ci.  This view does the first part but not the second part.

RobertCampbell_0-1691676868430.png

With the first 3 alone, I get the first part.  I've tried adding a third table of cmdb_ci_service [bus2] and tried bus2.sys_id = bus.sys_id and I've tried bus2.sys_id = rel.child & bus2.sys_id = rel2.parent.

RobertCampbell_1-1691677491697.png

 

 

 

0 Helpfuls
  • 258 Views
2 REPLIES 2

CMDB Whisperer
Mega Sage
Mega Sage

‎08-10-2023 10:01 AM

Have you looked at using the CMDB Query Builder for this instead of a Database View, or does your use case require a Database View?


The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.
0 Helpfuls

Robert Campbell
Tera Guru
In response to CMDB Whisperer

‎08-10-2023 10:18 AM

Yes. I can create a report with the query builder but I am unable to use interactive filters properly with data from query builder.

0 Helpfuls