Possible to email an external address when a report gets a hit?

[francisswest]

We currently have a 7 year refresh cycle on our hardware. I have created a report to display machines that have hit their 7 year mark. I am wondering if there is a quick way to, when a computer hits that time, automatically send an email with the computer details. Our ticket system (outside of lansweeper for now) accepts incoming emails and generates a ticket for them.

This would prevent me from having to look at the report daily/weekly to determine what machines are *due* for replacement.

Thoughts?

[Bruce_B · Accepted solution]

It's possible to target an email alert for a report towards your helpdesk system's email address. You can also set up the report to only give back assets whose purchase date is exactly 7 years ago (7*365), this doesn't account for leap years, but this'll be accurate within a few days. This report email would only be sent if the attached report has an output, and it should only have an output if one of your assets has a purchase date of 2555 days ago exactly. For more information on setting up email alerts you can check out this article.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssetCustom.PurchaseDate,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.PurchaseDate = GetDate() - 2555 And tblAssetCustom.State =
  1