Bar reports is the most sophisticated built-in data visualization tool in the Zabbix frontend. As such, they are also quite intimidating, thus we will create a couple of reports with all three different bar report types.
Bar reports provide more customization options, but they can also take a lot of time to set up. Let's see what reports are available at Reports | Bar reports—see the Reports dropdown at the upper-right corner.
As we can see, three report types are available, but it's not trivial to guess by their names which is useful in which situation, so we'll try to apply each of them.
Distribution of values for multiple periods
This is the first report and there's no need to switch to another, so dismiss the dropdown by clicking in the Title textfield and enter Comparing network traffic there. Let's start by getting some output from the report—click on Add in the Items section. This opens the item configuration dialog, in which you should click the Select button next to the Parameter field. In the upcoming list, find the Incoming traffic on interface eth0 item next to A Test Host and click on it.
We won't change any other details, so click on Add. Getting a report as soon as possible was our main goal, right? Let's click on Show.
Now that's useless and ugly. There surely must be some way to make this report useful... Take a look at the Scale option—it is currently set to Weekly. If we compare that to the values in the Period section, they are set to one day, thus there's no wonder we got a single huge block. Looking at the Scale dropdown, we can see possible scales of hourly, daily, weekly, monthly, and yearly. Our displayed period is one day, so select Hourly in this dropdown, then click Show to refresh the report.
That's way better. Except maybe the x-axis labels... This again is a minor bug in Zabbix version 1.8.1. Now let's add another item—click Add in the Items section and again click on Select next to the Parameter field. Find the item Incoming traffic on interface eth0, but this time for Another Host, and click on it. Change the color for this item by clicking on the colored rectangle and choosing some shade of blue, then click Add. The report is immediately updated and now it looks more useful, we can compare amount of data transmitted for each hour for both hosts. Now, which host had which color? We should enable the legend here, mark the checkbox next to Legend title and click on Show. Let's look at the legend.
That's not helpful. As both items have the same name, they can't be distinguished in the legend—that has to be fixed. In the item list, click on the first item that has the green color chosen. Notice how this dialog looks very similar to the graph item configuration. We also have choice of axis, color, and function. But there's one additional feature, though—look at the first option, Caption. As we saw, the one inserted by default doesn't work that well here, so we will have to change it. Enter in the field A Test Host, then click Save. Now click on the bluish color item, and enter Another Host in that textfield, then click Save. What does the legend look like now?
Wonderful, that can finally be used to figure out which entry belongs to which host. We can still improve this report a bit. Enter Hourly distribution in the X Label field and Incoming traffic in the Y Label field. The final result should look like this:
When you are done, click Show. Our report appears below with labels for axis added.
With the help of this report it is quite easy to spot busy hours (or days, or weeks, or months, or years depending on what period and scale you choose) or compare data from several items. This is especially useful with many items, as custom graphs become unreadable with many items. Of course, there are practical limits to how many items can be compared with this bar report, but they are still much easier to read than normal graphs. Ability to choose scale allows for a layout that's better suited to spot important information or make a point. As there are no limits to hosts that items come from, it's possible to create a report that examines several items from a single host or a single item from multiple hosts, or a mix of these in arbitrary combinations.
Distribution of values for multiple items
We found out what the first report does, and it's time to move to the second one. In the Reports dropdown select Distribution of values for multiple items. This report has a more simple form, at least it looks like that initially. Let's get to creating a new report—enter Comparing CPU Load in the Title field. Now we have to add periods and items. This will be confusing at first, but you'll get the idea when you see the result.
Let's start with adding some item. Click on Add in the Items section, then Select next to the Parameter field in the upcoming pop up. Choose CPU Load for A Test Host, then click Add. We should now have an item added like this:
Now is the time to move to the time periods. Our test installation probably doesn't have huge amounts of data gathered, so we'd be safer choosing smaller time periods like hours. Click on Add in the Period section, which opens period entering form. Now, set your current date in both date fields and set the latest passed full hour in the Till field time selection, and one hour before in the From field. If your current time is 14:50, that would mean you would use 14:00 for the Till field time value and 13:00 for the From field time value. It would look something like this:
When you are done, click Add. We have to add more periods for this report, so click Add in the Period section again. In the period details form set current date just like before, and this time set one hour period just before the previously added period. If you previously added a period of 13:00-14:00, now add 12:00-13:00. Choose another color and click Add.
Now repeat this process three more times, each time setting the period one hour before and using a different color. Remember to use current date in both fields as well. Don't worry if you make a mistake. You can easily click any of the added periods and fix it. When you are finished, take a rest, then click Show button.
Oh shiny. While your output will look different depending on color choices and actual CPU loads, you'll notice how we can easily compare CPU loads for each defined time period. Sort of. We can observe here the same problem as with the previous report, we can't quite figure out which period is which, so mark checkbox next to the Legend title and click Show. Take a look at the legend.
That helped, now we can see which time period each bar represents. The legend is somewhat too verbose though. We know this is a single date and that each period is one hour, so it would be enough if each legend entry would simply list the starting hour. As with the previous report, we can customize captions, so click on the first entry in the Period section. Enter the starting hour in the Caption field (the one in the From field) for this particular period, for example, 13:00, then click Update. Now for some tedious work, do the same with all other periods.
Now our legend is more readable and takes up considerably less space as well.
But we have only added a single item so far, let's add some more. Again, click on Add in the Items section and click on Select next to the Parameter field in the upcoming pop up. This time, choose CPU Load for Another Host, then click Add. The report is immediately updated and another block for the newly added item appears.
We can now see how the load compares during each period for each item (in this case, same item for different hosts). Oh, but we have again hit the same problem as before—the block titles are identical, so we don't even know which host is which. Luckily, for this report we can enter custom titles both for periods and for items. Click on the first item and enter A Test Host in the Caption field, then click Save. Click on the second item and enter Another Host in the Caption field, then click Save.
There is one more minor polish we could add; enter CPU Load in the Y Label textfield. The final configuration should look similar to this:
If it does, click Show. Our report appears with all the options set and seems to be quite readable.
While our test installation does not have that much data, this report is useful for large scale comparisons of data—for example, comparing data with periods spanning a year. Smaller periods can be useful to extract seasonal or other periodic patterns. For example, one could create a report with 12 periods, you guessed it,one for each month and observe how seasonal changes impact data. Such a report is much more readable than common graph.
We saw how this report looks like with single item, but would it also be useful with single period? Let's find out. Select all but one checkbox in the Period section and click the Delete selected button just below them.
Well, those are huge blocks. But it should be clear now that single period configuration is also very useful. We could create a report on a compile farm, comparing the loads of all involved machines during some specific compilation job or compare the amount of Apache processes started on many web servers. Notice one more option appearing in report configuration, which you might have noticed disappear when we added second period—Sort by. We have a choice to sort either by name or by value. Name, obviously, will sort alphabetically, while value will sort by each item's value in ascending order. You'll be able to easily figure out which systems are overloaded and which are way too idle, for example.
Comparing values for multiple periods
We have now gotten to the third and final report. In the Reports dropdown choose Compare values for multiple periods. We'll again start by getting some result ready quickly so that purpose of this report is easier to understand. Enter Network output analysis in the Title field. Now take a look at Groups and Hosts sections. We'll start with something simple first, so select A Test Host in the Other Hosts box that is located in the Hosts section, then click << button in the same section.
Now we need something to report on—click Select next to the Item field and click on Outgoing traffic on interface eth0 for A Test Host in the upcoming form. We can try to obtain some output now, click Show.
Let's try to figure out what this represents. To do this we'll take a closer look at report options.
- Period: This is quite simple. It is set to be one full day, 24 hours.
- Scale: Familiar from the previous report, this determines how fine-grained the report will be. There will be one bar per scale period.
- Average by: This is a new option. While scale controls how many bars there will be, this option will determine what each column means. It will show average values per chosen period here.
Let's try to piece all these together. For a period of Period as many bars are drawn as Scale periods fit in, each representing the average per Average by period.
Still confused? Let's dissect our particular example. Let's put the first two options together. Our period is one day, 24 hours. Our scale is weekly, thus one bar will be drawn for each week that fits inside our period. That can be one only, right? Not quite. If these 24 hours pass the weekly border, we would get two bars. So what about the Average by option? It controls what actually goes into the report—this option is independent of the Scale option. No matter what scale we have chosen, averages will be calculated per the period chosen here.
What's the benefit? That might be more obvious if we created a slightly more meaningful report. While our testing system might not have too much data gathered yet, we might want to find out about traffic during the past few days. But we are interested in average hourly traffic, not daily.
Start by changing the period to be three days in the past, starting from now. In the Scale dropdown, choose Daily, and in the Average by dropdown choose Hourly. While we're here, mark the Legend checkbox. When done, click Show.
Now, why are we seeing four bars, if we chose three days only? Our period actually spans four days—a part of the current day, two full days and a part of the fourth day. We'll leave it as it is, but for other reports you probably will want to align period to scale starting points.
Looking at these bars, it's important to remember that each of them represents average hourly traffic for each of the displayed periods (days in this case), not a full traffic per period displayed. If billing, capacity planning, or other functionality refers to traffic per hour, we could create a report showing average traffic per hour for last few years and find out what exactly was it during a particular year easily.
Of course, nothing prevents you from setting averages to be calculated for the same or even longer period than the scale, although in most cases that would be pointless. Note that if we tuned the period to match the scale, we could reproduce part of the previous report's functionality, with the added ability to choose any averaging period.
Now, let's figure out how this report works for multiple hosts. Mark Linux servers in the Other Groups for Groups section, then click << button in the same section, then click Show.
As can be seen here, the new host appears alongside the previous one in the report. The good news is, even though we have A Test Host selected both in the Hosts section and the Groups section, it is appearing only once in the report, thus we can safely create reports on hosts that are in multiple of the chosen groups.
There's a bit more we could configure for this report. While we can't customize coloring of each bar, look at the last option for this report.
The two palette dropdowns provide a choice for which palette to use, and whether coloring should be normal, slightly darkened, or brightened. There are four predefined palettes available, feel free to experiment with these combinations. For example, darkened Palette #4 would look like this:
Note that you have to click Show whenever you change a palette or its brightness.
In this article, we looked at the bar reports that are available in Zabbix.
Bar reports, require more configuration and is more complex, which in turn provides the flexible functionality. Most of the bar report usefulness is evident for longer periods like several months or years, although figuring out the effect of some event on a smaller scale can be nice also, like reporting on what happened during slashdotting. With the flexibility of bar reports it can sometimes be hard to figure out which one should be used. We can try to simplify this problem by considering some a typical questions that a particular report can answer:
Distribution of values for multiple periods
What amount of web server processes was started on each web server every week last month, grouped by week?
Distribution of values for multiple items
- What was the system load for file server in December for the last 5 years?
- What was the system load for all file servers this December, sorted by load or host name?
Compare values for multiple periods
What was the average daily outgoing network traffic during the last three months for all web servers?
Obviously, there are many more reports that can be produced, but a short list like this should help you to choose correct report type without having to try out several reports.
If you have read this article you may be interested to view :