Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-69474

Ability to see which users viewed the attachments in Confluence Analytics

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Core - Analytics
    • None
    • 1
    • We collect Confluence 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.

      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';
      

              Unassigned Unassigned
              dsjauwmook davy
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: