Report Writer and UnDP

dschultz

Hi:

I had created a couple of Reports based on SQL queries in Orion v8.x Report Writer and one field retrieved as part of the query was the DATE/TIME field from the CustomPollerStatus table.  Now since upgrading to Orion v9 these date/time values seem to be in GMT.  Is there a Format String that I can use in Report Writer's Field Formating tab to cause the time to be converted back to local time, or do I need to do some additional math within my SQL query first to convert it back to local time?  Please suggest a solution either way.

Thanks.

Dale

FormerMember

 I couldn't find a way to get it to happen via a Field Formatting option(there are all kinds of options for specific formats, but nothing I could find to handle adding or subtracting hours).

However, in your SQL query, there appears to be a way that will work:

If you old query was:

Select LastBoot from Nodes;

Your new query should be:

Select DATEADD(hh, 5, LastBoot) from Nodes;

Where 5 would be your offset from GMT. A -5 would work just as well.

 

Let me know if that works for you.