Custom field for Last LS Push

[madmanxing]

Hi everyone,
sorry for the noob question but i cant seem to get this to work.
on the Asset page i would like to have Lets say Custom1 Column to say Last LS Push
and it to show the date/time of that scan

right now i was able to look under database documentation and see i think the value i need to use is LastLsPush but it doesnt seem to work.
Custom1 is now labeled Last LS Push like i said and i thought it should be pulling the LastLsPush value from the database but the entire column is still blank.
what am i doing wrong?
i noticed in the database documentation is shows the type of LastLsPush as datetime
but in the custom field setup in the dropdown i only have date OR time from the choices.

[madmanxing]

Okay, thank you!

[Esben_D]

Currently the asset custom field are designed for manual data input. The database field you mentioned is the field that does indeed store when the last LsPush scan took place. In the web console you can view this in the Scan Time tab of every Windows asset.

It might be theoretically possible to insert data into a asset custom field with a database script. However I would recommend taking a backup before trying this. Backup instructions can be found here: https://www.lansweeper.com/kb/94/backing-up-your-installation.html

If you simply want a overview of all the assets with the last time they were scanned with LsPush it would be a lot easier to make a report for this.