How to connect a Business Application with its Business Capabilities?

[MEBoatman]

I have been asked to create an export from ServiceNow containing certain business applications. As part of that, they want to know which business capabilities each business application provides. I am well versed with exporting from the Business Applications table. No issues there. I also know how to export Business Capabilities. What I'm trying to understand is where to find the relationships between Business Applications and Business Capabilities. I know about the cmdb_rel_ci table. But it's not clear to me how to determine which of the relationships in that table represent Business Application to Business Capability relationships. We have almost 7M relationships!  I'm totally fine creating the final deliverable outside of ServiceNow - I'm pretty good with Excel and this is a one-time ask.

I know I can find these relationships in the EA Workspace, Business Portfolio view. But I don't know how to create an export from there...

Any help would be appreciated!

[Dr Atul G- LNG]

Hi @MEBoatman 

The standard CSDM relation of BA and BC is like this. You can go via this relationship type.

[MEBoatman]

Thank you. I have seen that chart before. Am I correct in assuming that there is no way to know which of the

Provided By::Provides relationships relate to Business Capabilities to Business Applications?

[Dr Atul G- LNG · Accepted solution]

Try this way

[Jonathan Schnei]

There are a few ways you can generate this list but there is an OOB option.

Use the CMDB Query that comes with EA. This requires that you first execute the scheduled job Business Applications providing a Business Capability. After you execute that job use the filter navigator to find Enterprise Architecture > CMDB Query Builder > Business Applications Providing a Business Capability. This will open a bar report of the BA providing a BC for the specific query. Change the report type to a list, add the fields you want to see to the list, and export the data. Voila.

Alternatively, this query is essentially just a report on the cmdb_rel_ci table where you add filter conditions for relationshtip type, parent.class and child.class so that you are only seeing the provides/BC/BA data.