Which Page correspond to wich ID

Question

Hi,

We run this request to have the users who have seen the pages lats time.

SELECT *

FROM "AO_92296B_AORECENTLY_VIEWED"

JOIN user_mapping u ON u.user_key = user_key

ORDER BY "LAST_VIEW_DATE" DESC;

It gives something like this, my question is how can I know which ID corresponds with which page?

CONTENT_IDIDLAST_VIEW_DATESPACE_KEYUSER_KEYCONTENT_TYPEuser_key.1usernamelower_username2639467122002 mai 2023SpaceXff8080817bab80a2017bd147680003PAGEff8080817bab80a2017bd17680003njoinjoi11560573442 mai 2023SpaceYe4e4824c5d6705d1015957530002PAGEe4e4824c5d6705d10154957530002jkiujkiu212730112232 mai 2023SpaceZe4e4824caa9601429fab118100c4PAGEe4e4824c429faa9601429118100c4dfhdfh

Thanks

Jacynthe_Thibault · Answer

Thanks I have the answer with ChatJPT who gives me a powershell script to retreive the page url.  :)

Ken McClean · Answer

It's been a while since I looked at the database.  It used to be that in Confluence, the table that contains the correlation between ID and page name is the CONTENT table.   Maybe check and see if that table still exists, and do a join if so.