Notify expiration of support contracts and maintenance agreements

[LF]

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.

[LF]

That worked like a charm. Thank you so much.

[Esben_D]

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]

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 · Accepted solution]

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