Get password expire date

[Nordlund]

Is there a way to get the password expire date for a specific user by using SQL?

I'm using SQL2005



[tt]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do not underestimate the power of [!]Google[/!][/tt]

 

[ptheriault]

What type of accounts are they SQL or NT?

If they are NT you may be able to use this method.

The pwdLastSet property is a large integer holding the number of 100ns
intervals since 1601 or something - also known as a FILETIME value.

The DateTime class has a "FromFileTime()" method that will convert that into
a date. Watch out for UTC / local time differences.

In order to see when the password will expire you also need to read the
default domain policy to find out how often a user must change a password.

If you use the WinNT ADSI provider instead of the LDAP ADSI provider you
could get the "PasswordExpirationDate" property which will calculate the
date for you (never tested this though)

There is also a function in SQL Server called loginproperty()

select loginproperty('your user', 'PasswordLastSetTime')

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Nordlund]

Hi and thanks.
The SELECT LOGINPROPERTY works fine, but i have to retrieve the password expiration date

In order to see when the password will expire you also need to read the
default domain policy to find out how often a user must change a password.

But how do I accomplish that by using SQL?

[tt]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do not underestimate the power of [!]Google[/!][/tt]

 

[JulesDBQ]

Did you ever figure out how to acomplish this with SQL Server 2007? I am trying to do the same thing....determine the password expiration dates for my SQL based passwords. Any assistance would be much appreciate! Thanks!