→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dsurmon
Engaged Sweeper
Is it possible to add an asset programmatically to Lansweeper using an sql call?
6 REPLIES 6
Esben_D
Lansweeper Employee
Lansweeper Employee
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
Engaged Sweeper
I track a lot of different types of assets
wcb
Engaged Sweeper III
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
Engaged Sweeper
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
Lansweeper Employee
Lansweeper Employee
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
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