The following query will generate a list of all users and the groups they are part of in ApplicationXtender:
select a.usrnam, c.aliasname from ae_login a, ae_amap b, ae_als c
where
a.usrid=b.usrid and
c.aliasid=b.aliasid
order by c.aliasname, a.usrnam