The Event Time for our Nodes Down is off by 5 hours. The time is correct on the Summary page, and on the device being monitored. Is there a setting I'm missing? Wondering if the Event Time is somehow pulling GMT instead of local time zone?
Where are you seeing the discrepancy? Dashboard, alert, else;?
On the dashboard events. However if we go to a node as well and look at the last boot time it is also off there. If I use the database manager though and query the database directly the last reboot time is correct. So it is really like a display issue on the web, I just can't find where to set the timezone.
Ya that's in UTC. You can convert it with "toLocal(LastBoot) as LASTBOOT:
Here is what I use in my dashboard (custom table/query):
SELECT N.NodeName, N.Vendor, toLocal(N.LastBoot) as LASTBOOT, N.DetailsUrl, N.VendorInfo.IconFROM Orion.Nodes NWHERE N.LastBoot is not nullORDER BY N.LastBoot DESC
Well is there a way to fix that across the site as a whole? Like when we are looking at a node, under Node Details it shows the last boot wrong there as well. However the database has the local time. So it is really like the whole site is adjusting the times.
After upgrading to 2023.1 I'm also seeing a massive discrepancy in Event Time and actual time of the event. I'm opening a support ticket
UPDATE: It's a bug; and no workaround till next update/releaseSolarWinds Support: “I was reviewing the logs and case, this is a bug, there were changes to the tables and the data store is in UTC. There is currently no workaround, but the fix will be in the next release. I will put the case on hold and update the case once the release is out.”
Thanks for opening the case and double thanks for posting an update!
Thank you for digging into this and updating! Guess we wait.
Thanks for the information. We also have the same issue. Not urgent but it would be nice to have fixed.
