Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Last viewed date for different spaces in Confluence

We are looking to archive unused spaces in confluence in our organisation. We have identified the pages which have not been updated in a while.  We also want to find the spaces which have not been viewed for a certain period of time. But we are not able to find it. We have tried SQL query but in that we can see only the recently viewed spaces.

So is there any way to find the last viewed date of all/any confluence space.

1 answer

1 accepted

0 votes
Answer accepted

There is no "view a space", it's a container for pages.  When you "view a space", you're always looking at a page within it, not the space itself.

So, you have to infer "space is used" from the "pages that people are looking at inside it".  Take your list of page views, group by space and sum the numbers of pages views for each space.

Thanks Nic.

But how do I find the list of page views. Not sure from which table I Can find it. 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

🏑 Atlympic Event: Confluence

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

451 views 18 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you