Fetch modified date information

[RichardA]

Hi Team,

I want to find last modifier/editor and how many times each confluence page got updated in single space.

Can anyone help me how to do this requirement.

i am using Oracle database. is it possible to get the required info using db query.

Thanks !

[Suvradip Paul]

Hello @RichardA ,

I presume you could check page history and view changes done in different versions, please check this guide - https://confluence.atlassian.com/doc/page-history-and-page-comparison-views-139379.html and let me know if that helps.

[RichardA]

Hi @Suvradip Paul I am looking for entire instance information. i think Its very difficult to find the each page information using page history.

Thanks !.

[Srinatha Tondihal]

Hi @RichardA ,

Welcome to the Atlassian community. 

Yes, you can fetch this info from database as well. The below article has the queries , you can go through the same. 

• how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database 

I hope the above information helps. Have a good day 

Thanks,

Srinath T

[RichardA]

Hi @Srinatha Tondihal  Thanks for the update.

I can able to fetch the info from the above mentioned URL. 

My requirement is to fetch the entire page event information i.e, how many times one page got updated and who ever updated the page.

Can you help me how to do this using database query.

Thanks !