BRONZE PARTNER:
BRONZE PARTNER:
Industry News:
| |
| |
|
|
|
|
|
| Web Report: Count of PCs by timezone |
|
|
|
By: Rod Trent
Posted On: 1/17/2007
This Web Report, by Garth Jones, will help you prepare for the time zone patch that needs to be deployed prior to March 2007.
Time zone info taken from http://www.timeanddate.com/library/abbreviations/timezones/
SELECT
case v_GS_COMPUTER_SYSTEM.CurrentTimeZone0
when '720' then 'New Zealand Standard Time'
when '690' then 'Norfolk (Island) Time'
when '660' then 'UTC +11'
when '600' then 'Australian Eastern Standard Time'
when '570' then 'Australian Central Standard Time'
when '540' then 'UTC +9'
when '480' then 'Australian Western Standard Time'
when '420' then 'Christmas Island Time'
when '390' then 'Myanmar Standard Time'
when '360' then 'UTC +6'
when '330' then 'Sri Lanka Standard Time'
when '300' then 'UTC +5'
when '240' then 'Caucasus Standard Time'
when '180' then 'Georgian Standard Time'
when '120' then 'Eastern European Time'
when '60' then 'Central European Time'
when '0' then 'UTC'
when '-60' then 'UTC -1'
when '-120' then 'UTC -2'
when '-180' then 'E. South America Standard Time'
when '-210' then 'Newfoundland Standard Time'
when '-240' then 'Atlantic Standard Time'
when '-300' then 'Eastern Standard Time'
when '-360' then 'Central Standard Time'
when '-420' then 'Mountain Standard Time'
when '-480' then 'Pacific Standard Time'
when '-540' then 'Alaska Standard Time'
when '-600' then 'Hawaii-Aleutian Standard Time'
when '-660' then 'Samoa Standard Time'
when '-720' then 'New Zealand Standard Time'
end as 'Time Zone',
count (v_GS_COMPUTER_SYSTEM.CurrentTimeZone0) as 'Total'
FROM
v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
Group By
v_GS_COMPUTER_SYSTEM.CurrentTimeZone0
Order By
v_GS_COMPUTER_SYSTEM.CurrentTimeZone0
_____________________________
Garth@enhansoft.com
For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/cs/blogs/garth_jones/default.aspx
http://myitforum.com/blog/gjones/
|
|
|
|
|
|
