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.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG