Assets Warrenty - specific type of machines

[hasayeret]

Hi guys,

How do I set Lansweeper to inform me on assets warranty expiring JUST for servers\switches\routers?
In other words, I don't care about the laptops, desktops and monitors warranty: I need the heavier gear warranty and not the end user's.

Thanks!
Ro

[Susan_A]

How are you tracking (or where have you added) this license information exactly?

[hasayeret]

Thanks for your help!
One more question regarding expiration (and feel free to open a new thread if needed): Is there any way for Lansweeper to display in the dashboard anything for expiring\expired Symantec licenses?

Thanks!
Ro

[Daniel_B · Accepted solution]

For servers we recommend using the built-in server warranty reports. Open Reports and search for reports like "Server: Out of warranty". In order to list warranty details for other asset types, use a custom report like the following, filtering on tsysAssettypes.Assettypename:

Select Top 1000000 tblAssetCustom.AssetID,
  tblAssets.AssetUnique,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber As [Identifying Number],
  tblAssetCustom.PurchaseDate As [Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty Expiration]
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Warrantydate < GetDate() And tsysAssetTypes.AssetTypename
  In ('switch', 'router') And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc