Enterprise Vault: useful query to find the date range of emails stored in the index

(... run against the Vault Store database...)

SELECT MIN (recordcreationdate) AS 'Oldest Item Date'
, MAX (recordcreationdate) AS 'Youngest Item Date'
FROM JournalArchive

WHERE IndexSeqNo BETWEEN 121649147 AND 126649435 '(numbers found in the Enterprise Vault Admin Console for Index Volume)'