ddd

 - Find content that has been modified since a certain date.

SELECT content.title, content.pageid, content.contenttype, content.lastmoddate
FROM content
WHERE(content.lastmoddate) > '2019-05-10';
-- Count content that has been modified since a certain date.
SELECT count(*)
FROM content
WHERE(content.lastmoddate) > '2019-05-10';

-- Find back deleted content (that has not been purged)
SELECT *
FROM content
WHERE content_status = 'deleted';

How to export a list of all recently modified content within a Space? | Confluence | Atlassian Documentation