Oracle script for Project information

[Markeese Martin]

I'm currently trying to retrieve project information from the database of Jira Data Center. The data I am after is.

• project name
• project key
• project lead
• if that lead's account is active or inactive
• last issue update date
• last issue create date
• total number of issues
• date project was created

There are MySQL and POSTGRESQL scripts out there however I need something compatible with Oracle.

[Brant Schroeder]

@Markeese Martin If you have a MySQL or PostgresSQL script you should be able to make some small tweaks to it and it will work on Oracle.  The table structure is the same in all DBs.