0 Replies Latest reply on Nov 15, 2016 4:03 AM by shaun_9999

    Advice for an SQL noob please.

    shaun_9999

      Good morning/afternoon/evening.

       

      I am trying to make an SQL report that only displays points over the working hours (from 08:00 - 18:00 as an example)  I have found the SQL part ( here - https://thwack.solarwinds.com/thread/34466#111767) I can get some of the data that I need, but not all of it.  It is only showing five weeks of data.

       

      Is it because my query is rubbish? I have done it all wrong?  With the criteria that I have set is that the results that it only produces?  Finally, can I get it shown as a chart?  Or is there only one view?

       

      Any assistance would be appreciated.


      Regards