Trying to update a bulk of 'Service' in the incident record

[Suvronil Ghosh]

Hi Community,

I'm attempting to update a bulk of records in the incident table. For more specific I want need to update 'Service' in the incident form.  In the incident table, there's a field named "service," which is a reference field referencing the 'cmdb_ci_service' table. 

I've created one data source and a transfer map. By using these two, I'm able to successfully update the records in a large number of incidents. The updated records are visible on the form view and in the XML of each record. However, when I check the history of the record, the appropriate service value is not present, and the history does not capture the recent update on the record. Could someone help me find the root cause of this, and could the community suggest the appropriate steps to update a bulk of records? #itsm #incident

Thanks 

[Mark Manders]

Are you updating them all to the same service? Then you can also do a mass update from the list. If not, your approach is a good one. Updating records like this, however, does not update the history of the records, so your update will not be visible there. You could add a 'work_note' to your data source that updates the worknotes with 'incident updated because.....'
If you are able to do it from the list, your update will be visible, but if a lot of different services are updated, it will take a lot of time.

[Suvronil Ghosh]

Hi Mark, There are nearly 10k incidents where different Services need to be updated. I am trying to achieve this in a way there every record should update in the incident form as well as record history. 

Thanks