Re: Retrieve Users in AD from SQL server Procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Paul Bergson [MVP-DS]" <pbergson@xxxxxxxxxxxxxxxxx>
Date: Tue, 25 Mar 2008 07:44:21 -0500

No. SQL statements cannot be applied against an LDAP database. Something
such as vbscript can be used to query AD. There are other languages as well
that can pull info from AD user objects.

http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true

--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2008, 2003, 2000 (Early Achiever), NT4

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sen" <Sen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54D4F4F2-52EC-461E-BD5D-9FBD7581E4DB@xxxxxxxxxxxxxxxx

Is it possible to reteive a group of users(not all ) from AD using an SQL
query? The users will be placed under folder structures like F1, F2 and i
need to extract only those users in F1 and F2.

Thnx

Prev by Date: Re: Event ID 8003 on domain controller
Next by Date: Re: AD defaults to wrong child domain
Previous by thread: Re: Event ID 8003 on domain controller
Next by thread: Re: NTDS KCC 1308
Index(es):
- Date
- Thread

Relevant Pages

Re: LDAP query information
... execution of the vbscript? ... Microsoft MVP Scripting and ADSI ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... ' Construct LDAP syntax query. ...
(microsoft.public.windows.server.scripting)
Re: Another Access Scripting Question
... A wrinkle I often use when writing anything but the simplest VBScript is ... Dim App 'As Access.Application ... The problem SQL I am having is with an update query which is removing spaces ... The database I built with all the queries works, ...
(microsoft.public.access.modulesdaovba)
Re: Another Access Scripting Question
... A wrinkle I often use when writing anything but the simplest VBScript is ... Dim App 'As Access.Application ... The problem SQL I am having is with an update query which is removing spaces ... The database I built with all the queries works, ...
(microsoft.public.access.modulesdaovba)
Re: Another Access Scripting Question
... A wrinkle I often use when writing anything but the simplest VBScript is ... Dim App 'As Access.Application ... The problem SQL I am having is with an update query which is removing spaces ... The database I built with all the queries works, ...
(microsoft.public.access.modulesdaovba)
Re: Another Access Scripting Question
... A wrinkle I often use when writing anything but the simplest VBScript is ... Dim App 'As Access.Application ... The problem SQL I am having is with an update query which is removing spaces ... The database I built with all the queries works, ...
(microsoft.public.access.modulesdaovba)