Renaming an AD Group Used for Orion Authentication

If it's just the SolarWinds Web UI that group has access to, then it's pretty straight forward. I don't think there's any official documentation out there on this but I have run through this before in different scenarios without issue.

Had to make changes to both AD groups / individual accounts and SAML groups / individual accounts. The data lives in the same place in the SQL database table [SolarWindsOrion].[dbo].[Accounts] - assuming the default SolarWindsOrion is your database name.

Here's some queries to get you started. When I changed these, there's no impact to services and it was seamless. As soon as the database was updated we could login with the new group info or accounts. Just be sure to backup your database prior to any changes -- test in dev if you can.

-- Query accounts (I think groups are accounttype 3
SELECT a.AccountID, a.AccountEnabled, a.AccountSID, a.AccountType
FROM SolarWindsOrion.dbo.Accounts AS a
WHERE a.AccountType = 3

-- Update the Account ID
UPDATE a
SET a.AccountID = 'domain\newaccountID'
FROM SolarWindsOrion.dbo.Accounts AS a
WHERE a.AccountSID = 'currentSID'

-- Update the Account SID
UPDATE a
SET a.AccountSID = 'newSID'
FROM SolarWindsOrion.dbo.Accounts AS a
WHERE a.AccountID = 'domain\currentaccountID'

-- Update BOTH the Account ID and SID
UPDATE a
SET a.AccountSID = 'newSID',
a.AccountID = 'domain\newaccountID'
FROM SolarWindsOrion.dbo.Accounts AS a
WHERE ( a.AccountID = 'domain\currentaccountID' AND a.AccountSID = 'currentSID' )

While I mention this above... pretty sure official documentation (even if non-existent) would likely be to remove the existing groups or account and re-add them once they're changed so they take in the new SID and name. Thought worth mentioning.