Reports and Extracts

[rahulgoyal2]

I am trying to pull a report from ServiceNow. I need all the changes occurred on a specific CI. I have more than 500 CI and every CI should have few change number associated. How can I extract them all? Please suggest.

[AndersBGS]

Hi @rahulgoyal2 ,

Do you have setup a reference field on the change_request table which refers to the CI? If yes, then you can run a simple report from the change_request table with the CI in the conditions

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders.

[rahulgoyal2]

I have that setup however when we have multiple CIs attached in the change request then in the report it only shows only one CI . How I can I get all the affected CIs in the report for every change?

[Prabu Velayutha]

Hi @rahulgoyal2    To see all the associate CI to change request you can report on "TASK_CI" table it will list all associated CI to a Change Request/Task.

You can dot walk to the task field  and set filters, task column contains all the reference change record numbers.  It should fulfil your requirement. If you any question kindly revert.

If my response helps to solve your issue. Kindly mark it as helpful & accept the solution. It will be helpful for future readers!

Please find the Task_CI table list view in the screenshot below