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
Stephen Wright Community Leader Oct 03, 2019

Hi @Raj

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.

Ste

Hello @Stephen Wright ,

 

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.

Suggest an answer

Log in or Sign up to answer
TAGS

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