We are trying to use Grafana to develop a capacity dashboard for all of our monitoring systems. I am relatively new to SWQL and SQL. In trying to pull data from Orion, the tables are set up in such a way as to make continual graphing difficult. For example, percent utilization data seems to only be available in tables named by the day of the month, so we have to specify a table with a specific date. This seems difficult, since you would have to update Grafana daily with another query for the previous day.
Any help would be appreciated.
Thanks.
Steve