Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

confluence page and attachments

Anderson Hsu
Contributor
December 9, 2020

Is there sql which can find out how many pages and attachments are modify(included deleted /modify content) ? Thanks a lot.

1 answer

0 votes
Brant Schroeder
Community Champion
December 10, 2020

I think this is what you are looking for to see pages. https://confluence.atlassian.com/confkb/how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database-968687591.html

Attachment information is stored in the content table as well so you will just need to change the contenttype = 'ATTACHMENT'

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
4.2.3
TAGS
AUG Leaders

Atlassian Community Events