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.
Hi @Evgeny Plotnikov ,
query is correct. Please, ensure that you are connected to Confluence database.
Hope this helps,
Fabio
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.