CMDB Query Builder - Technical Service Offering

[CW7]

Hi,

I am trying to use the CMDB Query builder to create a dynamic query that can be used in a Technical Service Offering.

The logic includes 2 CI classes; Server and MSFT SQL Instance. I am trying to create Technical service offerings for the the different environments and apply to the DB Instance. eg SQL Prod, SQL Test, SQL Dev. These can then have different criticality, support team, etc...

The logic relies on the environment of the server. If the server has a production environment then so will the database instance that runs on that server...

I have created the query however the results cannot be configured to exclude the servers and so cannot be used in in a dynamic CI group. The servers are part of another service offering and are supported by windows platform teams so I dont want to include them. I only want the instances.

The server is required for the logic to work in the query but should not be in the output, I only want the DB instances. 

[CMDB Whisperer]

I see both potential scenarios.  I think the "idea" that I would post (if I had access to post ideas, <ahem>) would be to add the ability to define a CMDB Group using the intersection (not the union) of two or more queries, or to just exclude certain query nodes from the actual results.

While in some cases I might want to use the query relationships to identify certain nodes, and ignore the nodes that I used to perform the query itself, in other cases it does make sense to include all of the nodes in the query.  I think this would be a great feature to add to CMDB Query Builder.