Warranty Status

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.

 

Click to Open - 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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting