This was what I was looking for minus the permissions...

Select @@servername as SQLInstance, name as Login, LOGINPROPERTY(name, 'PasswordLastSetTime') as PasswordLastSetTime, type, type_desc, is_disabled, create_date, modify_date
from...

Thanks Sue 

That is very useful. I was aware the the windows authenticated password expiry would come from some sort of group policy but wasn't aware that the sqlserver...

To only specify enabled accounts:

SELECT name, create_date, is_disabled, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') < DATEADD(dd, -60, GETDATE())
and is_disabled=0;

For the last password change I found this which seems to work Sue:

-- Show all logins where...

Thanks Ten but this not what I need....going forward it's an idea but this is retrospective data I require.

I need a list of sql logins of all dbas within an...

Thanks Sue for the script links. For auditing purposes I am interested in the sql authenticated accounts not just the Windows AD ones.