Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

MYSQL query to find the project creation date

Raju PSR
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

Answer
Watch
Like Be the first to like this
760 views

1 answer

0 votes
Nic Brough -Adaptavist-
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.
Get recognized
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.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events