DX Operational Intelligence

Expand all | Collapse all

Hi, Are there any specific settings in SOI for timezone?

Jump to Best Answer
  • 1.  Hi, Are there any specific settings in SOI for timezone?

    Posted 10-19-2017 10:16 AM

    I have a difference in the alarm time displayed in the reports extracted from the SQL Server database with the alarm time displayed in the "Cleared Alert History" tab in SOI Console.

     

    Query in SQL ServerImage of the SOI console



  • 2.  Re: Hi, Are there any specific settings in SOI for timezone?
    Best Answer

    Posted 10-19-2017 01:10 PM

    In the database the data is written with GMT+0 and in the SOI console it picks up what is set in the OS for presentation.

     

    If you want to change you can access the Console and go to: View > Preferences

    Set Preferences

     

    If want to generate reports in JasperReports® with a specific timezone you can select it when you generate the report:

     

     

    Generated report:



  • 3.  Re: Hi, Are there any specific settings in SOI for timezone?

    Posted 10-20-2017 02:59 AM

    As Alessandro said above, data is written to the DB in GMT+0. For you SQL select statement, you want to have something like this included in your query for dates.

    dateadd(hour, @gmt,dbo.alerts.LoggedTime) as 'Created Date'

    You want to set @gmt to your timezone. In my case it's 2. 



  • 4.  Re: Hi, Are there any specific settings in SOI for timezone?

    Posted 10-20-2017 12:10 PM

    Thank you, that's exactly what I needed.