Notification

Icon
Error

Warranty scanning errors

Posted: Saturday, April 9, 2016 11:41:27 PM(UTC)
Susan.A

Susan.A

Member Administration Original PosterPosts: 1,536
1
Like
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.

Code:
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

Active Discussions

Lansweeper ManageEngine ADSelfService Plus Vulnerability
by  TheGift73   Go to last post Go to first unread
Last post: 11/30/2021 10:25:01 AM(UTC)
Lansweeper OS: Not latest Build of Windows 10 not working
by  Luke Maslany  
Go to last post Go to first unread
Last post: 11/29/2021 2:01:49 PM(UTC)
Lansweeper Cannot find right class
by  FabioB   Go to last post Go to first unread
Last post: 11/29/2021 8:16:33 AM(UTC)
Lansweeper vCenter vSphere Web Client Vulnerabilities
by  Esben.D  
Go to last post Go to first unread
Last post: 11/25/2021 12:24:24 PM(UTC)
Lansweeper Report for Hardware Maintenance
by  PBjelly   Go to last post Go to first unread
Last post: 11/23/2021 2:53:33 PM(UTC)
Lansweeper Need a little help here
by  AMcCarron  
Go to last post Go to first unread
Last post: 11/18/2021 3:07:25 PM(UTC)
Lansweeper Solftware Installed by member of AD Group
by  RPZ   Go to last post Go to first unread
Last post: 11/17/2021 9:57:42 PM(UTC)
Lansweeper Uptime Report duplicate powerstates
by  INNO-IT  
Go to last post Go to first unread
Last post: 11/16/2021 5:10:23 PM(UTC)