Skip to main content
Interania

How to change dashboard timezone offsets

0votes
12updates
26views

Many areas adhere to daylight savings time, which requires a time zone change for an Interana cluster twice a year using the CLI. Interana also provides a script for updating the time zone display for Interana dashboards.

This feature is new in Release 2.25.

Changing dashboard timezone offsets

If you are in an area that adheres to daylight savings time, you need to change the timezone offsets on your Interana instance and dashboards twice a year. You set the timezone offset forward by an hour in the spring for daylight savings time, then back an hour in the fall to revert to standard time. 

This article demonstrates how use the utility that expedites changing timezone offsets in dashboard charts.

The dashboard_timezone_offsets.py utility should ONLY be run when no changes are being made to the ConfigDB, especially external_blob_storage and named_expressions.

 

Usage: dashboard_timezone_offsets.py [-h] {update,show}
Positional arguments:

update — Update the existing dashboard with the offset.

show — Show the current time zone offsets.

Optional arguments: -h, --help — Show the help for this command and then exit.

 

Timezone updates use Unix Epoch (milliseconds) time format.

To change dashboard timezone offsets, do the following:
  1. Log in to the config node of your Interana cluster.
  2. Display the current timezone offsets with the following command.
/opt/interana/backend/scripts/dashboard_timezone_offsets.py show
dashboard_id title tzo
------------------ ------------------------- ---------
dashboard-<userName>-0 column Types - Count Rows 284400000
dashboard-<userName>-0 column Types - Count Rows 284400000

The timezone offset in this example is 284400000 milliseconds. 

  1. Update the Interana instance as described in How to change the query time zone with the CLI.

The time zone offset for the Interana cluster is in minutes. However, the dashboard time zone offset is in milliseconds. For simplicity, the next step recommends running a query, and then using the millisecond value shown in the query URL for the dashboard time zone update value.

 

  1. Run a query and look in the query URL for “time_zone_offset”:<milliseconds>. You will use the <milliseconds> from the query URL as the timezone offset to which the dashboard will be updated.
  2. Run the dashboard_timezone_offests.py utility to update the timezone offset from step 2, to the <milliseconds> in the query URL (from step 4) as the new dashboard_time_zone_offset, as shown in the following example.
/opt/interana/backend/scripts/dashboard_timezone_offsets.py update 284400000 <milliseconds>
  1. Verify the time zone offset update in the Interana dashboard.
  • Was this article helpful?