AD LDAP Attributes | Common Entries

List of common LDAP AD fields which can be used with the “DSQuery” or other tools which lookup AD objects.

csvde -m -f c:\DSQueryUsers.csv -d "OU=Users,OU=UK,DC=domain,DC=localm" -r "(&(objectClass=*)(mail=*))" -l displayName,userPrincipalName

In order to simplify the process of creating LDAP queries you can use the SysInternals “Active Directory Explorer” tool to help with this process.

See Below for table:

Label in AD Users and Computers LDAP provider property name WinNT provider property name
Name cn  
First name givenName  
Initials initials  
Last name sn  
Display name displayName fullName
Description description description
Office physicalDeliveryOfficeName  
Telephone number telephoneNumber  
Other Telephone numbers otherTelephone  
E-mail mail  
Web page wWWHomePage  
Other Web pages url  
Address
Street streetAddress  
P.O. Box postOfficeBox  
City l  
State/province st  
Zip/Postal Code postalCode  
Country/region c, co, countryCode  
Account
User logon name userPrincipalName  
pre-Windows 2000 logon name sAMAccountName name
Account disabled? userAccountControl  
Logon Hours logonHours  
Logon On To (Logon Workstations) userWorkstations  
User must change password at next logon pwdLastSet  
User cannot change password userAccountControl  
Password never expires userAccountControl  
Store password using reversible encryption userAccountControl  
Account expires end of (date) accountExpires  
Profile
User Profile path profilePath profile
Logon script scriptPath loginScript
Home folder, local path homeDirectory homeDirectory
Home folder, Connect, Drive homeDrive homeDirDrive
Home folder, Connect, To: homeDirectory homeDirectory
Telephones
Home homePhone  
Other Home phone numbers otherHomePhone  
Pager pager  
Other Pager numbers otherPager  
Mobile mobile  
Other Mobile numbers otherMobile  
Fax facsimileTelephoneNumber  
Other Fax numbers otherFacsimileTelephoneNumber  
IP phone ipPhone  
Other IP phone numbers otherIpPhone  
Notes info  
Organisation
Title title  
Department department  
Company company  
Manager manager  
     

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.