Skip navigation
4964 Views 6 Replies Latest reply: Sep 25, 2009 2:32 AM by elampert RSS
Rookie 1 posts since
May 6, 2009

Has received 1 of 9 achievements.
Currently Being Moderated

Jul 23, 2009 5:16 AM

Linking Imported Assets to users

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.

Attachments:
  • aparker Employee 593 posts since
    Feb 18, 2009

    Has received 6 of 9 achievements.
    Currently Being Moderated
    1. Jul 23, 2009 5:30 AM (in response to crackanimal)
    Re: Linking Imported Assets to users

    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

  • elampert Rookie 8 posts since
    Mar 5, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    2. Sep 24, 2009 2:42 AM (in response to aparker)
    Re: Linking Imported Assets to users

    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

  • aparker Employee 593 posts since
    Feb 18, 2009

    Has received 6 of 9 achievements.
    Currently Being Moderated
    3. Sep 24, 2009 2:54 AM (in response to elampert)
    Re: Linking Imported Assets to users

    Hi Etienne,

     

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

     

    Andy

  • elampert Rookie 8 posts since
    Mar 5, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    4. Sep 24, 2009 3:26 AM (in response to aparker)
    Re: Linking Imported Assets to users

    Hi,

     

    Here is a screenshot of my mapping.

     

    Map.png

     

    Thx for your help.

     

    Etienne

  • aparker Employee 593 posts since
    Feb 18, 2009

    Has received 6 of 9 achievements.
    Currently Being Moderated
    5. Sep 24, 2009 3:32 AM (in response to elampert)
    Re: Linking Imported Assets to users

    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

  • elampert Rookie 8 posts since
    Mar 5, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    6. Sep 25, 2009 2:32 AM (in response to aparker)
    Re: Linking Imported Assets to users

    Hi,

     

    That is exactly what i had done.

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

     

    Thx a lot.

     

    Etienne

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software