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
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

342 views 1 3
Join discussion

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