How to get affected CIs from change_request table

[erika7]

Hello all. I'm trying to get all affected CIs attached to a change request. I'm sending a get request to https://ven01523.service-now.com/api/now/table/change_request, which returns all changes and the main CI under cmdb_ci, however it doesn't return all the affected CIs attached to the request. Any idea how to get all those affected CIs that are attached to the change? Any help is much appreciated!

[sethivarun · Accepted solution]

the table you need to query is task_ci , since that is the table where affect CI are stored