Welcome to the Alteryx Knowledge Base

• Alteryx Server
  • Version 2020.1+
  • Integrated Windows Authentication, optionally with Kerberos

In a Server environment using Integrated Windows Authentication, users have a unique security identifier (SID) associated with their user profile.
 

How to find a user's SID from MongoDB

1. Connect to the AlteryxGallery database using Studio 3T or Mongo Shell in Command Prompt
2. Run the following query which will return the user's SID value: 

   db.users.findOne({"Email": "[User Email Address]"}, {_id: 0, 'WindowsIdentity.Sid': 1})

How to find a user's SID from Windows Active Directory

1. Run one of the following commands depending on Windows version:
   
   In Command Prompt Windows 10, version 21H1 / Windows Server 2022 or lower:
   

   wmic useraccount where name="[Windows User Name]" get sid

   
   
   In PowerShell Windows Server 2008+ / Windows 10+ (requires RSAT to be installed on machine):

   $user = Get-ADUser -Filter { SamAccountName -eq "[Windows User Name]" } -Server "[New Domain]"; echo $user.SID.Value

3. The user's Windows user name can be queried from the MongoDB's AlteryxGallery database as follow: 

   db.users.findOne({"Email": "[User Email Address]"}, {_id: 0, 'WindowsIdentity.Name': 1})

Updating the SID via the Command Prompt

Note: Making direct edits to the database is only for advanced usage. You must have a database backup in place prior to making any changes.

• Update using ObjectID:

  db.users.updateOne({_id : ObjectId("[User Mongo ObjectID]")}, {$set:{"WindowsIdentity.Sid": "[User SID]"}})

• Update using Email address:

  db.users.updateOne({"Email": "[User Email Address]"}, {$set:{"WindowsIdentity.Sid": "[User SID]"}})

• Microsoft - Security Identifiers
• How to Identify and Fix Null/Incorrect values in Users collection - MongoDB