How to check password policy status of all SQL logins.

Run the below command and you will get the status of password policy of all SQL Logins inside a SQL server.

select * from sys.sql_logins