Query to list all SA or sysadmin users in SQL Server

USE master
GO
SELECT p.name AS [loginname] , Role =
case s.sysadmin
when ‘1’ then ‘sysadmin’
end
FROM sys.server_principals p
JOIN sys.syslogins s ON p.sid = s.sid
WHERE p.type_desc IN (‘SQL_LOGIN’, ‘WINDOWS_LOGIN’, ‘WINDOWS_GROUP’)
— AND p.name NOT LIKE ‘##%’
AND s.sysadmin = 1