List of active plugins and expiration date

[Jean-Christophe Rase]

Hi,

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.

Regards,

2.13.0.0

[Daniel Ebers · Accepted solution]

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:
https://ecosystem.atlassian.net/wiki/spaces/UPM/pages/6094960/UPM+REST+API

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

Regards,
Daniel

[rweijers]

Hi Jean-Christophe,

I see this version number 2.13.0.0 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?

[rweijers]

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

[rweijers]

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 :)

2.13.0.0

[rweijers]

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

Hilarious.

2.13.0.0

[Nic Brough -Adaptavist-]

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)