[ZBXNEXT-1723] Add CSV export to graphs Created: 2013 Apr 24  Updated: 2024 Mar 07

Status: Open
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F)
Affects Version/s: 2.0.6
Fix Version/s: None

Type: Change Request Priority: Major
Reporter: Robert Healey Assignee: Unassigned
Resolution: Unresolved Votes: 37
Labels: Zabbix7.2, csv, export
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by ZBXNEXT-3178 CSV export button for history data Closed
is duplicated by ZBXNEXT-2531 Excel Export Support for Presentations Closed
is duplicated by ZBX-11361 How to export Graph to PDF/CSV Closed

 Description   

It would be highly desirable to be able to export the data used in creation of graphs as CSV format files, either as a button or drop down item. I imagine others might find use for XML or other formats but our needs are for CSV data files like our other monitoring/graphing software does.

It came as quite a surprise that this isn't already a part of the system.



 Comments   
Comment by Oleg Ivanivskyi [ 2013 Apr 24 ]

FYI ZBXNEXT-731

Comment by Robert Healey [ 2013 Apr 24 ]

Note: This request differs from ZBXNEXT-731 in that we'd like to extract info from arbitrary graphs, not just the last data sampled.

Example: Use a days worth of item samples to make a graph, then output the items plotted in the graph to a CSV to import into other apps/spreadsheets for planning/justification/issue reports etc. We do this all the time with our other monitoring packages and it would be great to do this with Zabbix as well.

Comment by richlv [ 2013 Apr 24 ]

would switching to "values" and clicking on "as plain text" work ?

Comment by Robert Healey [ 2013 Apr 24 ]

Re: Switching to values.
I'm new to Zabbix, could you elaborate on where "values" option is? Thanks!

It still would leave Zabbix not doing something the other packages its being compared to have done for quite a while.

Comment by Oleg Ivanivskyi [ 2013 Apr 24 ]

I'm new to Zabbix, could you elaborate on where "values" option is? Thanks!

The last screenshot, the right upper corner.

Comment by Robert Healey [ 2013 Apr 24 ]

Thanks for the pointer Oleg!

It's certainly closer to what we want/need but is still significantly different from what is produced by our other applications; i.e. manual cut/paste into a file, one item at a time rather than all graph data items at onces, etc.

It would be nice to have the values/plain text option available somewhere on the actual graph page; our other apps have a button or dropdown on the graph page to output the data used by the graph in CSV/XML/Excel/etc.

Comment by richlv [ 2013 Apr 24 ]

if you are interested in bulk data export, check out the api

Comment by Robert Healey [ 2013 Apr 24 ]

It isn't so much bulk data export as getting data items, usually multiple items per single graph, from a particular graph saved in CSV format files.

Our other platforms export it with a click from the graph area. It would be nice if Zabbix did as well, thus the feature request.

All the other monitoring programs we use, both open source and proprietary/internal, have this.

We were quite puzzled that Zabbix did not.

Comment by Ryan Armstrong [ 2014 Jul 22 ]

I'm trying to convince our security team to migrate away from Cacti but this issue is a big roadblock for them.
In Cacti they can select a region on a composite graph and export the values for that region to csv with the click of a button.

Would be very nice to have!

Comment by makemeasandwich [ 2015 Sep 08 ]

Is there anything done on this matter?

I think this option is pretty important!

Comment by James Cook [ 2015 Sep 08 ]

Im finding this an issue data centre team moving from their existing tool cacti as they to extract the data for their reporting system. This is one of the final hurdles for them and hopefully we can be rid of cacti and be a zabbix only site.

Comment by makemeasandwich [ 2015 Sep 08 ]

Ya same here

Comment by richlv [ 2015 Sep 08 ]

just a reminder that values for a simple graph can be easily accessed from the graph page, dropdown in the upper right corner.

also please note the discouragement of "me too" comments as per https://www.zabbix.org/wiki/Docs/bug_reporting_guidelines#Reporting_an_issue

and eventually, if you'd like to get some community advice or discuss some issue, everybody is highly welcome on irc - see https://www.zabbix.org/wiki/Getting_help#IRC for the detail

Comment by James Cook [ 2015 Sep 08 ]

Hi Richlv,

I have mentioned the separate simple graphs to the guys however they have composite graphs containing of all the data center air conditioners and ups devices information. This way on one graph they can see all the air conditioners in a location and whether the temperatures or humidity are consistent with each other or whether one of the units is spiking etc...

Regards
James

Comment by Kodai Terashima [ 2016 Mar 08 ]

Adding CSV export button to history data screen is nice feature as well, adding the button next to "As plain text".

Comment by richlv [ 2016 Jun 10 ]

it might be worth also considering other structured formats - maybe json, which could even match zabbix api output somewhat ?

ZBXNEXT-3301 asks for such a structured data transfer for configuration entities

Comment by Pavel [ 2020 Nov 30 ]

This is a traditional feature for quick analytics. As products and methods of analysis spread, they will become more and more in demand among users.
The data should be opened in one click without transformation or cleaning.

sorting the values by ascending time would also be nice.

Generated at Fri Apr 26 03:50:44 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.