Export host list

[Buozinis]

Hello,
I've seen zabcon is one of the tools. I have tried to use it, but no luck. First faced issue with dependencies, then some other problems in a code. Might be because it is an old tool and don't work with modern systems.
Is there is a way to pull host list from zabbix? It can be mysql queries, again found old solutions which I believe do not apply anymore for modern zabbix.

[vijayk]

You can retrieve it via Zabbix API. I'm not expert in API but i'm using Power Bi to get hosts from Zabbix Server.

https://www.spikefishsolutions.com/post/connecting-power-bi-desktop-to-zabbix

[vijayk]

You can retrieve it via Zabbix API. I'm not expert in API but i'm using Power Bi to get hosts from Zabbix Server.

https://www.spikefishsolutions.com/post/connecting-power-bi-desktop-to-zabbix

[Buozinis]

Hello vijayk. Thank you for your response. It is a really nice blog post how to do it, but sorry to be a douchebag, I believe Power-Bi tool is a paid service. Does anyone knows free alternative to Power-Bi tool?

[Brambo]

I use the API myself for backup of template, and as hosts are basically templates with an interface the method is probably the same.
Make an API token with rights to the correct host groups etc. Make a POST to the API URL with the correct JSON body. I expect something like: '{"jsonrpc": "2.0","method": "host.get","params": {"output": "extend"},"id":1}'
In the returned data there are host-id's which you can than use (if needed) to do another call for more details about this specific host.
Building / making something yourself vs cost using PowerBI is something you should consider for yourself.

[Buozinis]

Brambo thank you for your inputs. I tried another Json/API and it worked. Will keep reading API documentation on zabbix manual.

[Buozinis]

One last request. Is it possible to output data to a file? Because now spams terminal

[Brambo]

When you make the request, then you are in control to output it somewhere.
Like I mentioned that I just it for templates, the way I do that is grab every individual template from a certain group. But before that I store the templates locally, I create a new Git Branch with the current date, use the template description to create a readme.md and commit everything.
But I do everything with a powershell script and not with an item from within zabbix.

[Buozinis]

Hello, my colleague helped to find a solution.
Example:

curl -k --request POST \
--url 'https://example.com/zabbix/api_jsonrpc.php' \
--header 'Authorization: Bearer 198fac438d2c66232b1384f850a70aed583552be202c8b90aa 3dc56d7719975c' \
--header 'Content-Type: application/json-rpc' \
--data @data.json >> hosts.json

Then I get everything exported to hosts.json and then with python + pandas module I export data to csv file.

[dharam]

Hi,
I have the same requirement , can you help me to achieve this.

[Buozinis]

Hello dharam,
I will try to make steps to achieve this.

1. Create an API token and don't forget to save the token ID as you will need it later
   
2. On your server log in and make a file data.json e.g. nano data.json and copy the bellow contents
   

   {
   	"jsonrpc": "2.0",
   	"method": "host.get",
   	"params": {
   	"output": "extend"},
   	"id":1
   	}

3. make a curl request:
   

   curl -k --request POST \
   	--url 'https://10.143.1.153/zabbix/api_jsonrpc.php' \
   	--header 'Authorization: Bearer 01d32e8b2f5089591b3dd091998b7060770ed5844466ae9ae4084c951233be18' \
   	--header 'Content-Type: application/json-rpc' \
   	--data @data.json >> hosts.json​

   Authorization: Bearer - you need to put your TOKEN API id
   --data @data.json >> hosts.json - from data.json file which you have made on step 2 it will put all output to a file hosts.json
4. And then with python and pandas I convert hotst.json to csv - link for tutorial https://learnpython.com/blog/python-json-to-csv/

[dharam]

Thank you for nice explanation!!!