We had a request to get a list of all communities in our instance and list what groups are part of those communities. I was able to locate the Community table, the Group table, the Group Membership table but nothing that I can find which links JIVECOMMUNITY with what groups are in each of the Communities. Is there a way to do it?
If I can re-construct the ADMIN page and figure out where the JSPA file is which does the backend query I can use that to generate a report for the user requesting the data. They want to know how many of the specific groups are part of each community without having to go to each community through the interface.