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.
Senior Technical Specialist
Disney Technology Solutions and Services
CO-DTSS Social Business Technology
500 S. Buena Vista | Burbank, CA 91505
Unfortunately other than the admin console, there is not an out of the box method to retrieve the report you are looking for. You might consider asking in the Jive Developers space where you can work with other developers to see if other have run a query for a similar report.