cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Thorre_Pfeifer
Engaged Sweeper
Hi folks,

is there any way that the asset field "Last patched" get's filled automatically? Currently I do a "Registry scanning" for the valus of name LastSuccessTome located at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install to get a report of each server. Much smarter would be that the asset field get field.
Thanks for any ideas.

Regards
Thorre P
1 ACCEPTED SOLUTION
Jeremy_D
Champion Sweeper
The LastPatched field does not get filled in automatically. You have to manually enter a value, as mentioned in the database dictionary. (More information on how to access the dictionary can be found here.) To manually change the Lastpatched value you would:
  • Browse to an asset's Lansweeper webpage.
  • Hit the "Edit asset" button on the left under Asset Options.
  • Provide a new value for the LastPatched field and click Save Asset.

The value will then get stored inside the LastPatched field from the tblAssetCustom database table, making it easy to add it to a report. We've added your request to have the LastPatched field automatically filled in to our customer wish list, but cannot give a release date for this feature unfortunately. It is technically possible to copy the data from your registry scan (stored in tblRegistry) to the tblAssetCustom.LastPatched field, e.g. by running a database script under Configuration\Database Scripts. We do not currently provide support for writing custom scripts though and recommend backing up your database prior to running any scripts.

View solution in original post

1 REPLY 1
Jeremy_D
Champion Sweeper
The LastPatched field does not get filled in automatically. You have to manually enter a value, as mentioned in the database dictionary. (More information on how to access the dictionary can be found here.) To manually change the Lastpatched value you would:
  • Browse to an asset's Lansweeper webpage.
  • Hit the "Edit asset" button on the left under Asset Options.
  • Provide a new value for the LastPatched field and click Save Asset.

The value will then get stored inside the LastPatched field from the tblAssetCustom database table, making it easy to add it to a report. We've added your request to have the LastPatched field automatically filled in to our customer wish list, but cannot give a release date for this feature unfortunately. It is technically possible to copy the data from your registry scan (stored in tblRegistry) to the tblAssetCustom.LastPatched field, e.g. by running a database script under Configuration\Database Scripts. We do not currently provide support for writing custom scripts though and recommend backing up your database prior to running any scripts.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now