Can we find out who deleted a question or an answer in confluence questions?

Mustafa Abusalah

I'm trying to find out who deleted an answer in Confluence Questions, I have used the below query:

            select um.username, c.title, s.spacename, c.lastmoddate
            from content c
            join user_mapping um on c.lastmodifier = um.user_key
            join spaces s on c.spaceid = s.spaceid
            where c.content_status = 'deleted' and contenttype = 'CUSTOM'
            order by username;   

But it looks the answers once deleted are removed from the DB? Is that true?

Gonchik Tsymzhitov

Looks like it is true.

I have checked on backup and test db, really different. 

 

Hence better way is review backup file.