FIM SQL Group Membership

Do you love SQL and not in favour to invoke powershell Script to get the list of  membership of the group in AD ? and want to find the membership of the group in SQL.

And there are SQL query to find the group mebership of FIM Group.


Just run the below SQL query, the name of the group is grouptest.

select displayName,employeeID from mms_metaverse where object_id in ( select reference_id from mms_mv_link where attribute_name ='member' and object_id in (select object_id from mms_metaverse where displayname in ('grouptest')))

Thanks