Hey All,
I'm trying to deliver a list relating the the following:
Servers x Service Commitments x Service Offerings
I was trying to do that by using CMDB Query Builder but I could not achieve it, is it something doable in CMDB query builder or do I need to build a DataBase view with joins?
The main value this solution would be adding is the cmdb admin can see which Servers are lacking service commitments
This is the structure I figured on Servicenow
[cmdb_ci_server] has a reference field to [service_offering] which is connected to a m2m table [ service_offering_commitment] to the service commitment table [service_commitment]
Any help would be highly appreciated
