Is there any provision to get the Last Viewed Space details of a space from confluence?

Mohammed Siyad

Hi team,

I am just looking for query in SQL or a method in groovy to get the details of last viewed dates of each item in confluence.

SELECT SPACE_KEY, LAST_VIEW_DATE from "AO_92296B_AORECENTLY_VIEWED"

I found out this query would help, but its not getting the actual stats(I mean the entire space details)

Appreciating any help!!

Mehmet Şirin Usanmaz_egbzkb

Hi @Mohammed Siyad ,

You can get a small report with the following sql query. You can check the tables used for detailing.

SELECT c.title, av."SPACE_KEY", u.username AS Viewer, av."LAST_VIEW_DATE"
FROM content c 
JOIN "AO_92296B_AORECENTLY_VIEWED" av ON c.contentid=av."CONTENT_ID"
JOIN user_mapping u ON av."USER_KEY" = u.user_key 
JOIN user_mapping um ON c.lastmodifier = um.user_key 
WHERE prevver IS NULL 
AND contenttype = 'PAGE' 
ORDER BY title;