Kristin from SolarWinds sent me this via e-mail. I tested it in Database Manager and it seems to work. When I get some time I am going to try and apply this to my actual issues and let you know how it goes.
You can do a simple SQL conversion to move it to the local time:
DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), [TimeStamp]) AS [TimeStamp]
Just be aware that this will change it to the SQL Server’s Local time, not that of the client machine.