Import data to custom field

[Alan_LS]

I have created a Custom field for our own asset number. How could I import or populate my own asset number into the custom field based on the serial number? Otherwise, I have to do a manual way to input the data on each device.

[Esben_D]

It might be a bit easier to do it with the bottom mass edit assets option on the assets overview page.



Alternatively, you can also write a database script to do it. The asset custom fields are stored in the tblAssetCustom table. I do recommend creating a backup before running any database scripts. Backup instructions can be found here: https://www.lansweeper.com/kb/94/backing-up-your-installation.html