SQL Results Table Display

So LogicMonitor (LM) is a monitoring tool, so you need to think of your data from a monitoring perspective. Monitoring tools are designed to reach out to a resource, get the current value of something and save it. It will then do this over and over again every x minutes. For example if you are doing a ping check, the collector will ping the device every 1 minute or so, record the response time each time, then you can graph the data it collected over time. You would need to let LM do the data tracking over time.

So if you wanted to use SQL to track outstanding orders, you would modify your SQL statement to just return the current outstanding orders number. LM will run your SQL statement every x minutes and track the values. Then you can create a graph (and other) widget showing values over time.