Resolved! Duplicate Assets
I have about 900 Assets on site and am trying to create or modify the Warranty report to show the users full name not the login ID soon as i add tblADusers and check Displayname my Asset count jumps from 900 to 624078 Select Top (1000000) tsysAssetTy...