Could you show output
Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblassets.IPAddress,
  tblassets.Userdomain,
  tblassets.Username,
  tblassets.oscode,
  tblassets.memory,
  tblassets.Processor,
  TsysWaittime.CFGname,
  TsysLastscan.Scantime,
  TsysLastscan.Lasttime,
  TsysWaittime.Waitdays
From tblassets
  Inner Join TsysLastscan On tblassets.AssetID = TsysLastscan.AssetID And
      TsysLastscan.Scantime > 5 And TsysLastscan.Lasttime > GetDate() - 7
  Inner Join TsysWaittime On TsysLastscan.CFGcode = TsysWaittime.CFGCode
Order By TsysLastscan.Scantime Desc