Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Get the created date and last update date of the projects Edited

Hello Team,

How to get the list projects with the project created date and when is the project issue last updated.

Database: Postgres


Thanks in Advance.

1 answer

0 votes

Hi @Raju Anumula

One option for project created is to use the Audit Log, assuming it's activated - to access:

  • Go to Jira Admin (cog in top-right corner) and press System
  • Under System Support, select Audit Log

You can view when one project was created using this - or export the data (button in upper-right) and review it for more than one project.

For when it last had an issue updated, I would just export all the issues for the selected projects from the issue search and locate when the last issue update was performed for each.

Alternatively you might be able to query the database your instance sits on for this data - depends on your setup.


Hello @Stephen Wright _Elabor8_ ,


we have 700+ projects in our Jira instance, difficult to get details from the audit log.


I am looking for a database query to get the project list and last update in project.

we are using Postgres.


Thanks in advance.



Did you get a query for that?

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you