Script to create incident

[Rahul Kathuria]

Hi Everyone,

We have a spreadsheet that had a list of servers in Column A, could you auto create a priority E ticket for every 10 servers in that spreadsheet???   For example, we have 800 servers that need to be queried for patch levels. We want to create 80 tickets where each ticket includes 10 servers.   All tickets would have the same attributes…priority E, same assignment group, etc.

further, we would like to ink those 10 servers in the CI tab of the incident record.

Thanks,

Rahul kathuria

[Rahul Kathuria]

Hi Chuck,

As a workaround, i created a dummy table and used it as a target table. So when i am running my Transform map, 723 records are going into that dummy table and 73 incident records are coming into incident table. They are filtered now in separate tables and looks good.

However, there is 1 problem. i don't see the configuration items listed in the CI's affected tab. But when i hit the edit button, then i can see the sys id's. how should i make it visible at the form itself?

[Rahul Kathuria]

Hi Chuck,

It seems newTc.ci_item = target.sys_id; is not working as expected. I see the sysid's only when i click on edit button however do not see anything on the incident page.

Thanks,

Rahul