Assuming that join on tables with names like tblDomainUserdbf5c43a-97a9-42e6-9580-2de371bbb01e (et al.) is correct, here's fix for a query from https://www.quest.com/community/products/enterprise-reporter/f/forum/21870/i-am-trying-to-identify-duplicate…