SQL Server login Password expiration || SQL Server Login Password Enforce Policy || Reset Passwordw

SQL Server login Password expiration || SQL Server Login Password Enforce Policy || Reset Passwordw

Hi Mate,
Welcome to my channel Tech & Art.
*************************************************************
SELECT SL.name AS LoginName
,LOGINPROPERTY (SL.name, 'PasswordLastSetTime') AS PasswordLastSetTime
,LOGINPROPERTY (SL.name, 'DaysUntilExpiration') AS DaysUntilExpiration
,DATEADD(dd, CONVERT(int, LOGINPROPERTY (SL.name, 'DaysUntilExpiration'))
, CONVERT(datetime, LOGINPROPERTY (SL.name, 'PasswordLastSetTime'))) AS PasswordExpiration
,SL.is_policy_checked AS IsPolicyChecked
,LOGINPROPERTY (SL.name, 'IsExpired') AS IsExpired
,LOGINPROPERTY (SL.name, 'IsMustChange') AS IsMustChange
,LOGINPROPERTY (SL.name, 'IsLocked') AS IsLocked
,LOGINPROPERTY (SL.name, 'LockoutTime') AS LockoutTime
,LOGINPROPERTY (SL.name, 'BadPasswordCount') AS BadPasswordCount
,LOGINPROPERTY (SL.name, 'BadPasswordTime') AS BadPasswordTime
,LOGINPROPERTY (SL.name, 'HistoryLength') AS HistoryLength
WHERE is_expiration_checked = 1
ORDER BY LOGINPROPERTY (SL.name, 'PasswordLastSetTime') DESC

********************************************************************************************

SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,

#sqlserver #sqlserverdba #techandart

[tariqsssxec]

Great Work, Thank's, Creator said share your knowledge it will not be lost but it will increase

[alexanderbailey]

Where would you look for the password policy length? Restricting it say to 15 alpha/numeric characters.

[erupulavasantha]

How to get count of not matched company policy password in sql

[ashwinisingh]

My passwordExpiration is showing 2024-07-16 09:03:42.720 .... But it is still not expired... Can you please explain this... Why it is happening like this.

[kumartannuji]

Can I get the password expired date for which user have expired password 30 days before