Today I ran into a issue where I had to change the SCSM admin group defined at installation time. Since there was accidentally used a Active Directory global security group instead of a domain local security group when installing SCSM, I got curious if it is possible to change the group in SCSM configuration. Well, it is not that easy but there is a pretty handy way of changing the group by altering the SCSM database. Credits for this solution go to Dieter Gasser who published his findings on his blog.
If you ever run into the situation that you have to change your SCSM admin group, you can do this by altering __MOMManagementGroupInfo__ table which is found in both DWStagingAndConfig as well as ServiceManager databases.
If you open your SQL Management Studio you should find your __MOMManagementGroupInfo__ table easily. Once you are there, right click on the table and choose to edit top 200 rows. No worries, there is only one row in this table so you should not have a problem to find the appropriate row 😉
Now you have to change the value of the MOMAdminGroup field to contain your new Active Directory group. Make sure you include the domain name (e.g. SCSMLABscsmadmins)
For those of you who prefer to update the database by using a SQL query, I posted one below. You just have to change the database to use (either ServiceManager or DWStagingAndConfig), the name of your old Active Directory group you want to replace and of course the name of your new Active Directory group.
SET [MOMAdminGroup] = '<YOUR OLD GROUPNAME>'
WHERE [MOMAdminGroup] = '<YOUR NEW GROUPNAME>'