NM: Updating SQL back-end user records (4332035)

This article to mainly for FTC calls where Binary Tree needs to update the Back-end record for FTC since they do not have permissions to do so.

Here are the scripts we use to assist FTC with SQL remediation.

Update Migration Status

Log into SQL and run the following queries.
First find the user and confirm the Key is correct

SELECT * FROM [NotesMigrator_CMT].[dbo].[CMT_User] Where [Key]='<CMTKey>'

Run this queue to update the Status field.

Update CMT_User Set Migration_Status = 'Migrated Successfully' Where [Key]='<CMTKey>';

Updating the Migration Group name

Updating an entire group of users to another group

UPDATE CMT_User SET Migration_Group='A' Where [Migration_Group]='B'