How to create a dashboard with hostnames and zabbix agent versions

[infraq]

Hello all,

I'm trying to learn more about dashboards, but currently going in circles.
For example, how do I create a dashboard that lists all hosts and the agent version per host.
(all hosts have a template that is retrieving the agent version information, so the data per host is in the database)

It seems like an easy task, but I'm not getting closer than using a honeycomb dashboard that shows 23 hosts while I have approx. 100 hosts
Using the latest data option in the menu is limited again to 23 hosts.

From what I've found searching the internet are options like querying the database directly, but the database structure seems to change every Zabbix version update, so that's not really maintainable.
Others are using python scripts via API calls, but surely that must be a way to get the information from Zabbix webgui itself with a few clicks?

Looking forward to the suggestions

[troffasky]

Grafana Zabbix integration may give you what you want.

[troffasky]

There are also some third-party widgets:

https://www.quadrata.it/spice-up-your-zabbix-dashboards-exploring-the-e-chart-widget-module/

[troffasky]

Although it is not clear how the only table widget in this plugin actually works. You can put in a pattern to see a table of items, but AFAICT it only works if it was discovered with LLD? The Select Items button does not offer a list of LLD prototypes, just items.