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

Ability to see which users viewed the attachments in Confluence Analytics

    XMLWordPrintable

Details

    • Suggestion
    • Status: Gathering Interest (View Workflow)
    • Resolution: Unresolved
    • None
    • Core - Analytics
    • None
    • 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.

    Description

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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: