stephenk1973
Technical User
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
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