How to find out who deleted pages in space

Evgeny Plotnikov

I want to know who removed pages from space for a certain date. MySLQ database. Made the following request:

SELECT c.title as "PAGE TITLE" , u.username, c.lastmoddate, s.spacename 
from content c 
inner join user_mapping u on c.lastmodifier=u.user_key 
inner join spaces s on c.spaceid=s.spaceid 
where c.lastmoddate='date' and c.contenttype='PAGE' and c.content_status='deleted' and s.spacename = 'spacename'; 

 got ERROR 1146 (42S02): Table 'confluencedb.content' doesn't exist

Please, help.

Fabio Racobaldo _Catworkx_

Hi @Evgeny Plotnikov ,

query is correct. Please, ensure that you are connected to Confluence database.

Hope this helps,

Fabio