How to find User Properties in Jira database?

[Ivan Donigevich]

Despite there are two similar answers to the question:

https://answers.atlassian.com/questions/151905/what-database-table-keep-user-properties

https://answers.atlassian.com/questions/73332/does-user-property-value-store-in-database

I still cannot find how external_entities.name is linked to the propertyentry table.

There is several external_entities.name that have user properties. But their external_entities.id has no corresponding propertyentry.entity_id.

Jira version: 5.2.10

[Tiago Comasseto · Accepted solution]

Hi Ivan, with new versions of JIRA (6.x) you can use the following query:

select *
  from propertyentry pe,
    propertystring ps,
    app_user au
  where pe.ID = ps.ID
    and au.ID = pe.ENTITY_ID
    and PROPERTY_KEY like 'jira.meta.%'

With old versions you can use the following query:

select *
  from propertyentry pe,
    propertystring ps,
    external_entities ee
  where pe.ID = ps.ID
    and ee.ID = pe.ENTITY_ID
    and PROPERTY_KEY like 'jira.meta.%'

I hope it helps.

Cheers

[Ivan Donigevich]

Hi Tiago,

Thank you a lot for the advice, the script for Jira 6 works for me.

Now it's clear why the 2nd script mentioned in the above links didn't work - I confused my Jira version (it's 6.2)

BR,

Ivan