How to find the oldest page(s) in Confluence?

[Alex Bobrovski]

Hi,

I want to find the oldest page - the page that was created before the rest. I mean the first page on my Confluence instance.

Also, can I get the list of all the Confluence pages sorted by the creation time in reverse chronological order?

[Azwandi Mohd Aris]

I think it's fun to work out the SQL query, so here it is:

select * from content where contenttype = 'PAGE' and prevver is null order by creationdate asc;

Hope that also helps!

[Alex Bobrovski]

ok, I had to watch the database. Found.