Adding assets programmatically

[dsurmon]

Is it possible to add an asset programmatically to Lansweeper using an sql call?

[Esben_D]

Unfortunately, I don't have a import script example.

Most asset data is in tblAssets and most asset data related tables are also linked to that table. If you have a test environment you can try creating the script by using our database documentation. If you can't find the database dictionary, there is a guide here: https://www.lansweeper.com/forum/yaf_postst9870_Lansweeper-database-dictionary.aspx

Obviously I would not advice trying this in a production environment. Issues related to custom database modifications are not supported by our support team. If need be, you can find a guide on how to create a full backup of your Lansweeper installation here: https://www.lansweeper.com/kb/94/backing-up-your-installation.html

[dsurmon]

I track a lot of different types of assets

[wcb]

Are you looking to add various types of assets or just computer assets? I would suggest using SQL Profiler to monitor activity during an upload using the import utility for each type of asset you are adding.

[dsurmon]

Yeah, I'm trying to avoid another process of physically uploading a file. Is there an example SQL create everywhere around that I'll be able to use as a starting point? Thanks!

[Esben_D]

Since Lansweeper uses an SQL server, you can indeed add assets to Lansweeper using an SQL script. However, this does require some basic SQL scripting knowledge and advanced knowledge of the Lansweeper database structure.

For most people I would recommend using the import feature to add assets to Lansweeper: https://www.lansweeper.com/kb/88/importing-assets.html

[dsurmon]

Charles.X wrote:
Since Lansweeper uses an SQL server, you can indeed add assets to Lansweeper using an SQL script. However, this does require some basic SQL scripting knowledge and advanced knowledge of the Lansweeper database structure.

For most people I would recommend using the import feature to add assets to Lansweeper: https://www.lansweeper.com/kb/88/importing-assets.html