TSQL to find a login's properties such as password expiration?

declare @name nchar(100)

SET @name ='<LoginName'

SELECT LOGINPROPERTY( @name, 'PasswordLastSetTime' ) AS PasswordLastSetTime, LOGINPROPERTY( @name, 'IsExpired' ) AS IsExpiried, LOGINPROPERTY( @name, 'IsLocked' ) AS IsLocked, LOGINPROPERTY( @name, 'IsMustChange' ) AS IsMustChange, LOGINPROPERTY( @name, 'LockoutTime' ) AS LockoutTime, LOGINPROPERTY( @name, 'BadPasswordCount' ) AS BadPasswordCount, LOGINPROPERTY( @name, 'BadPasswordTime' ) AS BadPasswordTime, LOGINPROPERTY( @name, 'HistoryLength' ) AS HistoryLength, LOGINPROPERTY( @name, 'PasswordHash' ) AS PasswordHash, LOGINPROPERTY( @name, 'PasswordLastSetTime' ) AS PasswordLastSet

GO