osemulti.blogg.se

You can use other properties of course in your where clause.

The above script would set the Barcode property based on the serial number of the asset. UPDATE tblAssetCustom Set BarCode='12345679' WHERE tblAssetCustom.Serialnumber = 'ABCDEFH' UPDATE tblAssetCustom Set BarCode='12345678' WHERE tblAssetCustom.Serialnumber = 'ABCDEFG' Then your database script could look something like this: If you didn't enter other information into it for any asset, you could use this field to store your asset tags. Theoretically, you could also accomplish this with a custom database script, but we don't provide support for this. If your Lansweeper installation is broken due to a custom database script, you would need to perform a restore of your Lansweeper installation.īelow is a high-level example of how you might go about this with a custom database script. Lansweeper has a built-in asset property called Barcode. Manually adding the asset tags to the assets would indeed be the preferred option, although this task can be cumbersome if the change affects many assets. We aren't able to guarantee that this feature will be implemented or provide you with an estimated release date at this time.

Unfortunately, our asset import functionality can indeed only be used to import new assets into the Lansweeper database, it can't be used to update assets that are already in the Lansweeper database. This feature was added to our customer wish list.