1 Reply Latest reply on Feb 14, 2013 9:44 AM by allison.doherty

    Group Membership Report

    kpratico

      I am looking for a way pull a report that shows the total number of members for each group within our community.  Has anyone created a similar report?

       

      Kris

        • Re: Group Membership Report
          allison.doherty

          Here is the SQL that will retrieve the list of members or # of members from a given group

           

          - select username from jiveuser where userid in (select userid from jivesgroupmember where groupid in (select groupid from jivesgroup where name in ('XXXXX')) )

          - select Count(*) from jiveuser where userid in (select userid from jivesgroupmember where groupid in (select groupid from jivesgroup where name in ('XXXXX')) )

           

          You could run this for each of your groups by iterating through the jivesgroup table. Hope that helps