Export function for inventory

[Tux]

Hi,

for a larger system enviroment it would be cool, to have an option for export the inventory as csv or xls. also a great benefit would be, to let the customer/user choose the fields to export.

[BDiE8VNy]

That could easily be done via the API or by querying the database directly.
Anyhow, maybe you want to file a ZBXNEXT request.

[Pavels]

I wouldn't recommend querying the database directly. Using the API is a better approach. You can retrieve host inventory data using the host.get method

https://www.zabbix.com/documentation/2.0/manual/appendix/api/host/get

Check out this blog post for a quick introduction to the zabbix API

http://blog.zabbix.com/getting-started-with-zabbix-api/1381/

[sles]

Hello!

We have the same task- to export inventory data.
May be there is already working solution?
Thank you!

[rjj]

I've posted a patch (for ver. 2.2.3) that resolves this issue here

[angboontiong]

I've posted a patch (for ver. 2.2.3) that resolves this issue here

can you share how to integrate this?
i am new user btw...

[BDiE8VNy]

can you share how to integrate this?
i am new user btw...

For instance like this:

# cd /usr/share/zabbix
# patch < /path/to/export-inventories-to-csv.patch

[icarus]

Patch Failed

patching file hostinventories.php
Hunk #1 FAILED at 23.
Hunk #2 FAILED at 219.
2 out of 2 hunks FAILED -- saving rejects to file hostinventories.php.rej
can't find file to patch at input line 92
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/include/views/inventory.host.list.php b/include/views/inventory.host.list.php
|index af310fb..7b0f99c 100644
|--- a/include/views/inventory.host.list.php
|+++ b/include/views/inventory.host.list.php
--------------------------
File to patch: hostinventories.php
patching file hostinventories.php
Hunk #1 FAILED at 23.
1 out of 1 hunk FAILED -- saving rejects to file hostinventories.php.rej