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!
