XrmToolBox设置用户默认时区

1
SELECT s.fullname AS UserName,
2
       s.businessunitidname AS BusinessUnit,
3
       s.domainname AS Domain,
4
       us.timezonecode AS TimeZoneCode,
5
       tz.standardname AS TimeZoneName
6
FROM   systemuser AS s
7
       INNER JOIN
8
       usersettings AS us
9
       ON s.systemuserid = us.systemuserid
10
       INNER JOIN
11
       timezonedefinition AS tz
12
       ON us.timezonecode = tz.timezonecode
13
WHERE  s.isdisabled = 0;