adsi openquery has group membership
DECLARE @group NVARCHAR(128) = '<<YourGroupName>>'
DECLARE @DC1 NVARCHAR(128) = '<<YourDomainName>>'
DECLARE @DC2 NVARCHAR(128) = 'com'
DECLARE @SQL NVARCHAR(MAX)
DECLARE @group_dn NVARCHAR(512)
DECLARE @result TABLE(name NVARCHAR(512))
SET @SQL =
'SELECT distinguishedName
FROM OPENQUERY
(ADSI,''SELECT cn, distinguishedName, dc
FROM ''''LDAP://DC=' + @DC1 + ',DC=' + @DC2 + '''''
WHERE objectCategory = ''''group'''' AND cn = ''''' + @group + ''''''')'
--PRINT @SQL
INSERT @result(name)
EXEC sp_executesql @SQL
SELECT @group_dn = name FROM @result
SET @SQL =
'SELECT *
FROM OPENQUERY (ADSI, ''<LDAP://' + @DC1 + '.' + @DC2 + '>;
(&(objectCategory=person)(memberOf:1.2.840.113556.1.4.1941:=' + @group_dn + '));
cn, sAMAccountName, adspath, distinguishedName;subtree'')
ORDER BY cn;'
--PRINT @SQL
EXEC sp_executesql @SQL