Skip to content
Go back

D365 - Set User Default Time Zone

(1)Install and open User Settings Utility in XrmToolBox

Open User Settings Utility

(2)Load user information

Load User Information

(3)Select and check the users, choose the desired time zone, and finally click Update User Settings

Update User Settings


Additionally, you can also query the current time zone of users via SQL:

SELECT s.fullname AS UserName,
       s.businessunitidname AS BusinessUnit,
       s.domainname AS Domain,
       us.timezonecode AS TimeZoneCode,
       tz.standardname AS TimeZoneName
FROM   systemuser AS s
       INNER JOIN
       usersettings AS us
       ON s.systemuserid = us.systemuserid
       INNER JOIN
       timezonedefinition AS tz
       ON us.timezonecode = tz.timezonecode
WHERE  s.isdisabled = 0;

Query User Time Zone via SQL

SQL Field Description

#FieldDescription
1UserNameFull name of the user.
2BusinessUnitThe business unit to which the user belongs.
3DomainThe user’s domain account (e.g., contoso\johndoe).
4TimeZoneCodeThe numeric code that represents the time zone in Dynamics 365.
5TimeZoneNameThe standard name of the time zone (e.g., Pacific Standard Time).

The End

Copyright Notice

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Please attribute the source, use non-commercially, and maintain the same license.


Share this post on:

Next Post
D365 - XrmToolBox Loading Errors