sql Script for finding sql login passwordexpiration days?

Question

question

suesh asked Oct 19, '14

sql Script for finding sql login passwordexpiration days?

Can any one please provide me the script for finding sql login password expiration days and also that will send the alert before one week of expiration? Please provide me the full script because i am not aware of scripting side.

script

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2014-10-20T09:11:43Z

Kev Riley answered Oct 20, '14

You would want to use the DaysUntilExpiration property returned from `LOGINPROPERTY` to get the number of days until the password expires. select *, LOGINPROPERTY(name, N'DaysUntilExpiration') AS DaysUntilExpiration from sys.server_principals ssp where type_desc = 'SQL_LOGIN' From that you can determine the expiration date, and trigger your alerting accordingly. See: http://msdn.microsoft.com/en-us/library/ms345412.aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

suesh commented · Nov 18, 2014 at 06:02 AM

Hi Kev Riley, Thanks for your help.. Also provide me the script the will send alert before one week of password expiration?

0 ·

Answer 2 · 2014-10-30T09:16:09Z

suesh answered Oct 30, '14

Can any one please send me the full script?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question