Password Check

SELECT p.name
, is_policy_checked
, is_expiration_checked
, LOGINPROPERTY(p.name,'BadPasswordCount') BadPasswordCount
, LOGINPROPERTY(p.name,'BadPasswordTime')  BadPasswordTime
, DATEDIFF(DD, CONVERT(VARCHAR(8),LOGINPROPERTY(p.name,'BadPasswordTime'),112) ,GETDATE()) DaysAgo
, LOGINPROPERTY(p.name,'DaysUntilExpiration') DaysUntilExpiration
, LOGINPROPERTY(p.name,'DefaultDatabase') DefaultDatabase
, convert(varchar(3),datediff(dd,sl.modify_date, getdate())) + ' Days ago' AS PasswordChanged

, LOGINPROPERTY(p.name,'DefaultLanguage') DefaultLanguage
, LOGINPROPERTY(p.name,'HistoryLength') HistoryLength
, LOGINPROPERTY(p.name,'IsExpired') IsExpired
, LOGINPROPERTY(p.name,'IsLocked') IsLocked
, LOGINPROPERTY(p.name,'IsMustChange') IsMustChange
, LOGINPROPERTY(p.name,'LockoutTime') LockoutTime
, LOGINPROPERTY(p.name,'PasswordHash') PasswordHash
, p.is_disabled
, p.type_desc
, LOGINPROPERTY(p.name,'PasswordLastSetTime') PasswordLastSetTime
FROM sys.server_principals p
LEFT JOIN sys.syslogins l ON ( l.name = p.name )
LEFT JOIN sys.sql_logins sl ON ( p.sid = sl.sid )

--WHERE is_policy_checked <> 1