search in all trash spaces

Question

Hi

Is there anyway to search through all trash spaces?

Any idea?

Thanks,

Sebastian Krzewiński · Answer

Hi @kohopir975

You can make a list of all pages in trash by SQL query:

select dateadd(s, convert(bigint,EVENT_AT)/1000,'1970-01-01') as 'Date', cnt.TITLE, usrm.username from dbo.AO_7B47A5_EVENT eve
join CONTENT cnt on cnt.CONTENTID=eve.CONTENT_ID
join user_mapping usrm on usrm.user_key=eve.USER_KEY
where eve.NAME='page_trashed';

Regards,

Seba

David Freitez · Answer

Hi @kohopir975

An idea, since it is Confluence on Server, I would try to search in the database. Here is a link of how it could be achieve, please note that the SQL would vary so you can get your desired search:

https://confluence.atlassian.com/confkb/how-to-perform-a-confluence-site-search-for-keywords-and-links-through-the-database-830284252.html

Hopefully this idea gives you a hint.

Regards,
David