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
Maybe you managed to get this script for Oracle?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.