Automate Asset relationship creation - assign assets

[IT_Trev]

I need to create an asset relation for all my computer assets - assign a 'used by' and a user.  Specifically an AD user.  I know which user is using which asset.

How can I automate this?

Is there a command?  An API?   An import of csv/other data source?  I've seen other forum articles that suggested a database script - is that what I need to do?  I'm a bit leery of direct database modification for this, but I'm interested in a usable solution.

I want to avoid clicking on every single asset and adding a relationship for every one of them, doing that 100s (or 1000s) of times.  And then updating when needed, manually.  I want to automate this. I know you can 'mass edit' assets, but I need to make an individual edit for every computer asset.

I've seen several similar requests for this but most were from 2014-2016 (7-9 years ago).

[David_GF · Accepted solution]

Hi @IT_Trev, you can follow the guide on how to link multiple assets: https://community.lansweeper.com/t5/managing-assets/link-assets-to-other-assets-or-users/ta-p/64304#... and link them to the Top Console User.  

Lansweeper will then automatically determine for each Windows computer which user it should be linked to. Each Windows computer will be linked to the domain user with the most logins to the machine, which is usually the user the computer is assigned to.

[sqldba01]

LS Support, On a rabbit trail trying to report on all devices and the department responsible for budgeting replacement based upon most frequently logged in.  I am very close using the login history I found but in searching for more I came across this message. It does NOT appear to solve the problem and does NOT do what is stated "Lansweeper will then automatically determine for each Windows computer which user it should be linked to. Each Windows computer will be linked to the domain user with the most logins to the machine, which is usually the user the computer is assigned to." While it should be able to use the login history to populate Owner or most logins field it only captures last login. And NO relationship are AUTOMagically created. Back to the orginal probeln