Update bulk CI through background script

[vinod6]

I want to update 4000 records in the cmdb_ci table based on the Name and Class fields to update the Scope. I prefer to do this only through a background script, not a fix script. Please provide a background script for this—it will be helpful for me.
Thanks in advance.

[Rafael Batistot]

Hi @vinod6 

May you try to update via Excel template, it's more safe once that you have huge volume 

Import the Excel template

[Dr Atul G- LNG]

Hi @vinod6 

A count of 4000 is quite large. Why not use the Import Update method? It’s easier and doesn’t require any code.

Steps:

1. Go to the cmdb_ci table.

2. Select the CI records you want to update.

3. Right-click on any field and choose Import.

4. Download the Excel file for update.

5. Make the required changes in Excel.

6. Upload the updated Excel back into the system.

[Nikhil Bajaj9]

Hi @vinod6 ,

MY POV- you should use Import set/ Transform map to update the records as it is quite safe and easy.

If my answer helped you, please mark it- solution accepted. 

Regards,

Nikhil Bajaj

[Pratiksha]

What you are trying to update?