Asset Warranty Status

Get an Overview of the Warranty Status of All Your Assets

This overview provides an easy way to find all the details about the warranty status of devices within your network. It shows details such as the device's name and model, but also warranty specific information like purchase country, shipped date, warranty start and end date and the type of warranty service you have. With the report filters, you can easily get insights into which machines' warranty is expired, or take a look at all the printers or a specific manufacturer. Warranty is retrieved automatically for Dell, Fujitsu, HP, IBM, Lenovo without the need of installing agents or running CMD/PowerShell scripts.

Asset Warranty Status

Asset 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