Jira Insight connect users to computer object via CSV import

[Hannes]

Hello!

So I am trying to import users from a CSV file and by doing so connect those users to already existing Computer objects. When I try to add the Datornamn (Computer name) field I need an IQL for it to work. I've tried to google also tried some IQLs I found but nothing has worked so far.

In the object field "hyrdatorer" all the computers are stored and I now want the new users to connect to the right computer. I have all the users and computer names in the correct order in the excel document. So now I need some expert help here to make it all go together

Thanks in advance

[David Sumlin]

Since the Datornamm attribute is an object, you'll need IQL in your import mapping to relate the PCName field in your CSV file to your object.

You can use similar IQL such as objectType = Datornamm and label = ${PCNAME}

** I'm not sure that Datornamm is the name of your PC object type, nor if the label is a unique identifier.

[Hannes]

Hello!

So let say I want to connect "user 0" to 8NQ2PW2 via IQL, is then your label IQL what I should use? So basically I just want to be able to go to any user and then click on the Datornamn (Computer name) and see all the info about it because the two objects are linked together. As of right now, I have just imported one CSV file with computers and info about that and one for the users, and as you see they aren't linked in any way.

[Alexis Neveu]

Hi,

I just had a similar use case : linking existing Jira users to assets, at import time. Keep in mind that Jira users have to be referenced using their Id. So, provided that the user attribute is of type "user", you just need to configure object type mapping so as to link datalocator containing the userid with the object type attribute of type user.
You can easily retrieve userid of all you jira users using Jira API and a powershell script (I can share one if interested)

[Hannes]

Hi!

So as of right now these users you see in my pictures aren't real Jira users. It's just a user object I imported via CSV. Although in the future we might integrate our AD to Jira so I would be glad to see your powershell script for that as it might help me in future projects. I did explain a bit more about what I am trying to achieve right now in the comment above if you also have some tips or tricks for that.

[Jordi Garcia]

I'm my case It would be perfect if I could match a email in the CSV file with the user object email from the Jira user.

Is there a way to do that or access that from the IQL?