Out of Warranty in 60 Days Audit

Find All Devices in Your Network Which Will Soon Be out of Warranty

List all assets in your environment which will be out of warranty in 60 days. 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 and proactively taking actions is critical to ensure that when hardware does fail, the warranty is there to resolve the issue in a quicker and more cost-effective way.

 

Click to Open - Out of Warranty in 60 Days Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.PurchaseDate As [Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty Expiration],
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.Warrantydate < GetDate() + 60 And tblAssetCustom.Warrantydate > GetDate() And tblAssetCustom.State = 1
  And tblAssets.Assettype <> 66
Order By [Warranty Expiration] Desc

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting