Like the previous post (https://www.electricwaffle.co.uk/2013/02/using-t-sql-to-find-whos-in-what-database-role/) but this time with server roles 😉

SELECT p. NAME,m. NAME
FROM sys .server_role_members rm
JOIN sys .server_principals p
ON rm. role_principal_id = p .principal_id
JOIN sys .database_principals m
ON rm. member_principal_id = m .principal_id

 

This will return the principle against the server role they have.