Greetings, folks.
We are having a bit of a trouble creating a report in SolarWinds. The application template that collects the data for the report runs every hour, but it's scripted to only collect data once a day. It scans for a specific file once per hour. If that file is found, data is extracted and a flag is set not to extract data again until the next day. The data is being collected, and we can see it if we go to the app template (see image below - data points are clearly visible). However, when we try to create a table format report, it only displays the latest data point, no historical data. Could someone help us out with SQL to extract that data? It's a statistic per node kind of setup.
Thank you 