Hi, I have a requirement to retire the communication devices using spreadsheet. The problem is we have only user id in spreadsheet. From this user id we pull the sysid or name and match with the assigned to field in communication table. Because of data redundancy we have 2 to 3 communication device records associated with one user id. We need to update the duplicate records also to retired. please share your ideas to retire these devices. Thanks in advance.
Hi, in your transform map, use an onAfter transform script with a GlideRecord. You can look up all the needed devices by the User sys_id, and change their status/deactivate, whatever is needed.
