How to pull filed from business application to application services

[Rutuja K]

Hi,

How to pull filed from business application to application services.

I want to pull a filed from business application table to application services list view.

Thank You!

Rutuja

[Swapna Abburi]

@Rutuja K 

Business Application is not a reference field on Application Service. Business Applications and Application Services are connected using CI relationships. I don't think so you can dot-walk to Biz app fields directly from App Service table List view. You can try CMDB Query builder or Reporting on CI relationship table to have both App Service and Biz app fields in single report.

[Tai Vu]

Hi @Rutuja K 

How are Business Applications linked to Application Services in your instance?

Within OOTB, their association is established through the CI Relationship [cmdb_rel_ci]. You can consider creating a Database view to obtain a holistic perspective between these tables.

Cheers,

Tai Vu

[Rutuja K]

Hi Tai vu,

Thanks for responding.

We are using OOTB configs.

can you please elaborate about database view and how to achieve it.

:Rutuja

[Rutuja K · Accepted solution]

Created Database view 

1. table = cmdb_ci_service, variable prefix = bs

2. table = cmdb_ci_business_app , variable prefix = bizapp, Where clause=  bizapp_number=bs_u_product_id