DNN-4075 Users doesn't all indexed in dnnsoftware.com
changed inner joins to left joins to ensure all valid users are indexed