Uploaded image for project: 'Automation for Jira Server'
  1. Automation for Jira Server
  2. JIRAAUTOSERVER-88

Make audit log filterable/searchable

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 7.4.0
    • Configuration
    • None

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      It would be really helpful if the audit log was filterable/searchable, especially by issue.
      Sometimes we need to look up if a automation rule has run correctly on a specific issue, with the current audit log it is near impossible to find the specific entries.

      All the "no action performed" entries are also unhelpful and only clog the audit log.

      The most obvious filters would be:

      • date
      • status
      • issue

      Workaround
      We can filter the audit log running a query in the database, as the query below searching for all rules executed for issue TST-123.

      select AIAI."NAME", AI.* from jiradb.dbo."AO_589059_AUDIT_ITEM" AI
join jiradb.dbo."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI on AI."ID" = AIAI."AUDIT_ITEM_ID" 
where AI."CATEGORY" = 'SUCCESS'
   and AIAI."NAME" = 'TST-123'

        1. Screen Shot 2020-10-19 at 12.39.31 PM.png
          Screen Shot 2020-10-19 at 12.39.31 PM.png
          151 kB
        2. Automation for jira audit log.mov
          23.62 MB

            [JIRAAUTOSERVER-88] Make audit log filterable/searchable

            Ludwig Pils DE made changes -
            Comment [ how is this closed? a workaround was provided. that's all.
            Please reopen and make the Audit log filterable / searchable.

            We have thousands of executions each day, and one cannot go through fifty pages of Audit log, just to find the one bad execution. ]
            Daniel Ramotowski made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Daniel Ramotowski made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Daniel Ramotowski made changes -
            Fix Version/s New: 7.4.0 [ 97903 ]
            Fix Version/s Original: 7.3.6 [ 97816 ]
            Daniel Ramotowski made changes -
            Status Original: Gathering Interest [ 11772 ] New: In Progress [ 3 ]
            Daniel Ramotowski made changes -
            Fix Version/s New: 7.3.6 [ 97816 ]
            Marcus Silveira made changes -
            Description Original: It would be really helpful if the audit log was filterable/searchable, *especially by issue*.
            Sometimes we need to look up if a automation rule has run correctly on a specific issue, with the current audit log it is near impossible to find the specific entries.

            All the "no action performed" entries are also unhelpful and only clog the audit log.

            The most obvious filters would be:
             * date

             * status

             * issue             		New: It would be really helpful if the audit log was filterable/searchable, *especially by issue*.
            Sometimes we need to look up if a automation rule has run correctly on a specific issue, with the current audit log it is near impossible to find the specific entries.

            All the "no action performed" entries are also unhelpful and only clog the audit log.

            The most obvious filters would be:
             * date

             * status

             * issue

            *Workaround*
            We can filter the audit log running a query in the database, as the query below searching for all rules executed for issue TST-123.
            {code:SQL}
            select AIAI."NAME", AI.* from jiradb.dbo."AO_589059_AUDIT_ITEM" AI
            join jiradb.dbo."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI on AI."ID" = AIAI."AUDIT_ITEM_ID"
            where AI."CATEGORY" = 'SUCCESS'
               and AIAI."NAME" = 'TST-123'
            {code}
            Victor Seger (Inactive) made changes -
            Link New: This issue relates to JIRAAUTOSERVER-260 [ JIRAAUTOSERVER-260 ]
            Denise Unterwurzacher [Atlassian] (Inactive) made changes -
            Attachment New: Automation for jira audit log.mov [ 394994 ]
            Attachment New: Screen Shot 2020-10-19 at 12.39.31 PM.png [ 394995 ]
            Michael Bachmann created issue -

              Unassigned Unassigned
              77754c1fadc3 Michael Bachmann
              Votes:
              14 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: