SQL: Modify Asset-Relation based on Asset-Field

[Filo]

Hi all,

we recently imported some offline assets not scannable by lansweeper (here: Smartphones, Switches behind firewalls, Cellphones...).

We used the Asset-Field "contact" to import either the user's shortname (as it is also used in Active Directory) or the user's full EMail-Adress (the smartphones delivered this).

So now we have a field "contact" filled with the user's relation.
And these assets have all a new "state" set to "Offline Asset" to make clear that they are not scannable.

What we'd like to accomplish would be a mass-update on those assets creating a Lansweeper Asset-User-Relation similar to my old question here: http://www.lansweeper.com/Forum/yaf_postst12917_Initial-Filling-of-User-Relation-by-using-last-logged-on-user.aspx#post46271

Basically the SQL needs to select all "Offline Assets" (from "State") and modify them with "Contact" referring to an AD-User in an asset-relation. But even with above mentioned old thread I'm currently not able to figure out what SQL-Statement will fit.

Is anyone able to help me out on this?

Thanks in advance,
Martin!