Do we log when the UTC conversion finishes correctly and if so where?

Question

Do we log when the UTC conversion finishes correctly and if so where?

Answer

We do not currently log a start or end record for the UTC utility. However, starting in OnGuard 6.5, we will log start/cancel/finish records.

There isn’t a way to tell if the utc utility is done by just looking at the system – short of going through each table to see if there are NULL UTC times. However, there is no harm whatsoever of running this utility over again. There would be no reason to change any of the timezone settings at the beginning of the utility as they can simply be skipped. If there is nothing needed to be done and the UTC utility did successfully complete previously, then the utility will simply do nothing and finish (after searching each table for unconverted times).

This utility will also be run if a customer ever restored an archive and wanted to report on this data. The UTC utility would run (assuming this data was archived off prior to 6.3) and convert the times for them.

It is safe to run the utility again if you are unsure if the utility finished properly.

Applies To

OnGuard 2009 (6.3.249); OnGuard 2010 (6.4.500) 

Additional Information