Join us for the exclusive 2024 Summer Product Launch, secure your spot today!   – Save your seat 🍿

TRY NOW

Workstations out of Warranty in 30 Days Audit

Hardware Warranty

Find Workstations out of Warranty Within 30 Days

Since having a functioning workstation is critical for employees in most businesses, it is essential to ensure that a warranty is in place to fix or replace workstations when they need repairs or replacements. Lansweeper automatically retrieves warranty information for Dell, Fujitsu, HP, IBM, Lenovo, and Toshiba. This audit lists all workstations if their warranty runs out within 14 days. This report can also be used with alerts to alert you when a workstation’s warranty runs out within 30 days. This way you have ample time to extend the warranty before it runs out and you don’t need to run the audit periodically yourself.

Workstations out of Warranty in 30 Days Query

Select Top 1000000 tblAssetCustom.AssetID,
  tblAssets.AssetUnique,
  tsysOS.OSname,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  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 < 2
  And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc

Show

Hide

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.