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

How to get the list of last 300 pages that have been changed?

Alex Bobrovski Jul 27, 2011


I'm going on vacation. When I come back after two-week holidays, I'd like to get the list of all the pages that will have been changed.

The macro {recently-updated} provides about 50 last changes, that is the maximum.

How to get the looooong list of all the user's commits?


4 answers

1 accepted

1 vote
Answer accepted
Lis Riba Jul 27, 2011

You want updates for all spaces?

Before vacation, subscribe to daily updates [Your name > Settings > Email]

You will then receive daily emails listing all changes (that you have permission to view)

It's not precisely the same format as {recently-updated}, but will list all the changes that you've missed.

If you just want changes in a particular space, then start watching that space, and you can compile the emails when you return.

Hope this helps, and have a nice vacation.

1 vote
Matthew Cobby Jul 27, 2011

You could use a basic SQL Query (assuming SQL Server):


select content.title, content.lastmodifier, content.lastmoddate , spaces.spacename, spaces.spacekeyfrom content, spaces where contenttype='PAGE' and content.spaceid=spaces.spaceid order by lastmoddate desc

If you're using MySQL you could use the Limit keyword instead of setting the rowcount

1 vote
Arun Bhalla Jul 28, 2011

I like to use my RSS reader to track space updates across an entire Confluence instance. It's pretty easy to create an RSS feed link within Confluence by using the top-level Browse menu and click on "Feed Builder." From there, you can select the type of updates you want to track, which spaces, and if you click on "Advanced Options," you can specify the number of entries in the feed. For performance reasons, the maximum limit is 200 entries, which may be suit you fine when you come back.

If you want to ensure you track everything that changed while you're away, you can plug the generated feed link into your feed reader and have the reader refresh the link frequently (daily or every few hours).



Alex Bobrovski Jul 28, 2011

Thans a lot, guys.

Thank you very much!

All advice is really helpful.

1 vote

Hallo Alex

Arun and Lis have given the two answers that I would recommend. However, I'd recommend that you use them both. :) So:

  • Add yourself as a watcher of the spaces that interest you.
  • Subscribe to an RSS feed for the spaces that interest you.

The reason for doing both is this:

  • If people check the "Minor change" checkbox when they edit a page, their changes will not appear in your notifications from the "watch" option.
  • The RSS feed does not report on deleted pages, only on added and updated pages.

I hope this helps!

Cheers, Sarah

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

920 views 0 19
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