It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Which database table is JIRA Service Desk license key stored?

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

1 answer

1 accepted

0 votes
Answer accepted

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
Community showcase
Posted in Jira Service Desk

How has Jira Service Desk increased productivity in your org?

Hi Jira Service Desk community, Atlassian is on a mission to unleash the potential of all teams, and we know that tools are just one piece of that puzzle. With Jira Service Desk, we have productiv...

242 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you