Export a list with all agent versions

[Infr]

Hello community,

I am looking for a way to export a list with all hosts and the agent version they have running. I found out there is no option to do that from the dashboard.
So I tried to do a SQP dump as described here: https://mypoorbraindump.wordpress.co...oss-all-hosts/

I am quite new to Zabbix and not an expert when it's about SQL but with that command I won't get an output.

Thanks in advance.

[kloczek]

My zabbix agent template https://github.com/kloczek/zabbix-te...Zabbix%20Agent
Samples agent version and maps that values to "Software Application A" in inventory. So when that template is used (is used by all "OS" templates) to see aggregated list of hosts with with agents versions all what you need to do i go to Inventory -> Overview -> Software Application A.
If you want you can put exactly that output of the inventory as part of you dashboard.

[Infr]

Thanks for your reply.

I know how I get these informations inside Zabbix. But my issue is that I need it to export into a file (csv or xlsx).

[kloczek]

Thanks for your reply.

I know how I get these informations inside Zabbix. But my issue is that I need it to export into a file (csv or xlsx).

There is no in zabbix API interface special routines to retrieve inventory entries. All is handled by host.get.
You need two times call host.get zabbix API call.
One time to list of host in exact group and second one to list host inventory data.

https://www.zabbix.com/documentation/current/manual/api/reference/host/get#searching_by_host_inventory_data

Than you need to put those data in required output format.

[Infr]

Thanks a lot kloczek! You have been a big help. That's all I need to know.