How to find pages created OR modified by specific user in a given time period

Question

On confluence version 7.10.2.

I want to get a list of all pages modified or created by a particular user during 2020. What I do not want is a list of all pages modified during 2020 that a user has ever modified in the past.

It seems if I use the advanced search and choose the user as a contributor and the modified period of 2020.. I am getting pages that the user created or modified in years past (2019, for example) that were also updated (by someone else) in 2020.

I do not have access to write SQL queries against the database, so I will need to figure this out via the UI.

Joe Bloggs · Answer

Same, this does not work at all. No SQL access. Just another gap in the API?

Brant Schroeder · Answer

@Mike Olson On server you can use SQL to find this information. Example: https://community.atlassian.com/t5/Confluence-questions/How-do-I-search-Confluence-for-pages-that-were-last-modified-by/qaq-p/42881

OR https://confluence.atlassian.com/confkb/how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database-968687591.html

You can also make a user macro to return results. Example that you would need to adjust: https://community.atlassian.com/t5/Confluence-questions/How-do-I-list-all-pages-with-titles-and-last-modified-by-and/qaq-p/41974

Or try the recently updated macro https://confluence.atlassian.com/doc/recently-updated-macro-139519.html

Or

If your instance is large you will want to go the SQL route and have someone who can access it do it.