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!
...be more productive while being fun to use at the same time. For some, getting started can be a bit intimidating. This is especially true if Jira Service Desk is your first exposure to Atlassian...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs