How to retrieve all net new JIRA projects in the last 6 months using a script?

[Katie Kennedy]

Hi All,

I want to retrieve all the net new jira projects from the last 6 months. Any help would be much appreciated .

Thanks

[Payne · Accepted solution]

Hi Katie,

I don't have a solid answer, but some thoughts to get the ball rolling ... the date a project is created is not stored in the database. One way you can approximate it is to look at the creation date of the first issue in the project. Since you have ScriptRunner installed, you may could create a script to iterate over the list of projects, and for each pull up its first issue; if its creation date is within your time period of interest (e.g. the last 6 months), then report it. May be something you can run with.

-Payne

[Katie Kennedy]

Thanks, I've seen this answer suggested a few times, is there any script already out there for this workaround?