Changing the time zone of the Report Engine manually

When you install BMC ProactiveNet Report Engine, you specify a time zone. If you want to generate reports for a different time zone, you can change the time zone manually.

Make sure that the system time for BMC ProactiveNet Performance Management server and for the Report Engine are set correctly according to their respective time zones.

To change the time zone manually

1. Copy the rpt-manual-timezone-setting.sql file from the BMC ProactiveNet Report Engine installation directory (Reports/Util/DatabaseScripts) to the computer where you have installed Oracle client.
2. Using the Oracle client, log on to the Oracle database using the user name that was created with appropriate rights. For details about the user name, see the Creating a database user with appropriate rights.
3. Run the following command:
   SELECT TIMEZONE_REGION FROM RPT_TIMEZONE_INFO;
    A list of different time zones is displayed.

4. Note down the format of the time zone to which you want to update BMC ProactiveNet Report Engine.

   Example

   (GMT+02:00) Jerusalem

5. Run the following command:
   @<fullPathOfrpt-manual-timezone-setting.sqlFile>

   Example

   @C:\rpt-manual-timezone-setting.sql
6. Enter the time zone as you have noted in the step 3 and press Enter.

BMC ProactiveNet Report Engine is updated to the new time zone.

Recommendations to configure time zone

• The time zone of the operating system on which BMC ProactiveNet Report Engine is installed and the time zone selected on the installation wizard of BMC ProactiveNet Report Engine must be same.
• The computers on which you have installed SAP BusinessObjects and BMC ProactiveNet Report Engine must have the same time zone settings. The time zone settings of BMC ProactiveNet Server do not have any impact on the reports. Also, all the components of BMC ProactiveNet Performance Management Reporting must point to the same time. For example, if the time in the BMC ProactiveNet Server is 2:28:29 A.M. Central Daylight Time, the other computers must have equivalent time in their respective time zones such as 9:28:29 A.M. Central European Summer Time.