START FREE

Warranty Status

Hardware Network Devices Warranty

Find the Warranty Status of Devices in Your Network

List all assets in your environment and their current warranty status. Lansweeper uses a combination of data scanned from devices to pull in warranty information from supported vendors (Dell, Fujitsu, HP, IBM, Lenovo or Toshiba). Being able to manage all devices and their warranty can be a real challenge. The warranty status report provides an overview of all your assets and their warranty status so you can see which devices are out of warranty, which ones are close to running out of warranty and which ones are all in order. Making sure that devices are covered by warranty is critical to limiting downtime and maintaining an efficient environment when hardware does unexpectedly fail.

 

Warranty Status Query

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblWarranty.PurchaseCountry,
  tblWarranty.ShipDate,
  tblWarrantyDetails.WarrantyStartDate,
  tblWarrantyDetails.WarrantyEndDate,
  tblWarrantyDetails.ServiceType,
  Case
    When GetDate() > tblWarrantyDetails.WarrantyEndDate Then 'yes'
    Else 'no'
  End As Expired,
  tblWarranty.Error,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblWarranty
  Inner Join tblWarrantyDetails On tblWarranty.WarrantyId =
    tblWarrantyDetails.WarrantyId
  Inner Join tblAssets On tblWarranty.AssetId = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where Not (tblWarranty.LastWarrantySuccess Is Null)
Order By tblAssets.AssetName,
  tblWarrantyDetails.WarrantyEndDate Desc

Show

Hide

Other reports in this category

See all (751)
NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.

TRY NOW TALK TO SALES