Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Active Directory

Status
Not open for further replies.

stephenk1973

Technical User
Jun 11, 2003
246
GB
How can i return all fields from active directory? Currently i have.....

SELECT * FROM OPENQUERY( ADSI,
'SELECT department,
homephone,
mobile,
physicalDeliveryOfficeName,
mail,
telephonenumber,
lastLogon,
distinguishedName,
givenname,
sn,
msDS-User-Account-Control-Computed,
userAccountControl,
name
FROM ''LDAP://Domain.com''

Alternatively has anyone got a clear list of query fields against field name (eg sn= surname, mail= email, description= ????)

Thanks

Stephen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top