cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LF
Engaged Sweeper
Is there a way I could monitor and get notified if a warranty, support contract or maintenance agreement for hardware such servers, switches and similar is soon to expire?

Ideally I would like to be able to manually enter the expiry date (the warranty field or a custom field could be used for that) and trigger the sending of an email, say, 90 days before the contract expires.
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
The easiest way to achieve this is to use a report alert. Lansweeper has a built-in report called "Asset: Out of warranty in 60 days" If you schedule this report to be sent to you daily in a report alert. Since report alerts only send out an email when the report contains a result. Once a asset's warranty runs out in 60 days you will receive an email with the report.

You can find more information about report alerts and how to configure them in this knowledgebase article: https://www.lansweeper.com/kb/113/sending-email-alerts.html

View solution in original post

4 REPLIES 4
LF
Engaged Sweeper
That worked like a charm. Thank you so much.
Esben_D
Lansweeper Employee
Lansweeper Employee
You would have to convert the field using the code below, similar to what you did with your custom field. Simply replace the highlighted code with the field which you want in the European date format.

Convert(nvarchar,tblAssetCustom.PurchaseDate,103) As Date

I left the custom field conversion as is, but you can change it to be the same by changing the code to 103.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
Convert(datetime,tblAssetCustom.Custom11,120) As Wartungsvertrag,
tblAssetCustom.Serialnumber,
Convert(nvarchar,tblAssetCustom.PurchaseDate,103) As [Purchase Date],
Convert(nvarchar,tblAssetCustom.Warrantydate,103) As [Warranty Expiration],
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.Custom11 < GetDate() + 60 And tblAssetCustom.Custom11 >
GetDate() And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc
LF
Engaged Sweeper
Thank you for the prompt answer.

I've tuned the built-in report to make it work with a custom field:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
Convert(datetime,tblAssetCustom.Custom11,120) As Wartungsvertrag,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration],
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.Custom11 < GetDate() + 60 And tblAssetCustom.Custom11 >
GetDate() And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc


and it works great.

I'm just wondering if in the HTML email I could get the dates displayed in the european format dd/mm/yyyy
instead of mm/dd/yyyy
Esben_D
Lansweeper Employee
Lansweeper Employee
The easiest way to achieve this is to use a report alert. Lansweeper has a built-in report called "Asset: Out of warranty in 60 days" If you schedule this report to be sent to you daily in a report alert. Since report alerts only send out an email when the report contains a result. Once a asset's warranty runs out in 60 days you will receive an email with the report.

You can find more information about report alerts and how to configure them in this knowledgebase article: https://www.lansweeper.com/kb/113/sending-email-alerts.html