UTC or Localtime! How should data be stored in Orion?

UTC or Localtime! How should data be stored in Orion?

 

I have run into this issue on just about every monitoring system known to man. How is datetime for polled data stored in the database?

I think that when data is stored in the database, the datetime should always be stored in UTC. If there is a need to store the timezone for the poller, then store that in the Engines table.

 

When displaying the statistics on the Web UI, there could be a simple timezone displayed somewhere at the top of every page of how the user wants to see the data.

Then if a different timezone is needed, just select the timezone at the top of a page and a picker would popup to select an appropriate for displaying the data.

 

This setting could be based on a Users timezone setting. The timezone setting is really for displaying purposes anyway.

 

I know this is more of a feature request, but I wanted to get a Poll of people for how you may think it should be done.

 

Here are some options:

Timezone Field for Poller (Engines or EngineProperties Table)

User Settings Timezone Field

Timezone setting for Node

Primary Orion instance Timezone setting

 

For other thoughts, please leave a comment.

 

What do you think meech, wluther ?

Poll Results
  • Store Data in Poller Localtime (23%)
    43/185
  • Store Data in UTC with TimeZone setting (44%)
    82/185
  • Store Data in Primary Orion Instance Localtime (13%)
    24/185
  • Store everything as UTC, across the board (19%)
    36/185

Comments

Archive Poll

Confirm archive of UTC or Localtime! How should data be stored in Orion?

Archiving expires a poll and removes it from the active polls list.

To restore an archived poll, edit the poll, change the dates as desired, and save the poll.

Delete Poll

Confirm delete of UTC or Localtime! How should data be stored in Orion?

Warning: This will delete the poll and all of its comments.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.