SQL Server BDC Hints and Tips: Changing Grafana/Kibana Display Time Zone
Published Feb 08 2022 06:51 AM 1,122 Views
Microsoft

 

Moved from: bobsql.com

 

The Grafana and Kibana interfaces default to the local browser time zone on a SQL Server BDC cluster.  Some of my machines are in the PST time zone and others the CST time zone and I find myself doing math calisthenics trying to line up metric and log information.

 

Currently the SQL Server BDC cluster does not allow you change the default from local browser time (being worked on by the team) but you can temporally adjust Grafana or Kibana.  Here I highlighted how to adjust the time zone for Grafana and Kibana.

 

Grafana: https://10.193.23.37:30777/Grafana

1.       Click on the Dashboard Settings (gear icon, top right)

BobDorr_1-1644331723130.png

2.       Change the time zone option

BobDorr_2-1644331733459.png

 If you press the ‘Save’ button the following error appears

BobDorr_3-1644331742965.png

 

3.       Instead use the ‘Go Back’ button which causes the current session to honor the selected time zone

BobDorr_4-1644331753462.png

 
Kibana: https://10.193.23.37:30777/kibana

1.       Click on the Settings (gear icon, left)

BobDorr_5-1644331762342.png

 

2.       Select Advanced Setting and Scroll to the time zone for data formatting

BobDorr_6-1644331773864.png

3.       Press the ‘SAVE’ Button

Co-Authors
Version history
Last update:
‎Feb 08 2022 06:51 AM
Updated by: