We're looking and standardizing SAM at our company which is long overdue. However we used that field as the username component in JIVE and that ties to the External ID. Updating the usernames can be scripted. However the External ID needs to be cleared since this process will likely bring in duplicate accounts. I have a tool to synch those accounts but clearing External ID is manual in that process.
My starting point is to test pulling a person with a GET and trying to modify the External ID field with a PUT. As shown with this user who has no External ID.
Alternatively is it easier to do a database query? (we're using the PostgreSQL backend) Figured I'd reach out see if anyone has any direction for me in this endeavor.