1 Reply Latest reply on Mar 5, 2017 8:23 PM by Steven Klassen

    Need to get local Business hours reports

    patriot

      My SolarWinds polling engine is in the central time zone of the U.S., but I am monitoring devices all over the world. My challenge is that I need to run weekly reports covering LOCAL business hours (8AM to 6PM). In other words, a report for devices in Paris should include data from 8A to 6P in Paris, not 8A to 6P in Dallas.

       

      How do I do that in SQL? Can it be done directly with Manage Reports?

       

      Thank you for any guidance as I am not a SQL expert.

        • Re: Need to get local Business hours reports
          Steven Klassen

          Hey patriot - long time no chat!

           

          The way I handle this is by creating a floating point node custom property with the GMT offset for each node (e.g., -7 for PDT, -5 for CDT, and -4 for EDT). Then when I create the report, I limit the rows (in SWQL or SQL) to those where the hour is >= (dateTimeField + customPropertyUTCOffsetField) if the dateTimeField is UTC already (as it is with availability). Boom, you have a timezone aware report! If you want a hand with the particulars, give me a shout and we can hop on a GoToMeeting and chat about it.