Need help building a query to show Mapped Applications Services without Business Applications

[CheshireKat]

Hello ServiceNow Team,

Does anyone have a query they use to show Mapped Application Services that don't have a corresponding Business Application record? 

I am interested in learning about how others track down this population.

Thank you.

[Sandeep132]

Hi @CheshireKat 

There is an OOB dashboard available called "CSDM Data Foundations" which provide you with reports on data quality around CSDM implementation. Please check this documentation for more information https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/product/configuration-manageme...

After your install the dashboard and run the necessary schedule jobs you will be seeing results under "Crawl" tab. Report name will be "App Services Missing Business App Relationship".

Hope this helps. Mark this solution if it resolves your issue.

Thanks,

Sandeep

[AndersBGS]

Hi @CheshireKat ,

you can utilize the CMDB query builder to create a query with zero relations between application service and business application 

start with the application service node and state none in the relation to business application.

.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders