Hi
Im using Grafana v6.7.3 (a04ef6cefc)
sending data from my vcenter with 60 Hosts and multiple datastores using telegraf plugin
I implemented Jorge’s dashboards, however I need to change it for my needs.
the datastore usage capacity shows all datastores. I want to display only those with 90% and above capacity in descending order.
how do I accomplish this please?
this is the original query:
SELECT last(“used_latest”) * (100 / last(“capacity_latest”)) FROM “vsphere_datastore_disk”
WHERE
(“source” =~ /^datastore/) AND timeFilter GROUP BY time(__interval) , “source” fill(none)