Service Operations Insight

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.

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

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

Generated report:

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. 

Thank you, that's exactly what I needed.