{"id":1936,"date":"2013-10-04T13:14:30","date_gmt":"2013-10-04T12:14:30","guid":{"rendered":"http:\/\/www.edwardsd.co.uk\/work\/?p=1936"},"modified":"2013-10-04T14:52:21","modified_gmt":"2013-10-04T13:52:21","slug":"ad-ldap-attributes-common-entries","status":"publish","type":"post","link":"https:\/\/www.edwardsd.co.uk\/work\/2013\/10\/ad-ldap-attributes-common-entries\/","title":{"rendered":"AD LDAP Attributes | Common Entries"},"content":{"rendered":"

List of common LDAP AD fields which can be used with the “DSQuery” or other tools which lookup AD objects.<\/p>\n

csvde -m -f c:\\DSQueryUsers.csv -d \"OU=Users,OU=UK,DC=domain,DC=localm\" -r \"(&(objectClass=*)(mail=*))\" -l displayName,userPrincipalName<\/pre>\n
In order to simplify the process of creating LDAP queries you can use the SysInternals \u201cActive Directory Explorer<\/a>\u201d tool to help with this process.<\/p>\n
See Below for table:<\/strong><\/p>\n
<\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
 
Label in AD Users and Computers<\/span><\/span><\/strong><\/td>\nLDAP provider property name<\/span><\/span><\/strong><\/td>\nWinNT provider property name<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Name<\/span><\/span><\/td>\ncn<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
First name<\/span><\/span><\/td>\ngivenName<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Initials<\/span><\/span><\/td>\ninitials<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Last name<\/span><\/span><\/td>\nsn<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Display name<\/span><\/span><\/td>\ndisplayName<\/span><\/span><\/td>\nfullName<\/span><\/span><\/td>\n<\/tr>\n
Description<\/span><\/span><\/td>\ndescription<\/span><\/span><\/td>\ndescription<\/span><\/span><\/td>\n<\/tr>\n
Office<\/span><\/span><\/td>\nphysicalDeliveryOfficeName<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Telephone number<\/span><\/span><\/td>\ntelephoneNumber<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Telephone numbers<\/span><\/span><\/td>\notherTelephone<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
E-mail<\/span><\/span><\/td>\nmail<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Web page<\/span><\/span><\/td>\nwWWHomePage<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Web pages<\/span><\/span><\/td>\nurl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Address<\/span><\/span><\/td>\n<\/tr>\n
Street<\/span><\/span><\/td>\nstreetAddress<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
P.O. Box<\/span><\/span><\/td>\npostOfficeBox<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
City<\/span><\/span><\/td>\nl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
State\/province<\/span><\/span><\/td>\nst<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Zip\/Postal Code<\/span><\/span><\/td>\npostalCode<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Country\/region<\/span><\/span><\/td>\nc, co, countryCode<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Account<\/span><\/span><\/td>\n<\/tr>\n
User logon name<\/span><\/span><\/td>\nuserPrincipalName<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
pre-Windows 2000 logon name<\/span><\/span><\/td>\nsAMAccountName<\/span><\/span><\/td>\nname<\/span><\/span><\/td>\n<\/tr>\n
Account disabled?<\/span><\/span><\/td>\nuserAccountControl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Logon Hours<\/span><\/span><\/td>\nlogonHours<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Logon On To (Logon Workstations)<\/span><\/span><\/td>\nuserWorkstations<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
User must change password at next logon<\/span><\/span><\/td>\npwdLastSet<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
User cannot change password<\/span><\/span><\/td>\nuserAccountControl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Password never expires<\/span><\/span><\/td>\nuserAccountControl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Store password using reversible encryption<\/span><\/span><\/td>\nuserAccountControl<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Account expires end of (date)<\/span><\/span><\/td>\naccountExpires<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Profile<\/span><\/span><\/td>\n<\/tr>\n
User Profile path<\/span><\/span><\/td>\nprofilePath<\/span><\/span><\/td>\nprofile<\/span><\/span><\/td>\n<\/tr>\n
Logon script<\/span><\/span><\/td>\nscriptPath<\/span><\/span><\/td>\nloginScript<\/span><\/span><\/td>\n<\/tr>\n
Home folder, local path<\/span><\/span><\/td>\nhomeDirectory<\/span><\/span><\/td>\nhomeDirectory<\/span><\/span><\/td>\n<\/tr>\n
Home folder, Connect, Drive<\/span><\/span><\/td>\nhomeDrive<\/span><\/span><\/td>\nhomeDirDrive<\/span><\/span><\/td>\n<\/tr>\n
Home folder, Connect, To:<\/span><\/span><\/td>\nhomeDirectory<\/span><\/span><\/td>\nhomeDirectory<\/span><\/span><\/td>\n<\/tr>\n
Telephones<\/span><\/span><\/td>\n<\/tr>\n
Home<\/span><\/span><\/td>\nhomePhone<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Home phone numbers<\/span><\/span><\/td>\notherHomePhone<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Pager<\/span><\/span><\/td>\npager<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Pager numbers<\/span><\/span><\/td>\notherPager<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Mobile<\/span><\/span><\/td>\nmobile<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Mobile numbers<\/span><\/span><\/td>\notherMobile<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Fax<\/span><\/span><\/td>\nfacsimileTelephoneNumber<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other Fax numbers<\/span><\/span><\/td>\notherFacsimileTelephoneNumber<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
IP phone<\/span><\/span><\/td>\nipPhone<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Other IP phone numbers<\/span><\/span><\/td>\notherIpPhone<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Notes<\/span><\/span><\/td>\ninfo<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Organisation<\/span><\/span><\/td>\n<\/tr>\n
Title<\/span><\/span><\/td>\ntitle<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Department<\/span><\/span><\/td>\ndepartment<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Company<\/span><\/span><\/td>\ncompany<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
Manager<\/span><\/span><\/td>\nmanager<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
\u00a0<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
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 \u201cActive Directory Explorer\u201d tool to help with this process. See […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[21,18,23,44],"tags":[],"class_list":["post-1936","post","type-post","status-publish","format-standard","hentry","category-code","category-windows-server-2003","category-windows-server-2008","category-windows-server-2012"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pOPt8-ve","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/posts\/1936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/comments?post=1936"}],"version-history":[{"count":0,"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/posts\/1936\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/media?parent=1936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/categories?post=1936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edwardsd.co.uk\/work\/wp-json\/wp\/v2\/tags?post=1936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}