There's a shared set of modern dashboard for "site summary" with a number of sub-pages and widgets here on this site.
The "Last Ten Events" widget shows the last ten events.... accurately. Too accurately. The times are displayed in GMT. I want them to be USA Central Standard time. The custom SWQL for this widget is as follows.... can I get some help modify this output to display CST/CDT times instead of GMT?
SWQL:
SELECT TOP 10 E.EventTime as [Event Time], E.EventTypeProperties.Name as [Event Type], E.Message as [Event Message] , N.Caption as [Node Name], N.Status as NodeStatus, N.DetailsURL as NodeUrl , case when E.EventTypeProperties.Icon='Add' then 5 when E.EventTypeProperties.Icon='Critical' then 14 when E.EventTypeProperties.Icon='Disabled' then 27 when E.EventTypeProperties.Icon='Error' then 2 when E.EventTypeProperties.Icon='External' then 11 when E.EventTypeProperties.Icon='Green' then 1 when E.EventTypeProperties.Icon='Info' then 5 when E.EventTypeProperties.Icon='NotRunning' then 30 when E.EventTypeProperties.Icon='Red' then 2 when E.EventTypeProperties.Icon='RedAlert' then 14 when E.EventTypeProperties.Icon='RedYield' then 14 when E.EventTypeProperties.Icon='Shutdown' then 4 when E.EventTypeProperties.Icon='Start' then 5 when E.EventTypeProperties.Icon='Testing' then 5 when E.EventTypeProperties.Icon='Unknown' then 0 when E.EventTypeProperties.Icon='Unmanage' then 9 when E.EventTypeProperties.Icon='Unmanaged' then 9 when E.EventTypeProperties.Icon='Unplugged' then 10 when E.EventTypeProperties.Icon='Unreachable' then 12 when E.EventTypeProperties.Icon='Warn' then 3 else 0 end as EventStatus FROM Orion.Events E LEFT JOIN Orion.Nodes N ON N.NodeID = E.NetworkNode ORDER By E.EventTime desc
Edit
