Fixing report SQL to reflect valid/doa/orphan share states