CSDM Query: Biz App to Software Product

[wicky05926088]

Hi all,

I need to build a query to identify which Business Applications are utilizing a specific Software Product (e.g., Kafka).  Best possible way for all may be 100k software products,

Based on our CSDM framework, tracing this requires traversing depends on-hop relationship:

1. Business Application (cmdb_ci_business_app) -> Consumes ->

2. Application Service (cmdb_ci_service_auto / cmdb_ci_service_discovered) -> Contains / Depends on ->

3. Software Product (e.g., Kafka installed on the underlying infrastructure)

My ask: What is the most performant and maintainable way to identify and query multi-hop path for all the software products in ServiceNow?

• Would setting up a custom Database View joining these tables and cmdb_rel_ci be more efficient?

Any insights on best practices for querying this architecture would be appreciated.

Thanks,

Query multi-hop CSDM relationships: Mapping Business Applications to underlying Software Products

#ITAM #ITOM #SAM #CMDB #CSDM