[ZBXNEXT-248] Improved and more advanced reporting and statistics Created: 2010 Feb 22  Updated: 2024 Apr 10  Resolved: 2022 Feb 07

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

Type: New Feature Request Priority: Major
Reporter: Emil Odepark Assignee: Unassigned
Resolution: Fixed Votes: 82
Labels: reports
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

GUI


Issue Links:
Causes
Duplicate
duplicates ZBXNEXT-7125 Top hosts data grid widget Closed
is duplicated by ZBXNEXT-4036 Introduce Table(Overview) view widget Open
is duplicated by ZBXNEXT-3068 Schedule report delivery via media types Closed
is duplicated by ZBXNEXT-3208 Schedule report function for zabbix Closed
is duplicated by ZBXNEXT-6478 Scheduled PDF report generation servi... Closed
Sub-task
depends on ZBXNEXT-2968 easy display graphs with N top items ... Closed
part of ZBX-13356 Availability report shows only year c... Closed
Team: Team C

 Description   

There is one area where Zabbix is way behind commercial competitors and that is the field of reporting and statistics. Today there is no easy way of getting good statistics or reports from Zabbix. Please see the quote below that was taken from this thread:
http://www.zabbix.com/forum/showthread.php?p=59925#post59925

"Say for example that I want to know which 10 servers that had the highest decrease of free space, highest avg CPU load etc.. for the last 30 days. This can't be done in zabbix today.

I know that I can create a report based on triggers so that I get a list of the trigger status in % for each host. But this requires a trigger for the information that I want and I can't sort the list in any way, so this is kind of lame actually.
What I want is a specific screen where I can create all kinds of reports and statistics for the last month. Some things that I want:
A list of the top 10 servers that has had the highest average CPU load (or any other monitored item) for the last month.
I want to be able to get a list of all monitored servers and get the total disk space, current free diskspace and the change of free disk space for the last month (SORTABLE by category). I want to be able to make similar comparisons for any monitored items and host.

Something like the Overview screen in the monitoring section, BUT containing monthly or weekly averages and of course the most important; it has to be sortable by category (ie. highest CPU load in a decending order...)."

What you probably need to do is to make available the creation of reports based on actual data insted of the current "Trigger=True or False" approach. Its just not versatile enough, unless you're gonna have hundreds of triggers for each Item that you're monitoring. Please also make all the reports exportable, see my other feature request on that.



 Comments   
Comment by Elvar [ 2010 Sep 22 ]


I couldn't agree more with this request. The thing I need most out of Zabbix right now is concrete reporting. Thanks for the request!

Comment by Oleksii Zagorskyi [ 2012 Mar 02 ]

see ZBXNEXT-247 too

Comment by Ryan Schellenberg [ 2012 Apr 30 ]

Going to have to agree with the post. Providing a Top X or Bottom Y across a set of hosts or groups would benefit greatly. Throwing graphing capabilities into the mix would push Zabbix form a backend tool to more of a front facing interface.

Comment by Doug Irvine [ 2012 Jun 11 ]

Gets my vote too. Would be really useful.

Comment by Marc Schoechlin [ 2012 Jun 11 ]

We would very happy to have reports in/for zabbix.

Probably a flexible, ready-to-run and beautiful set of jasper/birt-report-definitions (as part of the zabbix distribution) would be a good alternative....

Some suggestions for the implementation of a reporting facility:

  • Template mechanism to define the structure of a report
  • configurable design
  • add certain graphs
  • availability calculations
  • list of downtimes (with/without comments)
  • possibility to add descriptions for the presented data
  • maintenance windows should be exclude-able, should be visualized
  • enumeration facility for the included elements for the given hostgroup, hosts
    (i.e. show all load-graphs of the given hosts, show all graphs for a given host)
  • Possibility to define reporting jobs
  • based on templates, hosts and hostgroups
  • create PDF, HTML, Excel, ODT-Reports
  • manual execution
  • scheduled execution
  • post-execution hook
    (i.e. to send by mail, store on a webserver, ...)

Maybe some parts of the described functionality can be inherited from the screen facility.

Comment by Dimitri Bellini [ 2012 Aug 30 ]

