So maybe I’m barking up the wrong tree here, but I thought I’d reach out and see if someone has a solution.
I’ve seen it done via InfluxDB, but i’m using the Zabbix datasource along with some SQL templates/scripts, to collect data from each of our SQL servers.
I want to create a farm overview board, showing, amongst other things, a simple health indicator.
Based on the standard SQL status codes, which rage from 0-42, I want it to say ‘Healthy’, ‘Degraded’ or ‘Critical’.
I can present this data in a table (image attached), but I can’t for the life of me work out how to get it into a single/blendstat-type widget.
Is it even possible, or do I need to sanitise the data further, prior to it hitting Grafana?
My idea with this board, is that when a new SQL server is added to the Zabbix group (and polled), it will automatically add the overview data to Grafana.
My Host, Application and Item queries are;
/./
/SQL MSSQLSERVER Database./
/SQL Instance MSSQLSERVER Database .*: Status/
Thanks a bunch!