Get an Overview of the Warranty Status of All Your Assets
This overview provides an easy way to find all the details about the warranty status of devices within your network. It shows details such as the device's name and model, but also warranty specific information like purchase country, shipped date, warranty start and end date and the type of warranty service you have. With the report filters, you can easily get insights into which machines' warranty is expired, or take a look at all the printers or a specific manufacturer. Warranty is retrieved automatically for Dell, Fujitsu, HP, IBM, Lenovo without the need of installing agents or running CMD/PowerShell scripts.
Asset 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