confluence page and attachments

[Anderson Hsu]

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

[Brant Schroeder]

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'