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.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.