16 Jan 2017 at 10:55 #1 A[L]C A[L]C Soldato Joined 18 Oct 2002 Posts 7,515 Location Maidenhead Hi all, Looking for any guidance on updating our active directory user attributes with data from a sql db. Can anyone point me in the right direction?
Hi all, Looking for any guidance on updating our active directory user attributes with data from a sql db. Can anyone point me in the right direction?
16 Jan 2017 at 12:02 #2 LizardKing LizardKing Soldato Joined 18 Oct 2002 Posts 8,300 Location The Land of Roundabouts Powershell should be able to do this quite easily. this guide is quite good http://irisclasson.com/2013/10/16/h...and-output-to-a-file-stupid-question-251-255/ But rather than pipe to a file pipe it to the AD commands.
Powershell should be able to do this quite easily. this guide is quite good http://irisclasson.com/2013/10/16/h...and-output-to-a-file-stupid-question-251-255/ But rather than pipe to a file pipe it to the AD commands.
18 Jan 2017 at 19:26 #3 Django x2 Django x2 Soldato Joined 28 Sep 2008 Posts 14,207 Location Britain Dump the SQL DB out to CSV, make sure the attributes match, AD PowerShell the data with matching attributes to AD.
Dump the SQL DB out to CSV, make sure the attributes match, AD PowerShell the data with matching attributes to AD.