Get scope names that have at least one collection. Note: the default scope is exceptional as it will always be listed even though there are no collections under it.