generate report on affected and impacted ci's of a change request

[Hiren Potu2]

i want want to generate one single report which will give me all the affected and impacted Ci's of the change request.

[SanjivMeher]

task_ci stores the affected/impacted CIs. You can run a report on task_ci table.

and task_cmdb_ci_service stores the impact/affected business services

[tsquare]

How do I get the report to only show 1 instance of the change request. There are change numbers per ci. I have them grouped by the task but when I try to download it I get all of the data.

[Hiren Potu2]

Hi sanjiv,

thanks for your reply.

but i need a single report where i can target one table on which i can get the affected and impacted Ci's.  

[SanjivMeher]

You may need to create a database view joining the task_ci and task_cmdb_ci_service table. 

Check below links which may help

https://community.servicenow.com/community?id=community_question&sys_id=d62b47eddb5cdbc01dcaf3231f9619f6&view_source=searchResult

https://community.servicenow.com/community?id=community_question&sys_id=88c00b65db98dbc01dcaf3231f9619b3&view_source=searchResult