Which database table is JIRA Service Desk license key stored?

[Leann Adams]

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

[105349 · Accepted solution]

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!