→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Brendan440
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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]

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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]