Details

    • Type: Change Request Change Request
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0.6
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:

      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.

        Issue Links

          Activity

          Hide
          Oleg Ivanivskyi added a comment -
          Show
          Oleg Ivanivskyi added a comment - FYI ZBXNEXT-731
          Hide
          Robert Healey added a comment -

          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.

          Show
          Robert Healey added a comment - 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.
          Hide
          richlv added a comment -

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

          Show
          richlv added a comment - would switching to "values" and clicking on "as plain text" work ?
          Hide
          Robert Healey added a comment -

          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.

          Show
          Robert Healey added a comment - 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.
          Hide
          Oleg Ivanivskyi added a comment -

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

          The last screenshot, the right upper corner.

          Show
          Oleg Ivanivskyi added a comment - I'm new to Zabbix, could you elaborate on where "values" option is? Thanks! The last screenshot , the right upper corner.
          Hide
          Robert Healey added a comment -

          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.

          Show
          Robert Healey added a comment - 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.
          Hide
          richlv added a comment -

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

          Show
          richlv added a comment - if you are interested in bulk data export, check out the api
          Hide
          Robert Healey added a comment -

          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.

          Show
          Robert Healey added a comment - 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.
          Hide
          Ryan Armstrong added a comment -

          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!

          Show
          Ryan Armstrong added a comment - 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!
          Hide
          makemeasandwich added a comment -

          Is there anything done on this matter?

          I think this option is pretty important!

          Show
          makemeasandwich added a comment - Is there anything done on this matter? I think this option is pretty important!
          Hide
          James Cook added a comment -

          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.

          Show
          James Cook added a comment - 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.
          Hide
          makemeasandwich added a comment -

          Ya same here

          Show
          makemeasandwich added a comment - Ya same here
          Hide
          richlv added a comment -

          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

          Show
          richlv added a comment - 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
          Hide
          James Cook added a comment -

          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

          Show
          James Cook added a comment - 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
          Hide
          Kodai Terashima added a comment -

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

          Show
          Kodai Terashima added a comment - Adding CSV export button to history data screen is nice feature as well, adding the button next to "As plain text".
          Hide
          richlv added a comment -

          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

          Show
          richlv added a comment - 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

            People

            • Assignee:
              Unassigned
              Reporter:
              Robert Healey
            • Votes:
              16 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

              • Created:
                Updated: