You are here

Add Time Zone to Reports

4 posts / 0 new
Last post
adam.stanforth
adam.stanforth's picture
Add Time Zone to Reports

Hi

I am using the standard Monthly Availability and Monthly Service Level Reports but need an Australian time zone the be available for one report when scheduled.

Currently there are 4 US and 3 Euro time zones available in the drop down selection list. How do I configure so that Australia/Sydney is available?

If I run this query in mysql

mysql> SELECT CONVERT_TZ(NOW(), @@session.time_zone, 'Australia/Sydney') AS time_in_OZ FROM dual;

It returns correctly

+---------------------+

| time_in_OZ          |

+---------------------+

| 2016-09-12 21:49:22 |

+---------------------+

1 row in set (0.00 sec)

 

Regards

Adam

 

Duncan Ferguson
dferguson's picture
Which version of Opsview are

Which version of Opsview are you running?  Recent version should request the timezone for the report when you run it.

Can you confirm you have followed all the recommended steps on https://knowledge.opsview.com/articles/opsview-monitor-510/33132-databas...?

  Duncs

adam.stanforth
adam.stanforth's picture
Firstly, thanks for your help

Firstly, thanks for your help. We have only just started using the reports module so not yet up to speed.

Latest version 5.1.0.162300841

nagios@opsview:/usr/share/zoneinfo$ ls
Africa      Australia  Cuba     Etc      GMT0       Iceland      Japan              Mexico   Pacific     PST8PDT    Turkey     W-SU
America     Brazil     EET      Europe   GMT-0      Indian       Kwajalein          MST      Poland      right      UCT        zone.tab
Antarctica  Canada     Egypt    Factory  GMT+0      Iran         leap-seconds.list  MST7MDT  Portugal    ROC        Universal  Zulu
Arctic      CET        Eire     GB       Greenwich  iso3166.tab  Libya              Navajo   posix       ROK        US
Asia        Chile      EST      GB-Eire  Hongkong   Israel       localtime          NZ       posixrules  Singapore  UTC
Atlantic    CST6CDT    EST5EDT  GMT      HST        Jamaica      MET                NZ-CHAT  PRC         SystemV    WET

nagios@opsview:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

Running
select Name from mysql.time_zone_name;
returns 1808 rows

select Name from mysql.time_zone_name where Name like '%Austr%';

returns 69 rows

Regards

Adam

adam.stanforth
adam.stanforth's picture
Thanks for your help and the

Thanks for your help and the shove in the right direction, all seems to be working now.

Regards

Adam