Jira Insight connect users to computer object via CSV import

Question

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

Jordi Garcia_2tfgnw · Answer

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?

Hannes_4tj1tx · Answer

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.

Hannes_4tj1tx · Answer

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.