How to find out who deleted pages in space

Evgeny Plotnikov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 11, 2022

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.

2 answers

1 accepted

0 votes
Answer accepted
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 11, 2022

Hi @Evgeny Plotnikov ,

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

Hope this helps,

Fabio 

Anuj Sharma
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 1, 2022

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

0 votes
Anuj Sharma
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 1, 2022

Hi All, 

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

Thanks,

Anuj Sharma

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events