UPM audit log store at which table?

Question

Hi,

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

Radek Janata · Answer

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.

HP · Answer

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!

Paulo Hennig · Answer

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