Securiy Group Memeber list

I am trying to print or create a report to print the members list for each security group created. Does anyone know a way to do this?

Hi,

In DAX 2009 and previous editions, the table ‘USERGROUPLIST’ contains this details. This table is available under System Documentation\Tables

Thanks for the reply. This is what i come up with and was able to get a list by username and common name in the SQL manager.

SELECT a.GROUPID, a.USERID, b.NAME

FROM [AXDB].[dbo].[USERGROUPLIST] as a

left join USERINFO as b on a.USERID = b.ID

order by a.GROUPID, a.USERID