User macro to show who has recently seen your page...

[Martin James]

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. 

[AnnWorley]

Have you considered a third party add-on like Viewtracker?