1599

Case Scenario:

A customer wants to ignore the folder structure in an existing, already sync'd SES environment, so that all users will end up residing in the ROOT Folder... how to accomplish that?

This article discusses the considerations and processes necessary to move existing ADSync'd users into the Root folder from whatever other folder(s) those User records might be in.  The original scenario was that ADSync had originally been configured to replicate the AD OU structure as Folders and Sub-Folders, and users had been imported into folders representing their original OU locations, but now there's a desire to amalgamate all User information into the base/root folder.

Product version affected:
 
All SD versions
 
Environment:

SQL 2008/2012 Express and Full version
 
Steps to follow:
 
The following query will perform a bulk move of all folders: 

UPDATE tblDBKs SET DBK_Folder = 0 WHERE Is_AD = 1
 
The following two queries used to move keys and computers into the Root folder:
 
a.UPDATE tblKeys SET Key_Folder = 0 WHERE tblKeys.Key_Index IN (SELECT Key_Index FROMtblKeys JOIN tblFolders ON tblKeys.Key_Folder = tblFolders.Folder_Index WHERE tblFolders.Is_AD = 1)
 
b. UPDATE Computers SET Folder = 0 WHERE Computers.PC_Index IN (SELECT PC_Index FROM computers JOIN tblFolders ON computers.Folder = tblFolders.Folder_Index WHERE tblFolders.Is_AD = 1)
 
Internal Reference:
https://confluence.winmagic.local:8443/pages/viewpage.action?pageId=22478985