Update records assignment group in bulk

[Pat Slattery]

Morning, 

 Im looking for some guidance in the best practice around updating assignment groups to a new name. I have been tasked with changing the name of certain assignment groups, and need them to update on both current and past records. 

I need this to update the name and NOT fire any notifications, as we do not want to re notify groups of all their past and present tasks (Incidents, changes, requests, etc.)

Should this be done by changing the name on the sys_user_group table? Or should a new group be created and then a fix script run to query and re assign the items from task table. My struggle is that I need it to suppress the notification.

Any guidance would be greatly appriciated

Thanks!

[vinothkumar]

If you change the name of the group in group table(sys_user_group) table, it will be updated in all the places where the group was referenced and you don't need to update any where.

Everywhere it will be referenced with sys_id only. 

[Andrew Barnes -]

Vinothkumar is correct. You just need to update the name directly in sys_user_group table. Other places to check for the group name though: Knowledge articles body's, conditions which use name vs sys_id. 

-Andrew Barnes
Join me at Developer Blog

[Pat Slattery]

Excellent suggestion, I will ensure to verify that it is not referenced anywhere else in the platform. 

[Pat Slattery]

Thank you for the prompt response! 

This makes sense and I will move forward with this method.

In the event that a new group needs to be created for a particular use case, and certain records re assigned to it. Is there a way to stop the re assignment notification from firing for those re assigned records?