Find the Warranty Status of Devices in Your Network
List all assets in your environment and their current warranty status. 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. The warranty status report provides an overview of all your assets and their warranty status so you can see which devices are out of warranty, which ones are close to running out of warranty and which ones are all in order. Making sure that devices are covered by warranty is critical to limiting downtime and maintaining an efficient environment when hardware does unexpectedly fail.
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