queries to compare snapshot to system groups/channels