Report on Affected CI's

[Blaze2]

I have a request to report on Affected CI's from a Change request.

In Test I was able to find Affected CI table, but it is not in Production.

The Report that I want would give me something similar to below. (Mind you it is not giving me the result, but it is the format that I want.)

I would ilke the affected CI's on the left, and the corresponding Change Request on the Right.

Anyone know what I should try, or even how to move the table over from Test to Prod? I tried exporting to XML, but it was not successful

[Chuck Tomasi · Accepted solution]

Hi Blaze,

You need to select the columns from the column picker on the right of the header.

Also, double check the table. You are looking at one for service management CIs affected, this is different than the base table task_ci (Affected CIs.)

By default, Change Request uses task_ci.

[Blaze2]

Thanks Gents,

I had been looking for the table name and was not sure which was which. I tried to figure it out, but we needed the report "2 weeks ago" and knew you all would be able to help.

Thanks again.

[Abhinay Erra]

The table for this is "task_ci"

[ajdiii]

I tried your solution but no luck.  Just to clarify,  I have 1 change number with 100's of Affected CI's.  I want to run a report on that Change number to display every Affected CI.  I do not see an option in CI_Task or anywhere else.  Can you provide any help?