We can query the Confluence database to show who has landed on a page with the following query:
SELECT
CONTENT_ID,
TITLE,
SPACENAME,
LAST_VIEW_DATE,
user_name,
display_name
FROM AO_92296B_AORECENTLY_VIEWED
LEFT JOIN user_mapping ON AO_92296B_AORECENTLY_VIEWED.USER_KEY = user_mapping.user_key
LEFT JOIN cwd_user ON user_mapping.lower_username = cwd_user.lower_user_name
LEFT JOIN CONTENT ON AO_92296B_AORECENTLY_VIEWED.CONTENT_ID = CONTENT.CONTENTID
LEFT JOIN SPACES ON AO_92296B_AORECENTLY_VIEWED.SPACE_KEY = SPACES.SPACEKEY
LIMIT 100000;
This shows results based on unqie views over a 3 months period.
Is there any way we can achieve the same result by creating a User Macro?
I want to be able to use the Macro paramater field to search for a page which shows who has seen that page.
