Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

MYSQL query to find the project creation date

Raju PSR December 27, 2021

How to find the project creation date for JIRA server with MYSQL Data Base

 

MY SQL Version - 3.7.35

JIRA Server - 8.13.10

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 27, 2021

You shouldn't be looking at the database, it is not designed for reporting, and reading it is the worst possible way to report on anything on Jira.

There is no SQL to find the project creation date.  Jira does not store it, so there's nothing to look for.

The audit log (which you can read over REST or in the UI) does record project creation with a date stamp, but records in there are only retained for a short time.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian community, loom ai, atlassian loom ai, loom, atlassian ai, record recaps of meetings, meeting recaps, loom recaps, share meeting recaps,

Loom’s guide to great meetings 📹

Join us to learn how your team can stay fully engaged in meetings without worrying about writing everything down. Dive into Loom's newest feature, Loom AI for meetings, which automatically takes notes and tracks action items.

Register today!
AUG Leaders

Atlassian Community Events