How To List All Logins In SQL Server

else 'Enabled' end as status

====================
--Type of principal
S = SQL Server user
U = Windows user
G = Windows group
A = Application role
R = Database role
C = Certificate mapped
K = Asymmetric key mapped