→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
The report below lists Dell, Fujitsu, HP, IBM, Lenovo and Toshiba assets whose last warranty scan was unsuccessful, as well as possible warranty scanning errors that occurred. The report below will only list assets that meet all of the following criteria:
  • The asset's manufacturer is Dell, Fujitsu, HP, IBM, Lenovo or Toshiba.
  • The most recent attempt to scan the asset's warranty failed.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblWarranty.LastWarrantyTry,
tblWarranty.LastWarrantySuccess,
tblAssets.ServiceVersion As LansweeperVersion,
tblWarranty.Error,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.Manufacturer Like '%dell%' Or
tblAssetCustom.Manufacturer Like '%fujitsu%' Or
tblAssetCustom.Manufacturer Like '%HP%' Or tblAssetCustom.Manufacturer Like
'%hewlett%packard%' Or tblAssetCustom.Manufacturer Like '%IBM%' Or
tblAssetCustom.Manufacturer Like '%lenovo%' Or
tblAssetCustom.Manufacturer Like '%toshiba%') And
(tblWarranty.LastWarrantySuccess Is Null Or tblWarranty.LastWarrantySuccess =
'' Or tblWarranty.LastWarrantySuccess < tblWarranty.LastWarrantyTry)
Order By tblAssets.Domain,
tblAssets.AssetName
0 REPLIES 0