grafana-zabbix
grafana-zabbix copied to clipboard
grafana
Show multiple attributes per host into a single row in a table
Describe the solution you'd like
Short answer -- something like described in https://github.com/grafana/grafana/pull/10050 -- but while this is ostensibly for the Table Panel, it seems to only work with InfluxDB and Prometheus sources.
Long answer -- say we have a Windows Host providing %-Used and MB-Free for multiple file systems, C:, D;, E:. One of our team wants to be able to show these numbers in a table such:
Drive / File System | %-Used | MB-Free C: | 27% | 345 D: | 72% | 123
Describe alternatives you've considered Multiple tables - but these take up lots of real estate, and the content (rows) aren't guaranteed to align (in some edge cases).
Just adding my two cents here, you can do a table in that manner by using Boom Table (https://grafana.com/grafana/plugins/yesoreyeram-boomtable-panel), you can even insert Font Awesome icons if you like
For example, this is a panel of mine. I arranged the data into columns even though they were rows belonging to other ítems:
I'm doing the same thing, but for now I got this: i don't know how to put in the same row, all the values Hostname | CPU | Memory
Just adding my two cents here, you can do a table in that manner by using Boom Table (https://grafana.com/grafana/plugins/yesoreyeram-boomtable-panel), you can even insert Font Awesome icons if you like
For example, this is a panel of mine. I arranged the data into columns even though they were rows belonging to other ítems:
@Vinikober in order to do that, you need to set the delimiter. In your case is ":"
Mine was "."
Be sure to define the right pattern that will match the rightmost portion of the item.
@Vinikober in order to do that, you need to set the delimiter. In your case is ":" Mine was "."
@egorky , @Vinikober Can you share a screenshot / example of how to configure zabbix metrics and patterns? I want to show the hostname, Used space%, Available space and total space in a single table.
Instead of extracting the data through the Zabbix/Grafana datasource plugin, and then trying to transforming data in the table panel, it may be easier to use a MySQL data source instead and connect directly to your Zabbix database. Do the transform in your SQL query.
See this basic example where I use a SQL inner join, a count aggregate and a column alias.
There is no need to use the Zabbix/Grafana plugin in this case where you want to see data from different tables in a single table. (unless there is absolutely no other choice)
I went straight to the Zabbix MySQL DB instead.
You probably already have the MySQL data source to your Zabbix database already setup if you used the 'Direct DB Connection' option in your Zabbix/Grafana datasource configuration
Created an issue for the new Transformation in Grafana https://github.com/grafana/grafana/issues/29393
Hello, I would like to present more than one value in the table using zabbix
I am also looking for similar feature. I tried using boom table but its very complex to do.
