Troubleshoot reports
By default, SolarWinds Platform (self-hosted) does not account for daylight savings times in various time zones. As a result, timestamps out of the specified time intervals might appear on reports.
Change how the date is calculated
-
Go to Advanced settings and search for "AdvancedDateTimeCalculationOption" on the Global tab.
To access advanced settings, append the following to the hostname/IP address of your SolarWinds Platform Web Console in the browser: /Orion/Admin/AdvancedConfiguration/Global.aspx
-
In the AdvancedDateTimeCalculationOption drop-down, select MainDateTimeColumn and save your settings.
Changing the value to AllColumns might significantly affect the performance of your reports.
The times on your reports are correct now.
Adjust a different time zone for the database server
When the SQL server time zone is different from your SolarWinds Platform (self-hosted) time zone, you might need to set the time zone.
SolarWinds recommends that you only use these setting only if you cannot address time issues on the database server.
-
Go to Advanced settings and search for "SQLServerTimezone" on the Global tab.
To access advanced settings, append the following to the hostname/IP address of your SolarWinds Platform Web Console in the browser: /Orion/Admin/AdvancedConfiguration/Global.aspx
-
Type your SQL Server timezone into the SQLServerTimezone field and save the settings.
The specified time zone will be used in reports.
Supported time zones for reports - Afghanistan Standard Time
- Alaskan Standard Time
- Aleutian Standard Time
- Altai Standard Time
- Arab Standard Time
- Arabian Standard Time
- Arabic Standard Time
- Argentina Standard Time
- Astrakhan Standard Time
- Atlantic Standard Time
- AUS Central Standard Time
- Aus Central W. Standard Time
- AUS Eastern Standard Time
- Azerbaijan Standard Time
- Azores Standard Time
- Bahia Standard Time
- Bangladesh Standard Time
- Belarus Standard Time
- Bougainville Standard Time
- Canada Central Standard Time
- Cape Verde Standard Time
- Caucasus Standard Time
- Cen. Australia Standard Time
- Central America Standard Time
- Central Asia Standard Time
- Central Brazilian Standard Time
- Central Europe Standard Time
- Central European Standard Time
- Central Pacific Standard Time
- Central Standard Time
- Central Standard Time (Mexico)
- Chatham Islands Standard Time
- China Standard Time
- Cuba Standard Time
- Dateline Standard Time
- E. Africa Standard Time
- E. Australia Standard Time
- E. Europe Standard Time
- E. South America Standard Time
- Easter Island Standard Time
- Eastern Standard Time
- Eastern Standard Time (Mexico)
- Egypt Standard Time
- Ekaterinburg Standard Time
- Fiji Standard Time
- FLE Standard Time
- Georgian Standard Time
- GMT Standard Time
- Greenland Standard Time
- Greenwich Standard Time
- GTB Standard Time
- Haiti Standard Time
- Hawaiian Standard Time
- India Standard Time
- Iran Standard Time
- Israel Standard Time
- Jordan Standard Time
- Kaliningrad Standard Time
- Kamchatka Standard Time
- Korea Standard Time
- Libya Standard Time
- Line Islands Standard Time
- Lord Howe Standard Time
- Magadan Standard Time
- Magallanes Standard Time
- Marquesas Standard Time
- Mauritius Standard Time
- Mid-Atlantic Standard Time
- Middle East Standard Time
- Montevideo Standard Time
- Morocco Standard Time
- Mountain Standard Time
- Mountain Standard Time (Mexico)
- Myanmar Standard Time
- N. Central Asia Standard Time
- Namibia Standard Time
- Nepal Standard Time
- New Zealand Standard Time
- Newfoundland Standard Time
- Norfolk Standard Time
- North Asia East Standard Time
- North Asia Standard Time
- North Korea Standard Time
- Omsk Standard Time
- Pacific SA Standard Time
- Pacific Standard Time
- Pacific Standard Time (Mexico)
- Pakistan Standard Time
- Paraguay Standard Time
- Qyzylorda Standard Time
- Romance Standard Time
- Russia Time Zone 10
- Russia Time Zone 11
- Russia Time Zone 3
- Russian Standard Time
- SA Eastern Standard Time
- SA Pacific Standard Time
- SA Western Standard Time
- Saint Pierre Standard Time
- Sakhalin Standard Time
- Samoa Standard Time
- Sao Tome Standard Time
- Saratov Standard Time
- SE Asia Standard Time
- Singapore Standard Time
- South Africa Standard Time
- South Sudan Standard Time
- Sri Lanka Standard Time
- Sudan Standard Time
- Syria Standard Time
- Taipei Standard Time
- Tasmania Standard Time
- Tocantins Standard Time
- Tokyo Standard Time
- Tomsk Standard Time
- Tonga Standard Time
- Transbaikal Standard Time
- Turkey Standard Time
- Turks And Caicos Standard Time
- Ulaanbaatar Standard Time
- US Eastern Standard Time
- US Mountain Standard Time
- UTC
- UTC+12
- UTC+13
- UTC-02
- UTC-08
- UTC-09
- UTC-11
- Venezuela Standard Time
- Vladivostok Standard Time
- Volgograd Standard Time
- W. Australia Standard Time
- W. Central Africa Standard Time
- W. Europe Standard Time
- W. Mongolia Standard Time
- West Asia Standard Time
- West Bank Standard Time
- West Pacific Standard Time
- Yakutsk Standard Time
- Yukon Standard Time