SQL Server BDC Hints and Tips: Changing Grafana/Kibana Display Time

SQL Server BDC Hints and Tips:​​ Changing Grafana/Kibana​​ Display Time Zone

 

 

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​​ 

  • Click on the Dashboard Settings (gear​​ icon, top right)

  • Change​​ the​​ time​​ zone option

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

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

Kibana:​​ https://10.193.23.37:30777/kibana

  • Click on the Settings (gear​​ icon,​​ left)

 

  • Select Advanced Setting and Scroll to the​​ time​​ zone for data formatting

 

 

  • Press the ‘SAVE’ Button

 

 

  • Bob Dorr