Finding preferences display table

[hacktd]

Hi.

I want to find the table which stores all preferences data in this Display UI in User Preferences. And I notice the time zone field in this Display UI is different from time zone field set in sys_user table. Which time zone field does my instance will take to set value for the time zone fields ?

Main UI Preferences for each user:

My user's display options:

[Anand Kumar P]

Hi @hacktd ,

The primary control for users' time zone preferences is typically the sys_user.time_zone field in the sys_user table, while the sys_user_preference time_zone field may store user preferences but is generally not the primary field used to set the time zone for date and time display throughout the ServiceNow instance.

The one on the profile is stored in the user table (sys_user). The one in the settings is stored in the user prefererences (sys_user_preference) table. The user preference takes precedence.

If this solution is helpful, please consider marking it as "Solution Proposed."

Thanks,

Anand

[hacktd]

Hi @Anand Kumar P, thanks for the information about two time zone fields, what about table stores the preferences time zone field ? Currently in my instance's sys_user_preference table I don't see any record stores that time zone value

[Anand Kumar P]

Hi @hacktd ,

This is because the time zone setting on the user profile is stored in the sys_user table, while the time zone setting in the user preferences is stored in the sys_user_preference table. In the case of conflicting time zone settings, the time zone preference set in the sys_user_preference table takes precedence.

It's important to note that after setting the time zone for a user, the user needs to log out and then log back in for the changes to take effect and for the updated time zone preference to be applied to their session.
Thanks,

Anand