Resolved! Lansweeper report to match computer name
Here is my SQLSelect Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen, tblAssets.Lasttried, tblOperatingsystem.Captio...