Use the example queries as models for building your custom CMDB queries and Service Mapping queries.

CMDB query example — servers connected to database
Use this example to build a CMDB query to find all servers with a connection to a database.
CMDB query example — critical application services
Use this example to build a CMDB query to find all critical application services, and their owner.
CMDB query example — application services with incident or change
Use this example to build a CMDB query to find all application services for which there is an incident or a change request. Results are returned for either the application service itself or any CI within the service.
CMDB query example — hardware with Windows installed
Use this example to build a CMDB query to find all hardware in my service offering that has Microsoft Windows installed.
Service Mapping query example — Linux servers in services
Use this example to build a Service Mapping query to find all Linux servers in services.