Get password last set date from AD

[sqldba7]

thread183-1273100

I am using sp_QueryAD to query AD. I am able to get the following info with no problem.

SELECT cn, mail, sAMAccountName, userAccountControl, adspath
FROM ''LDAP://server.com''
WHERE objectCategory = ''Person''
AND objectClass = ''user''
order by mail

I need to get the last password set date for each login. I do not know the column name to pass in the SELECT clause to get the last password change date. Can anyone enlighten me with this.

I have tried pwdLastSet, passwordExpires etc on the SELECT clause and it does now work. Any help would be appreciated.

 

[bborissov]

Where is your OPENQUERY?
Both examples include it:

select *
 from [COLOR=red]openquery
(
ADSI,'SELECT cn, mail, sAMAccountName, userAccountControl
FROM ''LDAP://domain.com''
WHERE objectCategory = ''Person''
AND objectClass = ''user''
order by mail
'
) [/color]

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[sqldba7]

I am not using openquery. I am using the sp_queryAD from the linked forum article. This sp_queryAD uses sp_oacreate using ADsDSOObject. thanks.