We have a report that shows the APM Devices that are currently unmanaged; unfortunately, because these values are in UTC time it is a pain to go through and perform the calculations to figure out what the actual times are. When dealing with instances of Solarwinds that are in different time zones, this can become extra tedious.
Our current Report is running the following query:
SELECT ID, Name, NodeID, UnmanageFrom, UnmanageUntil, UnManaged
FROM APM_Application
where Unmanaged = 1 or unmanagefrom >= getdate()
ORDER BY 1 ASC, 2 DESC
I've tried to modify the UnmanageFrom and UnmanageUntil fields using the TODATETIMEOFFSET function,but this is just returning blank data.
Any ideas on how to get this report to show Local times instead of UTC times?