Suppose I have 1000 projects in my jira instance. How can I find the list of all projects that are not active (any updation) from last one year?
Please suggest solution if we can use REST API for this?
Thanks in advance!
You can run below SQL on your Jira database. It'll give you list of projects which are not updated after a specific date and time. You might have to tweak the date and time part in the 'where' clause. I ran it on PostgreSQL.
pname,pkey,created as project_createtd,updated as project_updatetd
where updated <= '2019-10-01T02:15:00.102738Z'
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