Log inSkip to main contentSkip to sidebar
IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our
Implementation of New Features Policy.
If a User type attribute is configured on an Object, it would be helpful to be able to perform an AQL search against this attribute based on the Jira users active/inactive status.
This functionality can be added to JQL through 3rd party apps like ScriptRunner's InactiveUsers Method. But this functionality only works in JQL for Jira issue fields. It would be helpful to have similar functionality built out of the box in AQL.
AQL Solution:
Every user attribute field that contains an inactive account has "[X] (Inactive)" appended at the end of the value.
By using an AQL query like:
objectType = Devices AND Owner LIKE "[X]"
This will return all inactive owners, allowing you to automate task creation for reassignment.
Script-based Solution:
A script can be used to identify inactive users and trigger automated actions accordingly.
I hope this helps others facing similar challenges in Jira Assets!
Marios Andriotelis
added a comment - I found two solutions for this issue:
AQL Solution:
Every user attribute field that contains an inactive account has " [X] (Inactive)" appended at the end of the value.
By using an AQL query like:
objectType = Devices AND Owner LIKE " [X] "
This will return all inactive owners, allowing you to automate task creation for reassignment.
Script-based Solution:
A script can be used to identify inactive users and trigger automated actions accordingly.
I hope this helps others facing similar challenges in Jira Assets!
We urgently need the ability to check active/inactive user status in AQL—this is essential for efficient user management!
Filippos Vogiatzis
added a comment - We urgently need the ability to check active/inactive user status in AQL—this is essential for efficient user management!
This will be very useful to identify inactive users and make the appropriate actions.
Marios Andriotelis
added a comment - This will be very useful to identify inactive users and make the appropriate actions.
Unassigned
Andy Rusnak
Votes:
10Vote for this issue
Watchers:
7Start watching this issue
Created:
Updated:
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
Suggestion
I found two solutions for this issue:
Every user attribute field that contains an inactive account has "[X] (Inactive)" appended at the end of the value.
By using an AQL query like:
objectType = Devices AND Owner LIKE "[X]"
This will return all inactive owners, allowing you to automate task creation for reassignment.
A script can be used to identify inactive users and trigger automated actions accordingly.
I hope this helps others facing similar challenges in Jira Assets!