This widget provides a way to create custom tables for displaying the data situation, allowing to display Top N-like reports and progress-bar reports useful for capacity planning.
The maximum number of hosts that can be displayed is 100.
To configure, select Top hosts as type:
In addition to the parameters that are common for all widgets, you may set the following specific options:
Host groups | Select host groups to display in the widget. Alternatively, select a compatible widget as the data source for host groups. This field is auto-complete, so starting to type the name of a group will offer a dropdown of matching groups. This parameter is not available when configuring the widget on a template dashboard. |
Hosts | Select hosts to display in the widget. Alternatively, select a compatible widget or the dashboard as the data source for hosts. This field is auto-complete, so starting to type the name of a host will offer a dropdown of matching hosts. This parameter is not available when configuring the widget on a template dashboard. |
Host tags | Specify tags to limit the number of hosts displayed in the widget. It is possible to include as well as exclude specific tags and tag values. Several conditions can be set. Tag name matching is always case-sensitive. There are several operators available for each condition: Exists - include the specified tag names; Equals - include the specified tag names and values (case-sensitive); Contains - include the specified tag names where the tag values contain the entered string (substring match, case-insensitive); Does not exist - exclude the specified tag names; Does not equal - exclude the specified tag names and values (case-sensitive); Does not contain - exclude the specified tag names where the tag values contain the entered string (substring match, case-insensitive). There are two calculation types for conditions: And/Or - all conditions must be met, conditions having the same tag name will be grouped by the Or condition; Or - enough if one condition is met. This parameter is not available when configuring the widget on a template dashboard. |
Show hosts in maintenance | Mark this checkbox for hosts in maintenance to be displayed as well (in this case, maintenance icon will be shown next to the host name). Unmarked by default. |
Columns | Add data columns to display. The column order determines their display from left to right. Columns can be reordered by dragging up and down by the handle before the column name. |
Order by | Specify the column from the defined Columns list to use for Top N or Bottom N ordering. |
Order | Specify the ordering of rows: Top N - in descending order according to the Order by aggregated value; Bottom N - in ascending order according to the Order by aggregated value. |
Host limit | Number of host rows to be shown (1-100). This parameter is not available when configuring the widget on a template dashboard. |
Common column parameters:
Name | Name of the column. |
Data | Data type to display in the column: Item value - value of the specified item; Host name - name of the host; Text - static text string. |
Base color | Background color of the column; fill color if Item value data is displayed as bar/indicators. For Item value data the default color can be overridden by custom color, if the item value is over one of the specified thresholds. |
Specific parameters for item value columns:
Item | Select the item. When configuring the widget on a template dashboard, only items configured on the template can be selected. Selecting items with binary values is not supported. |
Display | Define how the value should be displayed: As is - as regular text; Bar - as solid, color-filled bar; Indicators - as segmented, color-filled bar. Note that only numeric items can be displayed in this column if this setting is not "as is". |
Min | Minimum value for bar/indicators. |
Max | Maximum value for bar/indicators. |
Thresholds | Specify threshold values when the background/fill color should change. The list will be sorted in ascending order when saved. Note that only numeric items can be displayed in this column if thresholds are used. |
Decimal places | Specify how many decimal places will be displayed with the value. This setting applies only to numeric data. |
Aggregation function | Specify which aggregation function to use: min - display the smallest value; max - display the largest value; avg - display the average value; count - display the count of values; sum - display the sum of values; first - display the first value; last - display the last value; not used - display the most recent value (no aggregation). Aggregation allows to display an aggregated value for the chosen interval (5 minutes, an hour, a day), instead of the most recent value. Only numeric data can be displayed for min, max, avg and sum. For count, non-numeric data will be changed to numeric. |
Time period | Specify the time period to use for aggregating values: Dashboard - use time period of the dashboard; Widget - use time period of the specified widget; Custom - use a custom time period. <This parameter will not be displayed if Aggregation function is set to "not used". |
Widget | Select the widget. This parameter will only be displayed if Time period is set to "Widget". |
From | Select the time period from (default value now-1h ). See relative time syntax.This parameter will only be displayed if Time period is set to "Custom". |
To | Select the time period to (default value now ). See relative time syntax.This parameter will only be displayed if Time period is set to "Custom". |
History data | Take data from history or trends: Auto - automatic selection; History - take history data; Trends - take trend data. This setting applies only to numeric data. Non-numeric data will always be taken from history. |
Specific parameters for text columns:
Text | Enter the string to display. May contain host and inventory macros. |