Project and space creation date

[Rumceisz]

Hi All,

I need some info for a presentation. I'd like to make a comparison: how much projects and spaces were in our Jira and Confluence 1 year ago and today? Of course the data of today I know, but how could we get the data of previous dates.

Is there a feature I get the project's and space's creation date?

Many thanks in advance!

Rumi

[John Garcia · Accepted solution]

For the JIRA half of this question, it would make sense to just look at the first Issue created in the project, as that's really the start of things:

select MIN(created),pname from jiraissue join project on jiraissue.project=project.id where created < '2012-02-13' group by pname;