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 _Herzum_ · Accepted solution]

Hi @Evgeny Plotnikov ,

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

Hope this helps,

Fabio 

[Anuj Sharma]

Hi @Fabio Racobaldo _Herzum_

This query will not give correct results for the user as lastmodifier does not store the username who deleted the page. If you try to login as a different user and delete a page, the lastmodifier will not store that. Please check the below KB's for detailed information. Please test it once and let me know if my understanding is correct

Regards,

Anuj Sharma

[Anuj Sharma]

Hi All, 

We have published the below KB's to find out who deleted pages in Confluence. Please let me know if it helps

• Confluence 7.5 and above
  
  
  • https://confluence.atlassian.com/confkb/how-to-identify-the-user-who-deleted-page-s-in-confluence-1116283701.html
• Confluence 7.4 and below
  • https://confluence.atlassian.com/confkb/finding-who-deleted-pages-in-confluence-934717801.html

Thanks,

Anuj Sharma