Find Servers out of Warranty Within 30 Days
Since servers are most likely critical to any business, it is important to make sure that a warranty is in place to fix or replace the servers when they do 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 will run out within 14 days.
This audit can also be used with alerts so you get alerted when a server's warranty will run out within 14 days. This way you have ample time to extend the warranty before it runs out.
Servers out of Warranty in 30 Days Query
Select Top 1000000 tblAssetCustom.AssetID, tblAssets.AssetUnique, tsysOS.OSname, tblAssetCustom.Model, 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