|
server
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to find all user and export to Excel
Hi all.
I would like to find all user with employeeid from Active Directory User and Computer. Thanks in advance. Luis Gabriel Mieles. Luis Gabriel Mieles wrote:
> I have an example VBScript program that documents all users in the domain in > I would like to find all user with employeeid from Active Directory User > and > Computer. > > Thanks in advance. > 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)(employeeID=*))" 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 |
|||||||||||||||||||||||