Very good suggestion! Zabbix is great but we need a good reporting tool. The Enterprise market need it!
Many thanks

Comment by Pedro Sousa [ 2013 Jun 13 ]

I've been using Zabbix for quite some time now, after using on production environments almost every major player's solution for monitoring systems (Ex: Nagios, Cacti, Zenoss, etc.). I'm also a person of reference to several other companies and their system engineers. Everytime some asks me what should they use for monitoring I tell them about my experience and about Zabbix. Almost everytime I ear the same when replying to questions about Zabbix's Reporting capabilities: "Oh, I need Reporting! Well, seems Zabbix is not for me." and they turn to other solutions...

This subject is being talked about for quite some time on the Zabbix Forum and this "Feature Request" was created here 3 years ago!!! It seems to me (and other Zabbix users I talk with) that Zabbix developers are deft to our requests... Those "stupid" Bar Reports that need to be configured each time someone wants to produce a report is not a solution. I know that I can use ireports or Jasper on-top of Zabbix (or Zabbix DB) to do Reporting but that's like "buying a Mercedes but have to use a Mini's wheels"!!!

How much longer for you to ear us?

Comment by Marc [ 2013 Jun 13 ]

Maybe someone should take the chance to suggest a ZBXNEXT for sponsoring.

There is already a lot of cool (ZBXNEXT) stuff coming for free. Lots of companies out there develop / take-over great OSS and make two products out of it. One lazy supported/extended open source product and one enterprise version which gets all attention and new features.

I'm very happy that SIA provides one and the same software base of ZABBIX for community and enterprises and has an open ear for everyone.

I don't know SIA at all but would they decide not to develop something for free that is obviously needed in enterprises and wait instead for a sponsor, then this would be more than justified to me.

Comment by Elvar [ 2013 Jun 14 ]


Marc, I get what you are saying but consider that one of the ways the Zabbix teams makes money is by selling support agreements. This is a very common and popular way to make money with open source. Take for example the last company I worked for. They were using Zabbix to provide network monitoring services to clients and ended up buying one of the mid range support agreements from Zabbix. After having used Zabbix for about six months they picked up a client that required extensive reporting features that Zabbix didn't have. Because of this, the company switched to a commercial product which in many ways isn't as good, but had the reporting that was needed. So in this example, the lack of reporting features cost Zabbix at least several more years of support agreement renewals. If I was on the Zabbix team I would want to know things like this and consider this very important information.

Comment by Marc [ 2013 Jun 14 ]

Elvar, don't get me wrong. Having more sophisticated options for reporting is something I would love to see too.

Anyway, people tend to forget the meaning of (F)OSS. There is no responsibility or duty by the developers to do anything. If there is lack of functionality and one can't attract attention of the devs, either DIY or live without it.

In case of ZABBIX there is luckily another option. One can pay for it to get it. Further more one does not necessarily have to pay it completely.
Finally a support contract is no fast lane for ZBXNEXT.

Let's stop this discussion here
I totally agree that this is is a very valuable and necessary feature. But this is not the right place neither for discussing development strategies/priorities nor for non-technical complains.

Comment by Emil Odepark [ 2014 Apr 02 ]

sad to see that more than four years later, still nothing.....

Comment by Marc [ 2015 Jul 16 ]

This has actually to be placed in the forum. Nevertheless, I take the liberty to put it here anyway as I see this ticket more appropriate.

While some report like views in Zabbix frontend would definitely be useful, I still advocate to delegate real/serious reporting tasks to a true report engine.

In my opinion Zabbix frontend reports should keep the focus on identifying issues with Zabbix performance or its configuration.
Everything beyond is likely as varied as the number of Zabbix installations out there.

The drawback by using report engines like Pentaho, JasperReports & Co is, they don't support Zabbix API.
Accessing the Zabbix database directly is a bad approach from a design (and usability) perspective. E.g. the data model of the Zabbix database might change with each new major release, what is completely abstracted if using the Zabbix API.

As for JasperReports I'd like to draw your attention to a feature request for a JasperReports data adapter rsp. data source to access Zabbix API:
http://community.jaspersoft.com/jasperreports-server/issues/4996

I don't expect this to get implemented soon (or at all). It is also worth to get a Zabbix data source for other products like Pentaho, etc.

