How to get all Projects creation date with DB SQL query?

[CLSA CorporateApplication]

I have 2 JIRA site

1) v5.2.6

2) v8.1.0

How to get all Projects creation date with DB SQL query in these 2 JIRA version.

Your help is gratefully appreciated!

[Joe Pitt]

As @Nic Brough -Adaptavist- and @Sagar Mahajan said you can't get it from Jira. One solution would be to get the create date of the first issue. That may not give you an exact date, but would be close. 

[Nic Brough -Adaptavist-]

Indeed, I think the very first reporting plugin I wrote (for Jira 3.0.3) was a simple list of all projects displaying their ID, count of issues, latest issue sequence number, earliest issue creation date, and latest issue updated.

That made it quite easy to see unused or dormant projects, and for those where no issues were giving useful create/update dates, you could use the ID to infer when it was created because you could place it between two others with data!

[Nic Brough -Adaptavist-]

Jira doesn't store when a project was created (a line does go into the audit log, but that can be turned off, and it gets cleared regularly too)

So there's no way to do this with SQL at all.

[Sagar Mahajan]

Hi @CLSA CorporateApplication There is no easy way to identify the project creation dates using SQL query.

You can check the Jira audit logs to identify these details form Jira UI.