Network Management

AD Group Change

A GPO causes the name of an Active Directory Tree to change, and AD groups added to the Orion Platform are no longer visible.

First published date

5/7/2019 11:36 PM

Last published date

5/7/2019 11:36 PM

Overview

Sometimes when a GPO is triggered, it changes the name of an Active Directory (AD) tree. If this AD group was added to the Orion Platform, then the users in that group are no longer visible.

Product section

Orion Platform

Resolution

Option 1: Change the name of the group in the database

If you have changed the AD Group Name itself, then it should not be an issue to change the name in the database (see the figure below).
  1. Execute the Query.
  2. Enable Table Editing.
  3. Amend the Account ID.

Run the following query to locate your account:

SELECT TOP 1000 * FROM [dbo].[Accounts]

If you already know the name of the account, you can use the following:

SELECT AccountID  FROM [dbo].[Accounts] WHERE AccountID  =  'Account Name here '

 

Update the Account Name

To update the account name through the UI:

  1. Enable Table Editing.
  2. Change the account name.
  3. Refresh the query.

To update the account name using SQL:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

set UPDATE AccountID = 'new name here'

Option 2: Remove and re-add the AD group

You could remove and re-add the AD group, and this will import the updated settings to the Orion Web Console.

Additionally, if there is ever an issue with a user account in the group, you can remove that user from the GUI and then refresh the page, and it will update that user.