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.