Selecting All SQL Logins (disabled and Enabled)

Please use below query to find all logins with condition

SELECT name, type_desc, is_disabled
FROM sys.server_principals
where is_disabled=1 --disabled Logins
--is_disabled=1 (Enabled Logins)