Finally I believe making a report engine natively support Zabbix API is the most worthwhile way. Zabbix is neither a report-engine nor a scheduling system - it's a network monitoring system.

Since there are powerful applications available (even when not *F*OSS) which already cover each aspect of report design, scheduling, format...., it just sounds wrong to me to reinvent the wheel in Zabbix - while probably never ever even nearly reaching the diversity of what is already possible with specialized products like BIRT, Pentaho, JasperReports and others.

Currently I'd even suggest to close this ticket. Despite of my opinion regarding reporting for Zabbix, the ticket requests too many concrete and vague aspects that are unlikely to be implemented at once. If at all, a feature request for each reporting aspect might be a more useful approach.

I might be wrong though

Comment by richlv [ 2015 Jul 24 ]

a more specific request for top item values at ZBXNEXT-2249

Comment by finalbeta [ 2017 Apr 13 ]

I would like to add my 2 cents to this as Jasper reports engine has come up as a way of adding report support.
I'm currently creating some reports using Jasperreports for Zabbix on top of the API. Jasper report currently has a cummunity plugin that allows access to a JSON webservice. ( http://community.jaspersoft.com/project/web-service-data-source ). I can confirm that this works on Zabbix and that it also supports HTTP auth.

I do see some potential problems with this approach.

  • Using the Zabbix api to list hosts, show interfaces, items, triggers etc means running a lot of API calls. While the API is stable, it is somewhat slow.
  • Zabbix wants a session ID. creating this in Jasperreports is a bit hacky. (I use the dataset of the main report and pass the session id to the subreports)
  • The Zabbix API does not export Maps/Graps in the API. The only way to get them is grabbing them from the frontend. So this would require more "hacks" from the Jasperreport side. Untill ZBXNEXT-562 is implemented.
Comment by Thiago Murilo Diniz [ 2018 Feb 16 ]

With JasperReports I use Scriptlets to authenticate to the Zabbix API:
https://community.jaspersoft.com/wiki/creating-and-managing-custom-reports-zabbix-jasper-reports-through-json-rpc-api

Comment by Gustav [ 2018 Mar 07 ]

I was also disturbed that when I recently wanted to pull availability stats for the previous year that it didn't work. For clarification, the interface has the options to change the dates of the report but it doesn't work. The response for that fault was "This behavior is by design, no customizable SLA reports now" and was promoted to go buy Custom Development. Now this seems understandable that the project needs some way to make money but the way this was handled was horrible.

In the end I installed a Graphana server and used it's zabbix plugin to get the info i wanted out (using the API). so it seems that the functionality is in the system but it just needs the UI to be enabled to do so.

Perhaps the zabbix team could even integrate a graphana server into this with a customized plugin that would present you all the information in a meaningful way it's collected in.

Comment by Leap Cloud Solutions Inc [ 2020 Sep 26 ]

Hello, we just wanted to throw our vote behind integrating Scheduled Email Reports as part of the Reporting feature.

I saw that there was an existing request that was closed as a duplicate of this thread: https://support.zabbix.com/browse/ZBXNEXT-3068

However it seems that scheduled email reporting is still not a feature included as of Zabbix 5.0 LTS.

This is something that would be supremely useful for IT providers as our clients regularly request SLA reports (the Zabbix Availability Report pretty much includes what is needed; it is the lack of email support which would really improve the platform for us).

Comment by Alexei Vladishev [ 2020 Sep 28 ]

Thanks for the feedback. I hope to address support of scheduled and TopN-like reporting in Zabbix 5.4.

In the related news support of API tokens is also coming in Zabbix 5.4, for those who want to learn more: https://support.zabbix.com/browse/ZBXNEXT-6207

Comment by Oleksii Zagorskyi [ 2021 Mar 09 ]

Watch on ZBXNEXT-6478

Comment by Stefan [ 2021 Jul 29 ]

I think ZBXNEXT-4529 is somehow related

Comment by Alexei Vladishev [ 2022 Feb 07 ]

Support of the "Top hosts" widget has been implemented under ZBXNEXT-7125 in Zabbix 6.0. I am closing this ticket.

Generated at Wed Aug 06 08:54:26 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.