Analyze groups to users association
Analyze groups to users association
October 30, 2013
The following SQL query lists all the security groups and the associated users.
SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsiteFROM maxgroupJOIN groupuser ON groupuser.groupname=maxgroup.groupnameJOIN maxuser ON maxuser.userid=groupuser.useridORDER BY maxgroup.groupname, maxuser.userid;The best approach to analyze the results is to load them into Excel and create a pivot table.