Time Zones Settings for Reporting

Crystal Report uses the ODBC driver to access the HPE Service Manager database. When an operator creates or updates a record, the date information will be stored into the database using the coordinated universal time (UTC) scale. When an operator queries a record in the database, the ODBC driver will convert the UTC date to the operator’s time zone as defined in the login profile. Hence the converted date is displayed in the HPE Service Manager client’s UI.

In case the Service Manager server and the Service Manager client are running in different time zones with varied operator time zone configurations, you can refer to the following table for a record’s date information displayed in client’s UI.

Operator Time Zone 1Note the Operator refers to the operator account which is used to log in to the ODBC driver. The Operator Time Zone refers to the time zone setup in an operator’s login profile.	Server System Time Zone	Database Time Zone	Record Time Displayed
N/A	N/A	UTC	UTC
N/A	Defined	UTC	Server system time zone
Defined	N/A	UTC	Operator time zone
Defined	Defined	UTC	Operator time zone

From the table, it can be concluded that:

• If neither the operator time zone nor the server system time zone is defined (null value), date information will be stored in the database using the UTC scale. The date will be displayed as the UTC scale in client (including Eclipse RCP Client, Web tier Client and Crystal Reports).
• If the operator time zone is null and the server system time zone is defined, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the system time zone.
• If the operator time zone is defined and the server system time zone is null, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the operator time zone.
• If both the operator time zone and the server system time zone are defined, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the operator time zone.

Make sure the computer on which the Crystal Reports is running has the same time zone setup with the operator time zone, or has the same time zone setup with the sever time zone in case the operator time zone is null.

To configure the system time zone for HPE Service Manager:

1. Log on to Service Manager with a system administrator account.
2. From the System Navigator, click System Administraton > Base System Configuration > Miscellaneous > System Information Record.
3. Click Date Info to open the tab.

4. In the Time Zone field, select the new time zone for the server system.

   

5. Click Save.

To set the time zone for an individual operator:

1. Log in to the Service Manager system with a system administrator account.
2. From the System Navigator, click System Administration > Ongoing Maintenance > Operators.
3. Type the login name of the specified operator in the Login Name field.
4. Click Search. Detailed profile of the specified operator is displayed in the Operator Record page.
5. Click Login Profiles to open the tab.

6. In the Time Zone field, select the new time zone for the operator.

   

7. Click Save.