6 Replies Latest reply on Mar 28, 2014 4:33 AM by thadams

    How do I get a list of all spaces and subspaces AND their administrators, and groups and group owners?


      I need to reach out to all space admins and group owners.

      I haven't found a way to get a report of all spaces and their sub-spaces, with the space admin name.  And a report of all groups and group owners (although I did come up with a sql for that).






      PS - the SQL for group owners.


      SELECT jiveuser.email, jivesgroup.groupid, jivesgroup.name, jivesgroup.displayname, jivesgroup.grouptype FROM jivesgroup , jiveuser , jivesgroupmember WHERE jivesgroup.userid = jiveuser.userid AND jivesgroup.groupid = jivesgroupmember.groupid AND jivesgroupmember.memberType=0 GROUP BY jivesgroup.groupid, jivesgroup.name, jivesgroup.grouptype, jivesgroup.userid, jiveuser.userid, jiveuser.username;