Fill field "Last Patched" automatically

[Thorre_Pfeifer]

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

[Jeremy_D · Accepted solution]

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.