create assets via query

[Slicer]

Hello

I am going to transfer our inventory into lansweeper but i am unsure on how to create the correct query.

I would like to fill the following fields in 1 query
tblAssetCustom.Model,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Custom1,
tblAssetCustom.Serialnumber,
tblAssetCustom.Location,
tblAssetCustom.Department,
tblAssetCustom.Custom2,
tblAssetCustom.Comments


Any help would be much appreciated

[Hemoco]

No, "New Asset" requests are processed internally. This button doesn't trigger a simple SQL command that you could copy.

[Slicer]

Is there any way to get the query that is used by the "New Asset" page?

[Hemoco]

We do not provide support for this, but below are the tables you need to manually create an asset. It might be easier to connect to the Lansweeper database using something like Microsoft Access, so you can edit the fields directly.

tblAssets
tblAssetCustom
tblAssetGroupLink