SQL Recipe for Previous Members’ Sub-Groups
This is one of those recipes you think you may never need or you have needed it and you wish it had been available. The purpose of this report is to find out which sub-groups the previous members of an organization had been in when they were members.
Why would you need this? Well, if you accidentally dropped all the members of an org and needed to recreate the org as it had been prior to doing that, this report would be just the thing if that organization had sub-groups.
This is a little different than most SQL reports. Your system Admin can add this to your database as usual, but to run it you must specify an organization ID# in the URL. We explain all the steps in the help article. To make this available for other users, you might decide to add it to your Main Menu, so it is there whenever someone needs it. Then that user can just run it from Reports, and then add the org ID# at the end of the URL, and hit enter. Voila!
The report returns only Previous Members. So, if you drop everyone by mistake, run this report before you add them back as Members. You will probably want the Excel version. That way you will have all of their sub-groups in a report and can add the individuals to the appropriate groups as you add them back as Members.