Confluence Wiki trash report

Pankaj Rana February 16, 2024

Hi team, I am looking for a way to find out how many pages or contents are there in "Trash" collectively for all Wiki spaces, blogs in our Wiki instance. I think there is no out of the box feature available but there must be some Microsoft SQL queries that should provide such report. Any help is much appreciated.

1 answer

0 votes
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 16, 2024

Hi @Pankaj Rana ,

Run this SQL to get count of pages in trash. 

select count(CONTENTID) from CONTENT where CONTENT_STATUS = 'deleted' and CONTENTTYPE = 'PAGE';

Available  CONTENTTYPEs are

ATTACHMENT 
GLOBALDESCRIPTION
USERINFO 
PAGE
SPACEDESCRIPTION
CUSTOM
COMMENT
BLOGPOST
DRAF

Available  CONTENT_STATUS are
current
deleted
draft 

Pankaj Rana February 27, 2024

This is helpful Rilwan but any guidance on getting size of the contents. For example If I want to get the collective size of attachments in deleted. 

Suggest an answer

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

Atlassian Community Events