Afficher un message
Vieux 11/10/2007, 18h13   #2
Richard Mueller [MVP]
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: How to find all user and export to Excel

Luis Gabriel Mieles wrote:

>
> I would like to find all user with employeeid from Active Directory User
> and
> Computer.
>
> Thanks in advance.
>


I have an example VBScript program that documents all users in the domain in
an Excel spreadsheet linked here:

http://www.rlmueller.net/Create%20User%20List%203.htm

The program can be modified to only document users that have a value
assigned to the employeeID attribute. Modify this statement:

strFilter = "(&(objectCategory=person)(objectClass=user))"

so that it becomes:

strFilter = "(&(objectCategory=person)(objectClass=user)(emplo yeeID=*))"

This changes the LDAP syntax filter so the ADO query retrieves information
for all user objects where there is any value assigned to the employeeID
attribute. For more on using ADO, see this link:

http://www.rlmueller.net/ADOSearchTips.htm

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--


  Réponse avec citation
 
Page generated in 0,05700 seconds with 9 queries