List of windows groups having sysadmin in SQL Server

Below script is used to find the list of windows groups having sysadmin in SQL server

USE master

GO

SELECT  p.name AS [loginname] ,

        p.type ,

        p.type_desc ,

        p.is_disabled,

        CONVERT(VARCHAR(10),p.create_date ,101) AS [created],

        CONVERT(VARCHAR(10),p.modify_date , 101) AS [update]

FROM    sys.server_principals p

        JOIN sys.syslogins s ON p.sid = s.sid

WHERE   p.type_desc IN ( 'WINDOWS_GROUP')

        -- Logins that are not process logins

        AND p.name NOT LIKE '##%'

        -- Logins that are sysadmins

        AND s.sysadmin = 1

GO