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!
-
Get password last set date from AD
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.- sqldba7
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Get password last set date from AD
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...- sqldba7
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
