Our CMDB applications are associated with our business process records via related items.   I wanted to bring this into Apptio to tie App table to the business process table however I don't want to bring in the entire CI table.  Any ideas on how this could be done?  

Hi Michael!  Could you create a report off the CI table in ServiceNow, filter it down to just the line items with apps, and then ingest that report using an API?

[Linking the question from the Datalink space here as well.]

Our CMDB applications are associated with our business process records via related items.   I wanted to bring this into Apptio to tie App table to the business process table however I don't want to bring in the entire CI table.  Any ideas on how this could be done?  

Our CMDB applications are associated with our business process records via related items.   I wanted to bring this into Apptio to tie App table to the business process table however I don't want to bring in the entire CI table.  Any ideas on how this could be done?  

Hi Michael,
I assume from your description that the associations are records in cmdb_rel_ci. This table can grow very large and most of the records are not required to support Apptio allocation and build logic as they support other ServiceNow needs.
There are two options that I am aware of you can pursue here:
1. As @Jenny Franklin has suggested, create a report in ServiceNow based on the cmdb_rel_ci table that filters to just the records you require. This has the advantage of being able to bring in additional metadata around the CIs being related, however it does mean that you will not get the sys_id values for the CIs. If you are using sys_id in your configuration you will need to somehow link the CIs back to these values.
2. The ServiceNow APIs do support "dot walking". This means that you can actually filter cmdb_rel_ci through the API call itself and bring in the native table cut down to the records you require.
eg. 

api/now/table/cmdb_rel_ci?sysparm_display_value=false&sysparm_exclude_reference_link=true&sysparm_fields=parent%2Cparent.number%2Cchild%2Cchild.number%2Csys_id%2Csys_created_on%2Cparent.sys_class_name%2Ctype%2Cchild.sys_class_name

&sysparm_query=parent.sys_class_name=cmdb_ci_service_auto^child.sys_class_name=cmdb_ci_service_auto

This format tells ServiceNow to bring in certain fields from cmdb_rel_ci and the joined tables on the parent/child references. The "sysparm_query" sections tells ServiceNow to filter to where both the parent and child classes belong to cmdb_ci_service_auto. If you can identify which classes you require for your relationships you can use something similar here.

Please reach out if this is what you had in mind and need more assistance here.

Regards

Our CMDB applications are associated with our business process records via related items.   I wanted to bring this into Apptio to tie App table to the business process table however I don't want to bring in the entire CI table.  Any ideas on how this could be done?