→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Guest
Lansweeper Employee
Lansweeper Employee
I stumbled across the article below. I would like to do maintenance on all the PC’s, servers, routers, etc.
Then add some date field to Lansweeper and have it remind me using an alert when that device needs maintenance again. Then I can update that field after the maintenance is done on the device.
It looks like based on the info below I can fill out the date in the last patched field.
But don’t see that as an option in the reports I can add to an alert.
Any ideas or a better one than I’m thinking of?
Thanks

*********************************************
would be great, if you could shedule events for all assets and a reminder for upcoming maintenance
#1Lansweeper Member Administration
posted: 3/29/2013 5:42:30 PM(UTC)
Maintenance reminders could be generated if you fill in the Last Patched or Last Backup field on asset webpages.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
In order to let Lansweeper send an email report as result of an expired "Last patched" date, you need to set up a custom report which lists all assets which have expired. Please find an example report below which lists assets having a "Last patched" date older than 180 days. Instructions on how to run a report can be found here. After saving the report, use it for email alerts.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.LastPatched
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.LastPatched < GetDate() - 180 And tblAssetCustom.State = 1
Order by tblAssetCustom.LastPatched

View solution in original post

2 REPLIES 2
Guest
Lansweeper Employee
Lansweeper Employee
Thanks Daniel, will give that a try!

Adam

PS. I got 7 new post notification emails with the same info at the same time about your reply, odd.
Daniel_B
Lansweeper Alumni
In order to let Lansweeper send an email report as result of an expired "Last patched" date, you need to set up a custom report which lists all assets which have expired. Please find an example report below which lists assets having a "Last patched" date older than 180 days. Instructions on how to run a report can be found here. After saving the report, use it for email alerts.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.LastPatched
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.LastPatched < GetDate() - 180 And tblAssetCustom.State = 1
Order by tblAssetCustom.LastPatched