Building a multi-table report using CMDB Query Builder

Jim O_Shea
Tera Expert

I'm attempting to build a report that lists Business Application owners for mapped database instances leveraging Query Builder.  I added the following tables to Query Builder:

 

- Business Application (consumes:: consumed by)

- Mapped Application Service (depends on::used by)

- Server (runs on:: runs)

- Database Instance

 

Application Owner is an attribute on the Business Application table.  Currently, we don't have good ownership documented on underlying CIs.  Which is why I'm trying to pull ownership off the business application and cascade that down to the underlying infrastructure CIs - in this case the database instances.  

 

Also, for some reason my consumes::consumed by relationship between business applications and mapped application services doesn't seem to exist when I specify that relationship type while adding the business application table in Query Builder.  

 

Appreciate any suggestions or feedback in building reports that leverage service mapping relationships.  I was also considering building a database view.  Would that be better?

Thanks,
Jim

0 REPLIES 0