Exchange and Daylight Saving Time, Part 2
Adjusting calendar data for the new dates of daylight saving time will be tricky, but there are tools available to help you.
February 14, 2007
Last week, I wrote about the upcoming change to start and end dates for daylight saving time (DST) in the United States and Canada, including some effects this transition will have on Exchange Server administrators ("Exchange and Daylight Saving Time, Part 1," February 8, 2007). I focused primarily on how to update the OS and server applications you use; this week I'll focus on the client and mailbox changes you'll need to make.
Let's look at which clients are affected by the DST change:
Microsoft Outlook 2000 and Microsoft Office Outlook 2003 get their time zone information from the host Windows OS, but they can't automatically adjust existing calendar data for the change in DST dates.
Microsoft Office Outlook 2007 already understands the new DST dates, and it includes a tool that can rearrange existing appointments; however, the Time Zone Data Update Tool for Microsoft Office Outlook (described below) has some enhancements over Outlook 2007's built-in tool.
All versions of Windows Mobile need to be updated.
The latest update for Microsoft Entourage 2004 for Mac (11.3.4) doesn't have to be patched, but Mac OS X does. Earlier releases of Entourage, including Microsoft Entourage X, can't be patched to adjust for the new DST dates.
Exchange doesn't store a time zone with single appointments (i.e., ordinary, nonrecurring appointments). Instead, the appointment time is stored using Coordinated Universal Time (UTC), and the local time of the appointment is calculated using the time zone of the computer in which the appointment was created. Therefore, it's difficult to adjust the time of these appointments automatically during a time change.
There are two basic ways that you can update users' calendar data:
You can use the client-side Time Zone Data Update Tool to update meetings in Outlook itself. The Microsoft article "How to address the daylight saving time changes in 2007 by using the Time Zone Data Update Tool for Microsoft Office Outlook" describes how this tool works and what it does. Essentially, it scans for appointments that fall between the new and old DST dates (March 11–April 1 and October 28–November 4) and adjusts their start times according to a complicated set of rules.
You can use the Exchange Calendar Update Tool, a server-side wrapper around the Outlook tool. The big difference between these two tools is that the Exchange tool will silently update calendar items without giving users a chance to override the tool's behavior. The Exchange tool, and all its potential pitfalls, is described in the Microsoft article "How to address daylight saving time by using the Exchange Calendar Update Tool."
You can set both tools to modify either all appointments in the DST gap or only recurring appointments. No matter what you do, Microsoft recommends that you take precautionary measures such as printing out your weekly calendar for the gap period and updating your meeting location or subjects with the correct start time—all before you install any of the patches or run the time zone update tools.
The Exchange tool is single-threaded, so it will take the tool a long time to update large numbers of users. Microsoft has helpfully created a prepackaged virtual machine (VM) with the Exchange tool, which you can download from Microsoft's Web site. You can install several instances of the VM and process many appointments at the same time. In Microsoft's internal pilot of its DST update process, the company found that to update its 130,000 clients in a three-day period, it would need to run 10 instances of the VM, each averaging about 2.9 mailboxes per minute. You can read about Microsoft's pilot in "Exchange Time Zone Update Tool: Guidance from Microsoft IT." Because most of us have much smaller environments than Microsoft does, you can probably get by with fewer VM instances.
Of course, there's a third alternative for updating users' calendar data: Do nothing, and let your users clean up their calendars themselves. This is probably going to happen at many smaller organizations, but I don't expect it to be a popular choice given the disruption of work it could cause.
However, if you’re going to update your users’ data, it’s critical that you do two things: Update all your clients, including Windows Mobile devices, to ensure that an unpatched client doesn’t set appointment times back to their original, non-2007-DST values; and update the clients as soon as possible after updating the servers but before you adjust appointment times to reduce the risk that users will create appointments with a mix of patched and unpatched clients.
In addition to carefully reviewing Microsoft’s DST documentation, your best bet is to start alerting your users now to, as Microsoft puts it, "Consider any calendar items in the extended DST period to be suspect. If you are not sure, verify the correct time with the organizer." That's good advice—but don't be surprised if you find me an hour late (or early) for meetings!
About the Author
You May Also Like