Custom table report shows UTC timestamp

We have reports that are utilizing NPM Interface Traffic data and it is showing in UTC and not EST. This has been observed with the other tables like AlertHistory, Events, and AuditEvents. Though the charts are showing EST, the table report is in UTC. We were informed that some of the tables will be following the SolarWinds database timezone which is in UTC. It will be a big help to have all tables follow the timezone of the SolarWinds Server instead of the SolarWinds Database table.

Find more posts tagged with

table reports

timestamp

utc

Database

Status: None

Comments

mjlee1979

I've had the same with my custom dashboard, I've found using the following in my query converts the time to GMT

CAST(dateadd(hour,DATEdiff(hour,[SolarWindsOrion].[dbo].[AlertActive].[TriggeredDateTime] AT TIME ZONE 'GMT Standard Time',[SolarWindsOrion].[dbo].[AlertActive].[TriggeredDateTime] ),[SolarWindsOrion].[dbo].[AlertActive].[TriggeredDateTime] ) as datetime) as 'Triggered'

If you run the following you'll get all timezones so for yourself it would be 'Eastern Standard Time' instead of 'GMT Standard Time' I assume

SELECT * FROM sys.time_zone_info

tobyw_loop1

Upvoted