Servers out of Warranty in 30 Days Audit

Find Servers out of Warranty Within 30 Days

Since servers are most likely critical to any business, it is essential to ensure that a warranty is in place to fix or replace the servers when they need repairs or replacements. Lansweeper automatically retrieves warranty information for Dell, Fujitsu, HP, IBM, Lenovo, and Toshiba. This audit lists all servers if their warranty runs out within 14 days.

This audit can also be used with alerts to alert you when a server's warranty runs out within 30 days. This way, you can extend the contract before it runs out.

Servers out of Warranty in 30 Days Query

Select Top 1000000 tblAssetCustom.AssetID,
  tblAssetCustom.Serialnumber As [Identifying Number],
  tblAssetCustom.PurchaseDate As [Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty Expiration],
  tsysOS.Image As icon
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.Warrantydate < GetDate() + 30 And
  tblAssetCustom.Warrantydate > GetDate() And tblComputersystem.Domainrole > 1
  And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc

Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting