We noticed after we added a new custom SWQL query wigent for Audinting Events that the Time provided is in UTC and we would like it in EST.
Query:
SELECT TimeLoggedUtc, AccountID, AuditEventMessage
FROM Orion.AuditingEvents
WHERE NetObjectID = ${NodeID}
ORDER BY TimeLoggedUtc desc
Does anyone know of a way to convert UTC over to EST in SWQL or to modify the Query to use and display Local Time?
