search

grafana / grafana-zabbix

Zabbix plugin for Grafana dashboard
http://play.grafana-zabbix.org
Apache License 2.0
2.07k stars 458 forks source link

[Feature Request] Ability to get hostname associated with item #911

Open zeppmg opened 4 years ago

zeppmg commented 4 years ago

Is your feature request related to a problem? Please describe. I'm trying to template graphs over items discovered on different network devices. I'd like to display all these graphs on a single dashboard, using the Repeat function. I can achieve this by creating a variable corresponding to the item description I'm searching for, but when I repeat the panel, I can only use my variable value as label, and can't display the associated hostname with it, which makes the dashboard very confusing.

Describe the solution you'd like It would be great to have the option of retreiving the hostname to which an item is attached, in order to be able to display it on a dashboard.

Describe alternatives you've considered If I create a variable for the searched items, i can't retreive the hostname associated to each variable value. If I create a variable for the host + a variable for the item, I can only repeat a panel for one of these 2 variables, and when I want to display all the graphs on the same dashboard, it will display "All" or eventually the full list of hostnames on top of each graph, instead of just the right one.

alexanderzobnin commented 4 years ago

Hi! Could you show examples of how your variable queries look like? And how items mapped to the hosts - is it the same items across all hosts or one host may have a particular item and other - don't.

kins-dev commented 4 years ago

So with the direct database connection, I used:

SELECT
  hosts.host
  from
  hosts
  where
  hosts.name = "$host"

from the direct database connection in a panel so I could get the user defined "host name" for the specified item. It was very useful with a dashboard generator and provisioning so that my dashboards all have a place where I can see their name. That way if I use a playlist, it becomes simple to track which item I'm currently looking at.

This is distinctly different than the "Host name of Zabbix agent running" text as that information may or may not include the FQDN depending on a number of factors.

github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!