Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Model,
  tblAssets.Domain,
  tblAssets.Description,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Lastseen > GetDate() - 120 And (tblAssetCustom.Model Like
    '%PowerEdge%' Or tblAssetCustom.Model Like '%ProLiant%' Or
    tblAssetCustom.Model Like '%StoreEasy%') And tblAssetCustom.State = 1
Order By tsysAssetTypes.AssetTypename