How to audit license usage in Jira (running on an Oracle Database)

[Karl Kreutzwiesner]

Dear Community,

i have the need to find out the usage of consumed licenses and found this Knowledge Base Instruction.

https://confluence.atlassian.com/jirakb/how-to-audit-license-usage-in-jira-1005789475.html

There is a script attached to find the last access time on some features. The script is written for Postgress DB. Has somebody already experience with adapting this script to run on an Oracle DB ? Would be very helpfull for me not doing the work twice.

What i found out, is that you can not work with "Limit 1" in a "Left Join" Expression in Oracle.

If you pick it and run it in SQL Developer you will get an error like:

00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
Erro in Line: 17 Column: 157

Any help welcome

thx and br Karl

[Piotr Michaeli]

Maybe you managed to get this script for Oracle?