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: 230
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