Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15403

It would be helpful to add an AQL Function to be able to check for Inactive/Active User Status for User attribute type searches.

XMLWordPrintable

    • 1
    • 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.

            [JSDSERVER-15403] It would be helpful to add an AQL Function to be able to check for Inactive/Active User Status for User attribute type searches.

            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! 

            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! 
            SET Analytics Bot made changes -
            UIS New: 1

            Antreas Solou added a comment -

            Sometimes I wonder how such basic functionality is not already available.. 

            Antreas Solou added a comment - Sometimes I wonder how such basic functionality is not already available.. 

            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!

            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!

            Marios Andriotelis added a comment -

            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.
            Marc Dacanay made changes -
            Labels New: ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 978783 ]
            Andy Rusnak created issue -

              Unassigned Unassigned
              d382421eef02 Andy Rusnak
              Votes:
              10 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated: