Business Adapter to Link Asset's with User's

[nmonforte]

I am trying to create a Business Adapter to link Assets with User's.

Reason:
We have Mac's in our environment and when they are scanned there is no calculated user (therefore user-based licenses are not calculating as desired).

Objective:
Have a business adapter run on a schedule which reads Serial Number (SN) and Username (UID) from a database and will update the Flexera asset with the assigned number.

Attempted:
Create new business adapter (success)
Link with database to pull SN and UID (success)
Add asset into business adapter (success)
Match on Serial Number:
-> Properties: Field Value (serial number)
-> Matching: Use this property for matching existing data
Assigned to User ID:
-> Does not show the options from the data pull (only show's RowNumber)
->Tried using the Flexera user ID, still only show's the RowNumber as a source

Is this possible to do? Any guidance appreciated!

[mfranz]

Hi,

This should be possible. Could you share your import file (xml) AFTER you removed any sensitive data (server name, users, passwords) from it?

Best regards,

Markward

[ChrisG · Accepted solution]

I think the step you are missing in the adapter is a step to lookup the user.

Before the "asset" object in the adapter, add a "user" object. Uncheck the "Create" and "Update" options (so that the user record you want is looked up but not changed), and map the UID field to the appropriate user field you are using for matching.

Once you have done this, you should find the User ID value that has been looked up available in the drop down list for the asset's "Assign To User ID" property.