SQL to see pages views with users

[Jacynthe.Thibault]

Hi,

I need an SQL query that we can run in our confluence to get a list of users who view each pages (with the date they last viewed the page).  Thanks

Something like:

Pages	Who	Date
Page A	adoir	April 25, 2023
Page A	fthiu	April 24, 2023
Page B	rtyuh	February 20, 2022
Page C	lkjgki	January 10, 2020

[Clark Everson]

Hi @Jacynthe.Thibault 

Can you try in your staging instance

SELECT
cwd_user.user_name AS username,
 content.title AS page_title,
 content.creationdate AS page_creation_date,
 content.lastmoddate AS page_last_modified_date,
 page_view.date AS view_date
FROM
 content
 JOIN page_view ON content.contentid = page_view.contentid
 JOIN cwd_user ON page_view.username = cwd_user.user_name
WHERE
 content.contenttype = 'PAGE'
ORDER BY
 cwd_user.user_name,
 page_view.date;

[Jacynthe.Thibault]

@Clark Everson   Thanks  We tried it but the page_view was not find as table or view, it seems that it is not in the DB