Talk About Network

Google





Software > ADSI General > sql insert into...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 5289 of 5437
Post > Topic >>

sql insert into memberof in AD

by "Janette" <jtowell@[EMAIL PROTECTED] > May 30, 2008 at 11:57 AM

Hi,

I am not sure if this is an appropriate group for this question, but does 
anyone know how, or can suggest a good reference sight for doing SQL based

LDAP inserts eg I need to be able to add certain AD accounts to be members

of certain AD groups via SQL. I know you can do things like

@[EMAIL PROTECTED]
'<LDAP://AD Domain>;(&(ObjectCategory=group)(memberOf=' + 
ltrim(rtrim(@[EMAIL PROTECTED]
)) + '));distinguishedName;subtree'
SELECT * FROM OpenQuery(ADSI,''' + @[EMAIL PROTECTED]
 + ''')

but I can't find a good reference site to help me. I also realise that 
memberof is a multivalued field so I don't know if this is going to make
it 
more complicated to achieve.

Thanks in advance
Janette
 




 3 Posts in Topic:
sql insert into memberof in AD
"Janette" <j  2008-05-30 11:57:30 
Re: sql insert into memberof in AD
"Joe Kaplan" &l  2008-05-29 21:20:50 
Re: sql insert into memberof in AD
Gerry Hickman <gerry66  2008-05-31 17:56:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Thu Jan 8 13:56:42 PST 2009.