Ability to see which users viewed the attachments in Confluence Analytics

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: Core - Analytics
    • None
    • 0
    • 3

      Problem Definition

      The Confluence Analytics Gui, introduced in Confluence 7.12, displays the number of views an attachment has.
      But unlike the page views feature, it does not show which users viewed the attachments.

      Suggested Solution

      Include an feature that shows which users viewed the attachments.

      Workaround

      All the required data is stored in the table "AO_7B47A5_EVENT", and can be extracted there.
      Run the query below to see who viewed the attachments

      select c.title,to_timestamp(cast ("EVENT_AT" as bigint)/ 1000) , "NAME", "SPACE_KEY", um.username  from "AO_7B47A5_EVENT" e, content c, user_mapping um where e."USER_KEY" = um.user_key  and  e."CONTENT_ID" = c.contentid and e."NAME" = 'attachment_viewed';
      

            Assignee:
            Unassigned
            Reporter:
            davy (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: