Import Asset 'owner' as JSM 'identity' during import using the e-mail

[Elena Jakubiak]

On this page, the instructions read "If you are importing Jira users or groups into Assets, you must identify the users or groups by their IDs, not their Name(s)."

This is cumbersome as we'd need to go a massive join to get e-mails and IDs into the import csv. Is there a way to use AQL on the import to find users by their e-mails? 

[Evgenii]

Hi, @Elena Jakubiak 

When you're configuring mapping, in import, you can use such AQL, to find matching user:

Email = ${email}

In my similar import it's made so:

[Elena Jakubiak]

Is employee a custom object you created or a proper "JIRA Identity"? 

[Elena Jakubiak]

I think the issue is that I can't seem to get AQL correct for the "User" class

[Evgenii]

It's custom object. Looked for exact match, with Jira user.
For Jira User as label I use email, so it's enough to use such mapping

[Evgenii]

"Account Name" it's my attribute, not yours, it's example. Show please attributes of category, where you import Jira User objects

[Elena Jakubiak]

I agree it should work, but I cannot get JSM Assets to find the attribute 'email' or any variant of it. 

This AQL Works



This AQL Does not work

So to import to a JIRA user I need to either
1. Find a field on which I can set AQL
2. Find some "base" object (like the equivalent to $)

[Evgenii]

"Owner.email" won't work, try Owner.email without quotes, or "Owner".email

So, for mapping you can use next AQL

email = ${email}

[Elena Jakubiak]

The quotes are added by JSM

[Evgenii]

@Elena Jakubiak , we need to clarify, what atrributes has object type Owner. Can you show it?

[Elena Jakubiak]

The object I am trying to import has this schema. Owner is a field in the object schema . Owner is of type "User" which is a JIRA built in (it is all the users of JIRA at our office). I cannot find the attributes for "User" which will work in AQL. 

[Evgenii]

Ok, got it.

Have to check import of users in Cloud. Slightly confused.

[Elena Jakubiak]

All the JIRA users already exist so I don't want to make them all again. I can link my objects to the existing JIRA users if I import the user ID instead of user e-mail, as it says in the instructions. I am just asking isn't there a way to use AQL to link via e-mail. If anything, I would just end up add user IDs to our imports. 

[Elena Jakubiak]

At this point, I'm thinking that user ID is in one table, and the associated information (e-mail, name, ...) is elsewhere which is why I can't query in AQL on User attributes. 

[Evgenii]

One last try - you can use mapping in import, without attributes. Just like on your screenshot, where you used query: "Owner" = "ejakubiak@irobot.com"

[Elena Jakubiak]

Yep, tried that. Can't get it to work.