UPM audit log store at which table?

HP May 6, 2015

Hi,

Anyone know which JIRA table is keeping Add-ons audit log? thanks!

4 answers

1 vote
Radek Janata November 8, 2019

Hi, you can find audit log here:

SELECT propertyvalue
FROM propertytext
WHERE ID = (
  SELECT ID
  FROM propertyentry
  WHERE PROPERTY_KEY = 'com.atlassian.upm.log.PluginSettingsAuditLogService:log:upm_audit_log_v3')

You can save the output, adjust its formatting a bit and import it as CSV into Excel for further filtering.

0 votes
HP May 10, 2015

Hi Timothy, Paulo,

Thanks for the reply. I can see the version & date updated for plugin in pluginversion table now.

Tried to look into the tables at propertyentry and propertystring, propertytext, I cant find the records about users who did the plugins update/changes. Can advise? Thanks!

0 votes
Paulo Hennig
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 7, 2015

The propertyentry  and pluginversion you may find most information you need, but you can see it also propertystring or propertytext as well. Just run a select query inside your DB to get the results, like above:

SELECT * FROM pluginversion
0 votes
Timothy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2015

The propertyentry and propertystring or propertytext tables.

Suggest an answer

Log in or Sign up to answer