Retire bulk assets using excel

[raphaelflores]

Hi all, 

Have a request to set multiple devices (CI's) to Status: Retired. 
I've been given an excel spreadsheet with 400+ items to retire. The only information given on the spreadsheet is S/N, which I'm assuming is Serial Number and some IMEI's. See attached.

Does anyone have a script or method to do this rapidly? This would take seemingly way too long to do this manually. 

Thanks

[Mohith Devatte · Accepted solution]

Hello @raphaelflores ,

for this you need to use a concept called "transform maps"  which is used to load the data into service now and also update the records in service now

refer below link on how to do it 

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le...

PLEASE MARK MY ANSWER CORRECT IF IT HELPS YOU

[HugoFirst]

Hi @RaphaelFlores 

You already have great advice from Mohith Devatte, so mark his answer as correct if this works for you.  I want to expand on that advice and give you 2 thoughts to focus on:

1. In the transform map, se sure to set "Coalesce" to true for Serial Number.

2. Use a transform script to set the status to retired.  In my configuration, there are multiple status fields.  I recommend that you set all of them that apply: install_status, hardware_status and operational_status.

[raphaelflores]

Hi Hugo, 

That's about what I'm looking for. A few questions though - 

1. I have some items not showing from this excel sheet. A lot to go through. Will the items get created when I transform them in SN?

2. Am I looking at an onAfter script to update the status? What would this like? I'm still a bit of a novice with scripting.