Servers x Service Commitments x Service Offerings - CMDB Query Builder?

Vinicius Luz1 — Mon, 10 Feb 2025 19:47:15 GMT

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

question Servers x Service Commitments x Service Offerings - CMDB Query Builder? in CMDB forum

Servers x Service Commitments x Service Offerings - CMDB Query Builder?