Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

List of active plugins and expiration date


Is there any way/method using 'manual' commands to request directly into database (postgresql) information such as a list of all loaded plugins and their expiration date ?

Which tables could contain usefull information ?

I know those information are available throught the GUI but I would like to implement an automatic check with automatic reporting and notification.


3 answers

1 accepted

2 votes
Answer accepted
Daniel Ebers Community Leader Aug 22, 2021

Hi @Jean-Christophe Rase

adding to what Nic said we found documentation fot the API of UPM (which manages the Apps in the background) here:

Probably this helps to get a first insight in the Apps installed on your server in a programmatical way.


Hi Jean-Christophe,

I see this version number below your comment of this post.

I have that same issue when posting comments or updating descriptions in tickets in our Jira solution. (actually that same version number)

Were you able to get rid of those? And if yes, how?

@Jean-Christophe Rase  Can you have a look at my question :-) 

Like Jean-Christophe Rase likes this

Hi @Jean-Christophe Rase . Found it. Issue was not in Chrome or FF incognito. Only in current session. Deleted all cache/cookies etc. And issue is now gone :)

hahaha, it is fixed in our local Jira. I see this website still adds the

0 votes

Nope, it's not held in the database directly, the dates on the licences are encoded into, and extracted from, the licences.

it's best not to try to do any reporting from the Jira database, it's simply not designed for it, and almost every report you might need is faster, easier, more maintainable and more helpful if you go through the UI or use the REST API.  (Or get an app written to do it, but that just shifts the problem onto the app authors - still a very good option for us end-users)

Suggest an answer

Log in or Sign up to answer

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