Insight: IQL on Inactive user

[Mickaël Orsolino]

Hi,

We would like to create some automation rule to identify all JIRA inactive user associated to an Insight object.

Is it possible to filter by IQL?

Thank you in advance.

Regards,

Mickael Orsolino

[David Sumlin · Accepted solution]

I don't believe this is possible. I think your best bet would be to use Groovy script.

[Aurimas Grikienis]

Hi,
if your users are synced with AD there are LDAP sync groups user must be in to be in Jira (and Insight). You can IQL search for user NOT in those groups
"User" NOT IN group("AD_GROUP_1, AD_GROUP_2, AD_GROUP_3") AND "User" IS NOT empty

Now I have 7 ADs and 17 LDAP sync groups in them so IQL is not "elegant", but it works :)

P.S. This is for Jira server. Have no experience with cloud.