We created this script to make it easy for a church leader to find which classes have (and do not have) specific Member Types within their set of Organizations. For example: at our church, we want each adult class to have someone designated as a Missions Leader. This SQL report displays which classes have these leaders, who they are (even if there are more than one) and then see which Orgs do not have a Missions Leader.

Notice in the sample below that those classes without a Mission Leader have nothing in the Name and Member Type columns. Also, note that some classes have more than one Missions Leader. The SQL report is designed to be added to the Toolbar on the Organization > Search page. Remember, you can also download these as Excel after running them.

Read more...and grab the recipe and paste it into your database.