Convert SQL Query results to Active Directory Groups

Posted by antgiant on Server Fault See other posts from Server Fault or by antgiant
Published on 2011-02-18T13:51:09Z Indexed on 2011/02/18 15:27 UTC
Read the original article Hit count: 200

Are there any quality products (ideally open source) that allow me to run an arbitrary SQL query that results in 2 columns (username, group name) and they adds that username in AD to a group of that name in AD? If the username doesn't exist it is ignored. If the group name doesn't exist ideally it gets created.

Updated for Clarity: I have a MSSQL based system that is the authoritative source for some of the Active Directory Security groups, and their members. I want to be able to to have those Active Directory Security Groups populated by a one-way sync originating from MSSQL. Sadly the MSSQL based system does not have a good API, so I will have to do this with direct SQL calls. Is there anything that does this well?

© Server Fault or respective owner

Related posts about sql-server

Related posts about active-directory