Which database table is JIRA Service Desk license key stored?

Leann Adams July 27, 2016

Can you provide the SQL statement that would locate the JIRA Service Desk license?  Thanks

1 answer

1 accepted

0 votes
Answer accepted
105349
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 28, 2016

Hey Leann!

Since Service Desk is an add-on, this query should get you (at least mostly) there:

SELECT * FROM public.propertyentry pe JOIN public.propertytext pt on pe.id=pt.id
WHERE pe.property_key like 'com.atlassian.upm.license%';

And here's some light reading that may help as well!

Good luck!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events