Bulk load capbility mappings to business applicaitons

Patrick Slatter
Tera Guru

Hello!

Looking to bulk load business capability mappings to Business applications. 

I have a spreadsheet that contains capability to business application  values. 

 

What table holds this information? Or where is the best way to set these in bulk?

PatrickSlatter_0-1676570414359.png

 

 

Thanks!

1 ACCEPTED SOLUTION

mcastoe
ServiceNow Employee
ServiceNow Employee

Jim has is right.   The Relationship type is Provided by:: Provides where the Business Capability is assigned to the parent on the cmdb_rel_ci record and the Business Application is the child.   When you build the transform, you will need field map records: Business Capability -> parent, Business Application -> child, and the Type -> a scripted field map that returns the sys_id for the Provided By::Provide relationship type which are defined in the CI Relationship type table [cmdb_rel_type].   The field maps for capability and application can look up by name if, and only if names are unique which is not always the case with Capability models.


Here is an example Transform map

mcastoe_0-1676921183236.png

the type field map:

mcastoe_1-1676921237514.png

 

You may need to script the Application (child) and Capability (parent) columns as well to lookup by name.  I always make the choice action reject so if the capability or application is not found.

mcastoe_2-1676921458406.png

 

View solution in original post

4 REPLIES 4

Jim Palmer
ServiceNow Employee
ServiceNow Employee

See:
https://docs.servicenow.com/bundle/tokyo-it-business-management/page/product/application-portfolio-m...

 

Business Application CIs are linked to Business Capabilities and Information Objects via the CI Relationship table [cmdb_rel_ci].

So, load the data, setup a transform map on [cmdb_rel_ci] and match the 2 records with the correct relationship type (Provides::Provided by for capabilities and Uses::Used by for information objects) and transform.

Note: I always forget which way the relationship goes, so double check you have the correct relationship type & the parent/child CIs.

mcastoe
ServiceNow Employee
ServiceNow Employee

Jim has is right.   The Relationship type is Provided by:: Provides where the Business Capability is assigned to the parent on the cmdb_rel_ci record and the Business Application is the child.   When you build the transform, you will need field map records: Business Capability -> parent, Business Application -> child, and the Type -> a scripted field map that returns the sys_id for the Provided By::Provide relationship type which are defined in the CI Relationship type table [cmdb_rel_type].   The field maps for capability and application can look up by name if, and only if names are unique which is not always the case with Capability models.


Here is an example Transform map

mcastoe_0-1676921183236.png

the type field map:

mcastoe_1-1676921237514.png

 

You may need to script the Application (child) and Capability (parent) columns as well to lookup by name.  I always make the choice action reject so if the capability or application is not found.

mcastoe_2-1676921458406.png

 

can we map the business application to a taxonomy nodes in a bulk way instead mapping each business application seperately? in a business application table can we update in a bulk in alist view or something?

Doron Orbach
ServiceNow Employee
ServiceNow Employee

hi,

 

See also this post from our product success, that discuss also how to load capabilities from APQC. This might help you:

 

https://www.servicenow.com/community/apm-articles/application-portfolio-management-start-your-apm-jo...

 

Thanks,

Doron