Within LANDesk ITBM 7.2.6, an excel data import / mapping has been created. Within this excel file, all assets are defined with several details, including the user where the asset is attached/located to.
However, when imported, these assets aren't actually 'linked' to the users. Within the asset management a "link" can be seen (within the asset window itself), but not the other way round: within the users "configuration items" folder in administration, no items can be seen. Therefore, also not in the incident screen.
I also found out that if I do a manual "add configuration item" at the user in the Administration module, it WILL appear correctly. At that moment, in the database, an entry is created in cf_user_config_item. This makes sense, as it looks to be the actual link between the asset and the user.
My question is, how do I configure the data import to automatically create this link? We are importing hundreds of assets and I don't want to link them manually to the users.
Attached are some screenshots from the steps mentioned.
Importing assets and then linking to users requires a two stage import. This is becuase the relationship between users and assets is stored in a linking table called User Config Items. It's done this way becuase the relationship is a many to many one. The approach to making the link is it do the imports that ensure you have all of your users loaded up and then all of your assets and then create a separate import to the User Config Item table that creates the rows that link them together. This import will only use the CI name and the user name. You'll need to create an additional field in the table using Object Designer to hold a unique identifier for the relationship. This can be built at import time by concatenarting the user and asset values.
Have you defined the mapping at the relationship level of the objects, or at the attribute level? In 7.2.6 you were able to just apply it at the relationship level, but this was causing some problems, so it has been changed in 7.3 so you need to map at the specific attribute of the related object.