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

View solution in original post

3 REPLIES 3
Susan_A
Lansweeper Alumni
How are you tracking (or where have you added) this license information exactly?
hasayeret
Engaged Sweeper II
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
Lansweeper Alumni
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