cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
francisswest
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
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