Hello,
I’m not exactly sure what you want to do.
If you need a list of Windows Users in a Windows Group from within SQL Server, you could try using xp_logininfo
e.g. EXEC master..xp_logininfo 'Your Domain\Your Domain Group', members
To get the permissions for a particular Login e.g. one mapped to a Windows Group, via a query, then you probably want to use the Security Catalog Views. (Please see the relevant section in BOL).
May be you want a combination of this data?
Regards,
John Marsh