We have had a long time where we have been unable to refresh DEV from PROD.

If we had, stuff like this wouldn't happen.

Here's what happened...

I had fruition build a workflow in DEV. We moved it to TEST. The assignment group didn't get assigned in TEST, but it worked properly in DEV.

The script to spot the differences and figure out how to reconcile

    var gr = new GlideRecord('sys_user_group');
    gr.addQuery('sys_id','ff7d513901daa0c094adf4b82250a606');
    gr.query();
    while(gr.next()) {
        gs.print("group name = " + gr.name);
    }

    var gr2 = new GlideRecord('sys_user_group');
    gr2.addQuery('name','STARTSWITH','INF');
    gr2.query();
    while(gr2.next()) {
        gs.print("group name = " + gr2.name + " and sysid: " + gr2.sys_id);
    }

Then to fix

I had to blow away the bad record for INF Telecom group from sys_user_group on DEV, and import the XML export from the record in TEST.

Then I needed to make a new update set, revise the workflow, save the changes, promote the changes in the update set to TEST. And update the requirement to mention the second update set.