How to find out the list of users whose display language is not in English

[Uttam Sai]

Hi Team,

I am trying to find out list of users whose current session's language is not in English.
This field is what user's select from Preferences --> Display --> Language , which is different from preferred_language field in sys_user Table .

Could you please help me to get the list using any script or without script

[Dr Atul G- LNG]

Hi @Uttam Sai 

Try to create Database view of both tables and there you will get both language's to compare.

sys_user_table & preference table.

[Uttam Sai]

Hi @Dr Atul G- LNG ,

My requirement is not to compare but to get the list of users whose session Language is not in English .

I just want to know the user names whose Instance is not in English as shown below. Could you please help me 

[Dr Atul G- LNG · Accepted solution]

Hi @Uttam Sai 

Try to get a report on user_prefernce table and filter with language.

[ersureshbe]

Hi, Use sys_user table and refer to the language field. Create a report based on your requirements.