How to find User's Language in Jira

[Piyal Nanayakkara]

Hi

We need to get the statistics of Language (visible in Profile ) used by Jira users.

What is the Database table and Field storing User's language?

Regards

Piyal

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Piyal Nanayakkara ,

please use the following query to retrieve info about language user preferences :

select u.user_key, PROPERTY_KEY, propertyvalue 
from propertyentry pe 
join app_user u on u.id = pe.entity_ID
join propertystring ps on ps.id = pe.id and property_Key = 'jira.user.locale';

Hope this helps,

Fabio

[Piyal Nanayakkara]

Thanks a lot. Really helpful

[Fabio Racobaldo _Herzum_]

you're welcome @Piyal Nanayakkara 

[Adam Harvey]

Worked like a charm, thank you.

[ACP]

Hi @Fabio Racobaldo _Herzum_ ,

do you know a query for the users from an external directory?

This query works fine but I only see users from the internal directory.

Thanks for your feedback

[Fabio Racobaldo _Herzum_]

Hi @Marco Birrer ,

this query should show just all user that modified their personal settings. It will show all users, internal or external, but with personal settings.

All other users, who are not in this list, use the default settings defined by JIRA Admin.

Ciao,

Fabio

[ACP]

Hi @Fabio Racobaldo _Herzum_ ,

ahh i see.

great. Thank you very much for your quick feedback.

Ciao,
Marco