Confluence Wiki trash report

[Pankaj Rana]

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.

[Rilwan Ahmed]

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
DRAFT 

Available  CONTENT_STATUS are
current
deleted
draft 

[Pankaj Rana]

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.