Pull data from last known user

[joshwinters]

Hello all.

Our organization needs to be able to track which assets belong to which department. To avoid manual input, we are looking for a way to take information from the "last known user" and port it into the asset.

For example, last known user on asset A55555 is John Doe. John Doe belongs to Department 12345. We want to port 12345 into Asset A55555 into a custom field of our choice automatically.

Any help on this is greatly appreciated!

[Hemoco · Accepted solution]

You would have to write a custom database script that copies the tblADusers.Department values over to tblAssetCustom.CustomX. We no longer provide support for writing custom database scripts unfortunately, as this falls outside of standard Lansweeper functionality.