search in all trash spaces

kohopir975 December 4, 2022

Hi

Is there anyway to search through all trash spaces?

 

Any idea?

Thanks,

2 answers

1 vote
David Freitez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 4, 2022

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

0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 5, 2022

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 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events