6 Replies Latest reply: Sep 25, 2009 2:32 AM by elampert RSS

    Linking Imported Assets to users

    Rookie

      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.

        • 1. Re: Linking Imported Assets to users
          aparker Employee

          Hi,

           

          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.

           

          Andy

          • 2. Re: Linking Imported Assets to users
            elampert Rookie

            Hi,

             

            I try to do this in a 7.3 environment.

            I create a attribut tempkey in the table User Config Items and a map from my LDMS connection to this table.

             

            I have an error when i try to test the mapping.

             

            error.JPG

             

             

            Is this method possible in 7.3 or only in previous version ?

             

            Thx a lot

             

            Etienne

            • 3. Re: Linking Imported Assets to users
              aparker Employee

              Hi Etienne,

               

              Can you post some screen shots of your mapping settings please?

               

              Andy

              • 4. Re: Linking Imported Assets to users
                elampert Rookie

                Hi,

                 

                Here is a screenshot of my mapping.

                 

                Map.png

                 

                Thx for your help.

                 

                Etienne

                • 5. Re: Linking Imported Assets to users
                  aparker Employee

                  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.

                   

                  Andy

                  • 6. Re: Linking Imported Assets to users
                    elampert Rookie

                    Hi,

                     

                    That is exactly what i had done.

                    With the mapping at the attribute level, it works fine.

                     

                    Thx a lot.

                     

                    Etienne