Analyze groups to users association

The following SQL query lists all the security groups and the associated users.

SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsite
FROM maxgroup
JOIN groupuser ON groupuser.groupname=maxgroup.groupname
JOIN maxuser ON maxuser.userid=groupuser.userid
ORDER BY maxgroup.groupname, maxuser.userid;

The best approach to analyze the results is to load them into Excel and create a pivot table.

Analyze groups to users association

One thought on “Analyze groups to users association

  1. with respect …
    combination ( user – security group ) is useful for operational setup of security
    to analyze license related information you have to consider combination ( user – module )

Leave a Reply

Your email address will not be published.


Scroll to top