Use CMDB Query Builder to list business services down to application services

[stephenwinter]

Hello

I've been asked to map out the following from our CSDM deployment

Business Service -> Business Service Offering -> Application Service

I've tried to use CMDB Query Builder which works perfectly for business service offering -> application service.

However, because the business service table exists in the CMDB, query builder keeps trying to use the cmdb_rel_ci table for linking business service offering -> business service.

The issue with this is, CSDM uses a reference attribute OOB to link service offering and service. Therefore, trying to use relationships comes back with no results, and I can't find a route to using a reference attribute when both tables are in the CMDB

I've attached what it looks like to set-up a cmdb->non-cmdb relationship, and use can see it asks for the CI Reference Column.

But you don't get this option for CMDB-CMDB tables

Can anyone help on how to get this information out of the CMDB in one query.

[SiD2 · Accepted solution]

Hi @stephenwinter 

I guess the ref fields are only for non cmdb to cmdb tables otherwise you can dotwalk using the relations only.

Is it not possible to add the relationship type there and increase the level if it's not direct.

[stephenwinter]

Hello SiD2

Thank you for the information, I guess I'll raise an idea to add the ability to use the reference relationship between CI classes while there are classes which can be linked this way.