Warranty variance

[Brendan440]

It would be nice to be able to add a variance into the warranties. For example, we swap out laptops every three years, as they have 3 year warranties and they get beat up. So that works. However our desktops are on a 5 year plan, but same 3 year warranties. So it would be nice to be able to add a 2 year modifier to desktops, that way warranty reports are a little more useful. Plus my dashboard wouldn't show me 300 machines out of warranty 🙂

I know its pie in the sky, but just thought it might be useful.

[Susan_A · Accepted solution]

You can create a custom report to resolve this issue. The sample report below adds 2 years to the warranty expiration date of non-laptops and then lists computers that are out of warranty based on that information.

Alternatively, you can modify the actual warranty values of your machines, manually or through a script. (We don't provide support for writing custom scripts however.)

Select Top 1000000 tblAssetCustom.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.PurchaseDate As [Purchase Date],
  Case When tblAssetCustom.AssetID In (Select tblPortableBattery.AssetID
    From tblPortableBattery) Then tblAssetCustom.Warrantydate
    Else DateAdd(year, 2, tblAssetCustom.Warrantydate)
  End As [Warranty Expiration],
  tsysOS.Image As icon
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where Case When tblAssetCustom.AssetID In (Select tblPortableBattery.AssetID
    From tblPortableBattery) Then tblAssetCustom.Warrantydate
    Else DateAdd(year, 2, tblAssetCustom.Warrantydate)
  End < GetDate() And tblAssetCustom.State = 1
Order By [Warranty Expiration]