Documentation forSolarWinds Platform Self-Hosted

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

  1. 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

  2. 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.

  1. 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

  2. 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