Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Department,
  tblAssetCustom.Model,
  tblAssets.Domain,
  tblAssets.Description
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetName Not Like '%W1%' And tblAssets.AssetName Not Like
  '%W0%' And tblAssets.AssetName Not Like '%W2%' And
  tblAssets.AssetName Not Like '%W3%' And tblAssets.AssetName Not Like '%W4%'
  And tblAssets.AssetName Not Like '%W5%' And tblAssets.AssetName Not Like
  '%W6%' And tblAssets.AssetName Not Like '%W7%' And
  tblAssets.AssetName Not Like '%W8%' And tblAssets.AssetName Not Like '%W9%'
  And tblAssets.AssetName Not Like '%MacBook%' And
  tsysAssetTypes.AssetTypename Like '%Linux%' And tblAssets.Lastseen >
  GetDate() - 120 And tblAssetCustom.State = 1
Order By tblAssets.AssetName