Application Service that do not have relationship to Business Application

[Rairai31]

Hi,

Can you please help me to create a report to see all app services which don't have a relationship to a business application.

I tried to use sn_getwell_app_svc_missing_biz_app table but still I am able to see Application Services which have relationship to Business Application. What can be a good approach for this like the ideal scenario would be a report of all the application services, and a column for the Business Application 'Name' that it relates to i.e. it's Parent. Thank you.

[AndersBGS]

Hi @Rairai31 ,

You need to utilize the CMDB Query Builder to get the view. 

1. Create a new query:

2. Create the dependency map without relation:

This will give you a view of Application service which are missing mapping 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 

[Rairai31]

This is awesome! Thank you very much @AndersBGS.

[Mathew Hillyard · Accepted solution]

The CSDM Data Foundations dashboard contains exactly this report, within the Crawl tab already. It is a free Store app install - CMDB and CSDM Data Foundations Dashboards.
If you are doing any work within CSDM I strongly recommend using the CSDM Data Foundations dashboard.

[Rairai31]

This is exactly what we need! Thank you very much @Mathew Hillyard.