Below query can be used to get SQL Server logins with server role in SQL Server.

SELECT @@servername as Server, sp.name Login_Name
,Account_Type = CASE sp.type_desc
WHEN 'Windows_Group'
THEN 'Windows Group'
WHEN 'WINDOWS_LOGIN'
THEN 'Windows Login'
ELSE 'SQL Login'
END