Pandora: Documentation en: Data Presentation/Reports

From Pandora FMS Wiki
Jump to: navigation, search

Go back to Pandora FMS Documentation Index

Contents

1 Reports

Pandora FMS offers you the possibility of presenting the monitored data sorted out through reports.

Within a report, the information to be presented is organized in 'report elements. There are many different types of elements, which perform calculations and present the information in very different ways. For example, you may choose a "simple graph" type element that makes individual graphs or an "SLA" type element that shows the degree of compliance of a number of monitors.

Although they generally have a very similar configuration form, each type of element will be configured independently.

You may have as many elements as you want, of the type of your choosing.

1.1 Creating a Report

In order to add a report, click on Reporting > Custom reports.

Report menu.png

It will show a list containing all the reports. In order to create a report, click on "Create Report".

Pre18.png

There is a form where to enter the name of the report, select the group it belongs to, whether it is private or not and add its description.

Once the fields have been filled out, click on "Create".

Pre19.png

Once done, a blank report will appear, where you may edit it including new elements.

1.2 Editing a report

In order to edit a report, click on Reporting > Custom reports. It contains a list with all the created reports. In order to edit a report, click on the report's name.

Pre43.png

1.3 Deleting a report

In order to delete a report, click on Reporting > Custom reports. It contains a list where all the reports up to that moment are listed. In order to delete a report, click on the trash icon located at the right side of the report's name.

Pre44.png

1.4 Tabs

1.4.1 Main tab

The main tab is the only one available within a new report, since there one defines the report's basic data (name, access group and description). After saving it properly, you may access the rest of the tabs.

Main tab reporting builder.png

The fields belonging to this particular tab are the following:

  • Name: Intended to define the name of the form.
  • Group: Intended to define the access group displayed within the report.
  • Description: Intended for providing more report information to the users (which will be shown within the report's list). It will also be displayed on the report in XML and PDF formats.

1.4.2 The 'List Items' tab

In this tab, you have a global view of all items the report is made up by. The items contained in the list will be displayed in the same order as in the report later on. This tab provides the following options:

  • Modifying the item (by clicking on the wrench).
  • Modifying the order with the right side boxes and the drop-down "Sort items".
  • Modifying the order manually through the green arrows on the left.
  • Deleting the item by clicking on the red x-shaped icon.

If it is a long report that contains several items, it has a form at the top in order to filter the items by different criteria.

List items tab reporting builder.png

The columns belonging to this particular tab are the following:

  • P.: The items appear exactly in this column's order within the report.
  • Type: The column where the item's type appears.
  • Agent: The column that contains the agent's name. It can be empty for item types like SLA, custom graph, import texts from URL, SQL queries, simple graphs and texts.
  • Module: The column that contains the name of the module from which data will be obtained in order to generate the report. It may also be empty for item types like detailed agent view, alert report agent, custom graph, event report agent, import text from URL, SLA, SQL queries and text.
  • Period: The time period based on which the report is generated.
  • Description: The column displaying the description given to the item in order to make the work with it a little easier.
  • Options: The column that displays the buttons and icons to edit or to delete it.

1.4.3 Item Editor tab

Item Editor tab is more complex than the others, because there you will be able to create the form items or edit them. The form is dynamically designed, according to the type of item you intend to create. In the editing process, all fields except the type are editable. If you need to change the type, the way to do it is to delete the current one and generate a new one along with the same configuration.

The common fields for all types are the following:

  • Type: Drop-down list containing the types of items intended for the report, which determines the appropriate fields to configure this type of item by selecting the type: Agents, Modules, Agent Detailed View, Alert Report Agent, Alert Report Module, Avg. Value, Custom Graph, Event Report Agent, Event Report Module, Import text from URL, MTBF, MTTR, Max. Value, Min. Value, Monitor Report, SLA, SQL query, Serialized Data, Simple Graph, Summary, TTO, TTRT and Text
  • Description: Text box intended for a description of the report item.

1.4.4 Types of Items

You may add different items to the report, which can be:

1.4.4.1 Graph Items
1.4.4.1.1 Simple graph

It shows the simple graph of a module.

Simple graph - item editor tab - reporting builder.png



This form's fields are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in the report item.
    • _agentgroup_ : Agent group selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: Time interval over which the report will be calculated (from the current point in time).
  • Agent: Intelligent control to choose the agent for that item.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Time comparison (overlapped): It shows the module graph overlapped in that time range, for example if the graph shows a 1 month span, the overlapped graph over it is the previous month.
  • Label: Label you can assign to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


Example of this type of report:

Pre39.png



1.4.4.1.2 Simple baseline graph

With this type of graph, you may see future estimation values for the selected module.Suppose you select a period of a week and today is Tuesday, this particular graph provides real data from Monday through Tuesday and estimation values for all other days within the selected week.

Baseline-form.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval on which the report is calculated (from now onwards).
  • Agent: Intelligent control for selecting the appropriate agent for this item.
  • Module: A drop-down list which is dynamically loaded with the agent's modules selected in the control above.
  • Label: Label you can assign to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


Example view of this type of report:

Baseline-result.png


Template warning.png

This type of graph has the potential to overload Pandora FMS if you use too much data to generate future estimations.

 


1.4.4.1.3 Custom graph

It is a user-defined combined graph. A field is added with a combo to select the graph intended to add.

Custom graph - item editor tab - reporting builder.png

The fields within this form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time interval on which the report is generated.
  • Custom Graph: A deployable list containing the user-defined graphs. In order to create theses graphs, click on Administration > Manage Reports > Graph Builder.

An example view of this type of report:

Pre26.png

1.4.4.1.4 Graphs defined from SQL

This type of report element allows custom graphs to be defined for use in reports. These graphs will be created using SQL code entered by the user. This SQL code should always return a variable called "label" for the text labels or name of the elements to be displayed and a field called "value" to store the numerical value to be represented. This is an example of SQL used to create graphs of this type:

SELECT a.name as `label`, count(st.id_agente_modulo) as `value`
FROM tagent_status st, tagent to
WHERE a.id_agent=st.id_agent AND (unix_timestamp(now()) - st.utimestamp) > st.current_interval * 2 group by 1;

For this example, there is this graph displayed where the number of modules in unknown status per agent is shown. It is quite similar to an SQL query, but it does not use headers, and it just needs the SQL code:

Sql graph pie.png




These are some examples of each of the three types of graphs that can be drawn with this tool: pie graphs, vertical bar graphs and horizontal bar graphs. In this example, several UTF (western latin, Japanese and Arabic) alphabet sets are used simply to show the multi-language capabilities of Pandora FMS.

Template warning.png

Due to security restrictions, there are some blocked words that cannot be used : *, DELETE, DROP, ALTER, MODIFY, password, pass, INSERT or UPDATE.

 


Info.png

This type of items must be handled with care, since they can overload Pandora FMS.

 


1.4.4.1.5 SQL pie graph

Example of pie graph for reports based on SQL query.

Report piegraph.png



1.4.4.1.6 SQL Vertical bar graph

Example of vertical bar graph for reports based on SQL query.


Report vgraph.png



1.4.4.1.7 SQL horizontal bar graph

Example of horizontal bar graph for reports based on SQL query.


Report hgraph.png


1.4.4.1.8 Availability graph

The availability report shows in detail the reached status of a module in a given time interval.

It will indicate all the relevant information about the time that this module has been available.

The time range you want the report about can be chosen (for example, the last month) and the working time if for example you need to indicate that you are only interested in the state of your module in a certain schedule (for example, 8x5, from 8:00 to 16:00 from Monday to Friday).

It is also possible to determine a prioritization mode. When choosing the OK prioritization mode, if data in the SLA compliance range overlap in time and some other state (such as a planned stop), it will paint that stretch green. If the unknown prioritization mode option is chosen, the color corresponding to the other state will always be displayed.

Availability builder.png


After saving the report element data, add the desired modules at the bottom:

Availability builder item.png

Note: You can use the SLA min. and max. (value) to indicate that the calculations are made in relation to the values reached by the module in that range. SLA limit % will indicate the acceptable minimum (within that range).

If you do not specify a minimum or maximum for the value, the values of thresholds defined in the module (dynamic limits) will be used by default.


Viewing the report, you will see the availability graph of the chosen module in the selected time range:


Availability graph.png

Failover mode

This feature is used to assign failover or backup modules to the main module on which the calculation of availability must be made. That is to say, if a module has one or several failover modules assigned, the calculation of availability for a determined period will be done considering these modules.

When the measured main module falls, if there are one or several operative backup modules, these will be taken into account for the SLA calculation. That way it shows only the real service failure where primary and backups do not work.


How to add failover or backup modules:

It is done in the edition of the module on which the calculation of availability must be made, in the Module relations section:

Failover1.png

Select the module that will work as failover and select the type of relation that in this case is failover type.

Once the modules are assigned in the report, activate the option "failover mode":

Failover2.png

There are two types of visual representation:

  • Normal: It will show the graph of the main module, as well as all its failover or backup modules and the graph result.

Failover3.png

  • Simple: It will only show a graph that will be the result of the availability calculation of these modules.

Failover4.png

In the simple type "availability graph" reports, add the possibility of adding a failover module directly to the report as a simulation, this will work exactly the same as the previous ones.

Template warning.png

This is not applicable in the wizard or in the template reports.

 


Failover5.png

1.4.4.1.9 Module Histogram graph

It will show a graph with the status histogram of the chosen module.

Example of module definition:

Histogram build.png

Display example:

Histogram sample.png

1.4.4.2 Items ITIL
1.4.4.2.1 TTRT

It is the total time in inoperative state (the sum of time that the monitor has not been OK).

TTRT - item editor tab - reporting builder.png


The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time period selected backwards in the temporal point where the report is generated.
  • Agent: Agent the module is chosen from.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Label: Label that can be assigned to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Display example:

Ttrt res.png


1.4.4.2.2 TTO

It is the sum of all the times where the monitor has been OK.

TTO - item editor tab - reporting builder.png



The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: Time period that it will take backwards in the temporal point where the report is generated.
  • Agent: Agent the module is chosen from.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Label: Label assigned to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


View example:

Tto sample.png

1.4.4.2.3 MTBF

Average time between failures

  • It is calculated: MTBF= TTO / #F
  • Where:
TTO=Total operating time in the period.
#F= total number of faults.
  • It provides the average normal operating time between failures.
  • RELIABILITY indicator.

MTBF - item editor tab - reporting builder.png



The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _module_ : Name of the agent module name selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The period of time that it will take backwards in the temporal point when the report is generated.
  • Agent: Agent from which the module is chosen.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Label: Label you can asign to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


Display example

Mtbf res.png

1.4.4.2.4 MTTR

It is the average time to restore the function of a piece of equipment, machinery, line or process after a functional failure.

  • It includes time to analyze and diagnose the error, time to get the spare part, planning time, etc.
  • It is a measurement of the maintainability of an equipment.
  • It is the interval of time obtained dividing the total time of the repairs by the total number of failures in a system.

MTTR - item editor tab - reporting builder.png



The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: The period of time that it will take backwards in the temporal point where the report is generated.
  • Agent: Agent from which the module is chosen.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Label: Label assigned to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.



Display example

Mttr res.png

1.4.4.3 SLA items

All SLA reports show information about the fulfillment of a metric, that is, they indicate the percentage of time that the module has had a known valid value.

All SLAs understand as valid the unknown periods, since Pandora cannot guarantee the module status if it does not have module data. Also, all periods in planned stop are considered valid (since in a planned stop situation, it is assumed that the module situation is controlled and accepted) and periods in warning status (the service is still provided in a non-optimal state).

As it will be seen later, some of the SLA reports present data grouped by time periods and the general status of these periods is calculated. When dealing with long periods, the module the report is being made on may have gone through many states: unknown, planned stop... In these reports, there is a configuration parameter called prioritization mode that determines which states have preference when summarizing. There are two options:

  • OK prioritization mode: The SLA compliance value prevails over the report non-run time, planned shutdowns, unknown time, and not started time.
  • Unknown prioritization mode: Any value other than OK will prevail. That way, you will see the non-operation times of the report, planned stops, unknown time and not started even if there is some data that makes the SLA comply.

Of course, if at any time the SLA compliance value is not reached, it will be painted red in any of the modes.

1.4.4.3.1 SLA

It allows you to measure the Service Level Agreement of any Pandora FMS monitor.

S.L.A. - item editor tab - reporting builder.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: The time frame on which the report is generated (from the present time).
  • Working time: The time frame during which the SLA will be working. The graph will be fully shown, but it will only be calculated with the data within said working time frame. The SLA will be unknown (N/A) if the interval to be shown is excluded from the work interval.
  • Show graph, table or both: Select whether a SLA graph, a status summary or both elements will be shown.
  • Order: Order SLA items according to the chosen criteria.

Once these options have been selected, add each of the target modules based on which the SLA must be calculated:

Availability builder item.png

  • Agent: A combo box intended to select the agent to use in the SLA.
  • Module: A combo box intended to select the module to use in the SLA.
  • SLA min (value): A field intended to determine the SLA's minimum value. The minimum values will trigger the SLA. This field can be empty to use the acceptable minimum module normal values.
  • SLA max (value): An optional field intended to determine the SLA's maximum value. The maximum values will also trigger the SLA. It can be empty to use the acceptable maximum module normal values.
  • SLA Limit (%): A field intended to set the correct time percentage for the SLA. If the module has been within the minimum and maximum limit values during this particular time percentage, the SLA will be shown as correct and as wrong if not.

It is also possible to add new modules to the SLA to create combined-module SLAs from the same or different systems.


Template warning.png

In case of combined SLAs, SLA compliance will depend heavily on the performance of all the SLAs configured so far.

 


The SLA value will take into account only the critical status of the selected module and they will be labeled as valid.

  • Time in unknown.
  • Time in scheduled downtime
  • Time in warning status.
  • Time in OK status.

Why accept unknowns?

Unknown status is reached when Pandora FMS does not receive information from a certain target. In this situation, Pandora FMS cannot guarantee whether the service was provided as usual or not, so in the face of an unknown it is accepted.


When taking into account the SLA calculation shown in the report, you may configure scheduled downtimes (past or future) so that it does not take into account possible failures that could possibly take place during that interval of the scheduled downtimes. The value it will take in all the intervals where the scheduled downtimes is enabled is OK, as if during that intervals no incorrect data was received.

SLA 2.png

In this example it can be seen better. In the first image, there is a module data history with two intervals in critical status. Without scheduled downtime the SLA value is 93%.

SLA sinsch.png

After seeing that the first module downfall was due to external problems, ta scheduled task that covers that interval is added. When adding the scheduled task, the final estimation will take it as if the module's status was correct all along.

SLA consch.png


Note: If you forgot to create a scheduled downtime, you can create past scheduled downtimes given thatthe console administrator has enabled it.


1.4.4.3.2 Monthly SLA

This feature is only available for Pandora FMS Enterprise versions. It is a variation of the SLA feature. Instead of measuring the service level periodically, it does it every day during the months in this period.

Examples:

  • In a report of May 5th, it will calculate the SLA of every day in May.
  • In a report between February 13th and April 4th, it will calculate the SLA of every day in February, March and April.

Each module on each month will contain the same data of a standard SLA, except that its compliance will not be at month level. It will be the percentage of days that accomplish it. There is also a bar that will display all days of the month by the following color code:

  • Green: The SLA met.
  • Red: The SLA met.
  • Gray: Unknown. There is not enough data on that day.


Info.png

Days in unknown will be taken into account as valid data for the percentage of days that meet the SLA.

 


If there are days that do not meet the SLA, they will be detailed in a summary table.

S.L.A. Monthly - view.png

1.4.4.3.3 Weekly SLA

It displays the SLA of the modules chosen by weeks along the selected period (current month by default).

Sla weekly.png


It allows to edit the working time in case you have a custom service schedule (e.g. 8x5)

At the bottom, you may add multiple modules to this item.

View example:

Sla weekly sample.png

1.4.4.3.4 Hourly SLA

It displays the SLA of the modules chosen by hour along the selected period (current month by default).

Sla hourly.png


It allows to edit the working time in case you have a custom service schedule (e.g. 8x5)

At the bottom, you may add multiple modules to this item.

View example:

Sla hourly sample.png

1.4.4.3.5 Service SLA

It allows to measure the Service Level Agreement of any service created in Pandora FMS

S.L.A servicios.png

The fields found in this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: Time frame based on which the the report will be evaluated from the present time backwards.
  • Working Time: Time to be taken into account for the SLA calculation (e.g. for working schedules like 8x5).

Since Pandora FMS services come with their own SLA readings, calculations for the report are different according to the standard performance.

In this case, you may only choose the service whose SLA you wish to receive from those services you have configured in your Pandora FMS console. The SLA validity limit values are recovered automatically from the definition of the service itself.

S.L.A servicios2.png

You can always set planned downtimes to adjust the compliance levels whenever you need so, so that possible downfalls are not taken into account.

These scheduled downtimes may be assigned to the modules that make the service whose report you wish to obtain, or its sub-services. In all intervals affected by downtimes, the states that the service could have reached will be overlooked, and that period will not be taken into account for the the final SLA calculation.


S.L.A total.png

In this example, you can see an outline of the final calculation of the service, depending on the scheduled downtimes (orange) and the critical states (red) of the modules on which the state of the final service for SLA calculation depends.

Looking at the image, when any of the modules have a downtime that directly affects the final service and this interval is omitted for final calculation.

1.4.4.4 Prediction Items
1.4.4.4.1 Prediction Date

This type of item returns the date when module reaches its interval using a data projection of a module to the future.

To do the calculations, the Least Squares Method is used.

In order to configure this item, you're required to provide the information shown below.

To configure this type of item, the following data must be provided:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the module name selected in report item.
    • _moduledescription_ : Description of the module that you selected in report item.
  • Period: The time period that wors as basis for the estimation.
  • Data Range: The interval where module data must be to return the date.
  • Label: Label the element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

For instance, to check the moment a disk usage value between 60 and 100% for the mounting point /var will be reached, the following definition is used.

Projection graph5.png




That will generate the following output in this case:

Projection graph3.png


1.4.4.4.2 Projection Graph

This type of allows to asses the values a module will take in the future.

This estimation is based on Linear Regression and is implemented by means of the Least Squares Method.

Configure the following parameters accurately to get relevant results: The fields in this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Module name that you selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: The time period taken as basis for the estimation.
  • Projection Period: The future time period where data will be projected.
  • Label: Label you can assign to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Projection graph periods.png

In the example image, the area name period represents the evolution of module data during the selected time interval.

On the other hand, projection period shows the possible evolution of the module along the selected time.

A definition example, complementary to the previous case is the evolution of the usage of the disk mounted on /var.

Projection graph6.png


Obtaining the following results:

Projection graphs.png

1.4.4.5 Module Items
1.4.4.5.1 Avg. Value

It is the average value for a module within a predefined period. This period is calculated when viewing the report. Within the configuration menu, the fields for the Source Agent are added, where the agent and modules are selected. Eventually, the module's average value is shown.

Avg value - item editor tab - reporting builder.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time period takes backwards from the time point when the report is generated.
  • Agent: The intelligent control to choose the appropriate agent for this item.
  • Module: A drop-down list which is dynamically loaded with the agent's modules selected in the previous control.
  • Calculate for custom intervals: It shows the average data in custom intervals.
  • Table / Graph options: Show table, graph or both.
  • Label: Label that can be assign to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Within the HTML version of the report, an item of this type is generated as seen below.

Pre24.png

1.4.4.5.2 Max. Value

It is the maximum value of a module within a predefined period. This period is calculated at the moment of the report's viewing.

Max. Value - item editor tab - reporting builder.png

The fields of this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent that you selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards from the time point when the report is generated.
  • Agent: An intelligent control for selecting the appropriate agent for the item.
  • Module: A deployable list dynamically loaded with the agent's modules selected in the previous control.
  • Calculate for custom intervals: It enables the possibility of showing the report in multiple sub-intervals.
  • Time lapse intervals: Lifespan of each sub-interval.
  • Table | graph | both: Show data of each value of each sub-interval on a graph or a table or both.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Viewing example:

Pre29.png

1.4.4.5.3 Min. Value

The minimum value of a module within a predefined period. This period is calculated right when the report is seen.

Min. Value - item editor tab - reporting builder.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Calculate for custom intervals: It enables the possibility of showing the report in multiple sub-intervals.
  • Time lapse intervals: Lifespan of each sub-interval.
  • Table | graph | both: Show the data od each sub-interval on a table, a graph or both.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Viewing example:

Pre30.png

1.4.4.5.4 Monitor Report

It shows the time percentage a module has been correct or incorrect within a predefined period.

Monitor report - item editor tab - reporting builder.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Calculate for custom intervals: It enables the possibility of showing the report in multiple sub-intervals.
  • Time lapse intervals: Lifespan of each sub-interval.
  • Table | graph | both: Show the data od each sub-interval on a table, a graph or both.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Within the HTML version of the report, an item of this type is generated as you can see below.

Pre32.png

1.4.4.5.5 Serialize Data

It displays an item in table format report from the data stored within the table named 'tagente_datos_stringin' the Pandora FMS Database. For it, the agent should serialize the data separating them with a line-separating character and another which separates the fields. All lines should contain all fields. This type of item is e.g. used for the agent which is designed to extract management data from the SAP Platform.

Serialize data - item editor tab - reporting builder.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Serialized Header: A text field where the table headers shown in the report are separated by the '|' (pipe) character. There is one for each column created when separating the assembled field.
  • Field Separator: A separator intended for different fields within the serialized text chain.
  • Line Separator: A separator intended for different lines (made up by different fields) of the serialized text strings.
  • Label: Label assigned to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


The module that generates the following report returns lines with the following contento:

Some text sample|some value#this is a new row|and another value

When generating a report from that content, the output is the following:

Serialize sample.png


1.4.4.5.6 Summatory

It displays the sum of a single module's values within a specific time frame.

Sumatory - item editor tab - reporting builder.png

The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

This is a display example:


Pre40.png

1.4.4.5.7 Historical Data

This type of element will serve to receive a dump of the stored data of the module indicated in the configuration of the report.

Configure the following fields:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Historical.png

Example of report display:

Historical sample.png

1.4.4.5.8 Increment

This type of report element is used to show a brief analysis where the value variation of the indicated module is detailed.

Configure the following fields:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Period: Time interval taken based on which the report is calculated (from the present moment).
  • Agent: An intelligent control for selecting the appropriate agent for this item.
  • Module: Drop-down list which is dynamically loaded by the agent's modules selected in the previous control.

Increment.png

Example of report display:

Increment sample.png

1.4.4.6 Grouped Items
1.4.4.6.1 General

Shows values from different modules sorted (ascendingly, descendingly or by agent name) or/and grouped by agent.

We will configure the following fields:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in the report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : Name of the agent module selected in report item.
    • _moduledescription_ : Description of the agent module selected in report item.
  • Time lapse: Interval of time on which the report will be calculated (from the current moment).
  • Last value: Show only the last reading of the chosen modules.
  • Agent: The intelligent control to choose the agent for this item.
  • Module: drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.
  • Group by agent: Group report metrics by agent.
  • Order: Order in which the metrics will be shown.
  • Show summary: Display a final summary with the average, maximum and minimum values.
  • Show in the same row: Show all operations (max, min, avg or sum) in the same row.

Grouped general.png

Example of report display:

Grouped general sample.png

1.4.4.6.2 Group Report

It displays a table containing the below mentioned information of a predefined group:

  • Agents
    • The total number of agents.
    • The number of agents holding 'unknown' status.
  • Modules
    • The total number of modules.
    • The number of modules holding 'normal' status.
    • The number of modules holding 'critical' status.
    • The number of modules holding 'warning' status.
    • The number of modules holding 'unknown' status.
    • The number of modules holding 'not initiated' status.
  • Alerts
    • The number of defined alerts.
    • The number of triggered alerts.
  • Events
    • The number of this group's events within the last 8 hours.

Group-report-from.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Group: Combo intended to select the group.
  • Recurse: Analyze recursively the child groups of the choosen group.

Report view example:

Group-report-result.png

1.4.4.6.3 Exception

It shows values of several modules that comply with logical operations (higher or equal, lower, OK or Not OK).

Report last value exc.png

The following fields can be configured:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Time lapse: Interval of time based on which the report will be calculated (from the present moment).
  • Last value: Show only the last reading of the chosen modules.
  • Order: Order in which metrics will be show.
  • Value: Value considered with the chosen condition.
  • Condition: Condition under which to filter the report data. "Everything" ignores filtering.
  • Show summary: Display a final summary with the average, maximum and minimum values.
  • Show in the same row: Show all operations (max, min, avg or sum) in the same row.

You may add at the bottom as many modules as you need once the report element is saved:

  • Agent: Intelligent control to choose the agent for this item.
  • Module: Drop-down list that is dynamically loaded with the modules of the agent selected in the previous control.

Example of report display:

Exception - item editor tab - reporting builder.png

1.4.4.6.4 Agents / Modules

It displays a matrix of agents and modules of a specific module group along with its associated states.

Agents-modules - item editor tab - reporting builder.png

1.4.4.6.5 SQL queries

This item shows in Pandora FMS DB data reports, a table to keep custom data retrieved directly from the DB.

Template warning.png

This type of items must be carefully used, since they can overload Pandora FMS.

 


The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • SQL Query: Text box where to write the SQL query to retrieve data from Pandora FMS DB.
  • Serialized header: Text field where to put separated by | the headers of the table that will be shown in the report, for each column that came out as a result in the SQL query.
  • Custom SQL template: A drop-down list containing SQL templates of saved queries for easy use. These can be managed through Administration > Manage reports in Custom SQL.
  • Query History Database: Checkbox that when checked will make the edited SQL query also collect data from the historical database.

The queries that will appear in the report can be customized by choosing one of the following options:

  • Type in manually the query to perform in the text field.

Note: Due to security restrictions, there are some reserved words that cannot be used: DELETE, DROP, ALTER, MODIFY, password, pass, INSERT or UPDATE.


Custom sql report.png


  • Or, you may select a query from the list using the Custom SQL template drop-down:

Custom sql template report.png


Example of report display:

Custom sql report sample.png



Note: You may define your own templates in the menu Reporting > Custom SQL.

Custom sql menu.png


In the query list view, you can create your new stored query by pressing the button Create custom SQL:

Custom sql list.png

Define your query and a name to identiy it and press "Save" for it to appear on the list:

Custom sql new.png

1.4.4.6.6 Top N

It displays N values sorted out by maximum, minimum or average redarding the selected modules, ordered upward, downward or by name.

Report topn.png

Report view example:

Report topn sample.png

1.4.4.6.7 Network interfaces

This type of report element will generate the interface graphs of all those devices that belong to the selected group.

Report net interfaces.png


You may indicate:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Time lapse: Time range taken backwards over which the report will be made (e.g. one month from the chosen date).
  • Group: Group where agents with interface traffic modules will be searched.
  • Full resolution graph (TIP): Use the TIP real data drawing system instead of the standard motor.


Note: An agent shall be considered to have interface traffic data when it has modules with the following format:

  • Name of interface_ifInOctects
  • Name of interface_ifOutOctects
  • Name of interface_ifOperStatus

Note: Input/output octet counters can also be collected from HC counters (hcOctets).


Example of report display:

Report net interfaces sample.png

1.4.4.6.8 Availability

The feature of this type of report has been widely improved, so that now the data it represents are not approximations but an accurate reflection of the module situation throughout the selected period.

This item shows a table with the availability data of a selected list of agents and modules.

It also offers the possibility of showing a summary including those modules with higher and lower availability as well as an average analysis.

Report availability.png


The following fields can be customized:

The fields of this form are:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: Time interval based on which the report will be calculated (from the present moment).
  • Working time: Time period the module should have been working. The graph will be complete, but it will only be calculated based on the working time data. Availability will be unknown (N/A) if the interval to show is out of the working interval.
  • Show address instead of module name.Show the agent's main address.: It will show the agent's main IP instead of the name.
  • Show summary: Show a final summary.
  • Orden: Order the availability items according to the selected criteria.
  • Hide not init agents: Hide from the view non-initiated agents.


Once these options have been selected, add each of the target modules over which the SLA must be calculated:

Report availability add module.png

  • Agent: Combo where to indicate the agent to which the report must be applied.
  • Module: In a combo, the module of the previously set agent over which the SLA will be calculated.


Report view example:

Report availability sample.png


It shows the following information:

  • Agente: Agent.
  • Module / IP address: When configuring the item, you may choose whether to see the agent's main IP instead of that of the module. Very useful for reports that contain a list of agents and IPs instead of agents and ping modules.
  • Total time: Total time to anaylize.
  • Time failed: Time in critical status.
  • Time OK: Time in OK or warning status.
  • Time Unknown: Time in unknown status.
  • Time Not init: Non-initiated time.
  • Time downtime: Time in scheduled downtime.
  • %OK: Correct status time percentage.
  • Total checks: Total checks done during the time lapse configured in the report.
  • Checks failed: Number of failed checks (critical).
  • Checks OK: Number of correct checks.
  • Checks Unknown: Approximation based on events and Pandora FMS logic that allows to point out the number of checks that should have been carried out, but from which there is no answer.
1.4.4.7 HTML and Text Items
1.4.4.7.1 Text

This item displays a formatted text within the reports to add e.g. more information of the company to the report.

Text report module - item editor tab - reporting builder.png

The fields of this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Text: A text box intended to format the text and add links and images from a remote server.

An example of the window where the link is added is shown below.

Edit link - report builder.png

Screenshot example of the window where to add the image:

Edit image - report builder.png

You may add any html content to this element.

Report view example:

Html text sample.png



1.4.4.7.2 Import text from an URL

This item shows the text retrieved from an external server to which the Pandora FMS Console has access to. In the HTML report format, it will be displayed as it is, but the PDF version of the report will show the text in plain-text format.

Import text from URL - item editor tab - reporting builder.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • URL: The text field intended to enter the external server address in order to extract the text.
1.4.4.8 Alert Items
1.4.4.8.1 Alert Report Agent

It displays a list containing the alerts triggered by the report group agents within a predefined period.

Alert report agent - item editor tab - reporting builder.png

The fields within this form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards based on which the report is generated (e.g. one month from the seleted date).
  • Agent: Intelligent control for selecting the appropriate agent for the item.
  • Label: Label assigned to an element. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Report example:

Pre23.png

1.4.4.8.2 Alert report module

It displays a list containing the module's triggered alerts within a predefined period intended for the report.

Alert report module - item editor tab - reporting builder.png

The fields contained in this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards based on which the report is generated (e.g. one month from the selected date).
  • Agent: Intelligent control to select the appropriate agent for this item.
  • Module: A drop-down list which is dynamically loaded by the agent's modules selected in the previous control.
  • Label: Label the element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.
1.4.4.8.3 Alert report group

It shows a list with the alerts launched in any element of the group defined in the report in the defined period.

ReportGroupAlert.png



The following fields are to be configured:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Time lapse: Time range taken backwards based on which the report is generated (e.g. one month from the chosen date).
  • Group: Group on which the alert triggering information will be analysed.
  • Recursion: Analyze the child groups of the recursively defined group.

ReportGroupAlertExample.png

1.4.4.9 Event Items
1.4.4.9.1 Event Report Agent

It shows a list containing the events that took place within the agents in the predefined time frame.

Event report agent - item editor tab - reporting builder.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards based on which the report is generated (e.g. one month from the chosen date).
  • Agent: Intelligent control to select the appropriate agent for this item.
  • Severity, event type, event status: Selecct the types of events to see.
  • Event graphs: Show event summary graphs.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Report view example:

Pre27.png

1.4.4.9.2 Event Report Module

It displays a list containing the events that took place within an agent's module in the report of a predefined time frame.

Event report module - item editor tab - reporting builder.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards based on which the report is generated (e.g. one month from the selected date).
  • Agent: Intelligent control to select the appropriate agent for the item.
  • Module: Drop-down list that is dynamically loaded with the agent's modules selected in the control above.
  • Severity, event type, event status: Select the type of events to see.
  • Event graphs: Show event summary graphs.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.

Report view example:

Report module events sample.png

1.4.4.9.3 Event Report Group

It displays a list containing the events which took place in the report group's agents within a predefined time frame.

Event-report-group-from.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Period: The time frame taken backwards based on which the report is generated (e.g. one month from the selected date).
  • Group: Combo intended to select the group.
  • Severity, event type, event status: Select the type of events to see.
  • Event graphs: Show event summary graphs.ç

Within the HTML version of the report, an this type of item is generated:

Event-report-group-result.png

1.4.4.10 Inventory Items
1.4.4.10.1 Inventory

This item can be found in the Enterprise version of Pandora FMS. It displays the selected inventory from one or several hosts belonging to a specific date or its last known data.

Inventory item form.png

The fields that belong to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Description: Text field intended for the item's description.
  • Group: Combo that filters the agents that appear within the next field. It does not appear in the report, it is only a form tool.
  • Agents: The agents of the machines the inventory is taken from. Only the agents with inventory modules will appear in this field.
  • Modules: The common inventory modules of the selected agents.
  • Date: The date of the displayed data. If the last date is selected here, only the latest inventory data of the selected modules will be gathered.

Inventory report sample.png

1.4.4.10.2 Inventory changes

This item displays the changes of the inventory registered in one of several hosts within a predefined time frame.

Inventory changes form.png

The fields pertaining to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Description: A text field intended for the item's description.
  • Period: A field to determine the interval for registering the changes.
  • Group: Combo that filters the agents that appear within the next field. It does not appear in the report, it is only a form tool.
  • Agents: Agents of the hosts where the inventory will be gathered. Only the agents containing inventory modules will appear within this field.
  • Modules: The common inventory modules of the selected agents.


Info.png

The data for this item are solely provided by inventory changing events. If the item is too big, you may delete some of those events manually to reduce it.

 


Report view example:

Inventory changes report sample.png

1.4.4.11 Configuration Items
1.4.4.11.1 Agent Configuration

This type of report will show a picture of the agent status:

Agent configuration report.png

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.


Display example:

Agent configuration report sample.png



1.4.4.11.2 Group options

This type of report will show a picture of the status of the agents that belong to the selected group:


Group configuration report.png


Display example:

Group configuration report sample.png

1.4.4.12 Netflow Items
1.4.4.12.1 Netflow area chart

This report element will display a graph with the traffic analysis using filters already created in Netflow view.


Netflow area.png


Example of report display:

Netflow area sample.png



1.4.4.12.2 Netflow pie chart

This element shows a pie chart with the results of applying the filter indicated by the user.

Netflow pie.png


Example of report display:

Netflow pie sample.png



1.4.4.12.3 Netflow data chart

This element shows the data obtained by applying the filter indicated by the user in a table sorted by date and origin.

Netflow datachart.png


Example of report display:

Netflow datachart sample.png



1.4.4.12.4 Netflow statistics chart

This report item will display a table with the grouped value of the traffic, using filters already created in the Netflow view.

Netflow statistics.png


Example of report display:

Netflow statistics sample.png



1.4.4.12.5 Netflow summary chart

This report item will display a table with summarized traffic information that matches the Netflow filter specified in the Filter parameter.

Netflow summary.png


Example of report display:

Netflow summary sample.png

1.4.4.13 Log Items
1.4.4.13.1 Log Report

This report type displays the log entries in the selected period.

Log report build.png

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Search: Text string to be searched.
  • Log number: Maximum number of log block entries to be shown when generating this report.
  • Time lapse: The time range taken backwards based on which the report will be drawn up (e.g. one month from the chosen date).
  • Source: Log source.
  • Agents: Filtering agents.


Example of report display:

Log report.png

1.4.4.14 Network items
1.4.4.14.1 Network traffic Top N

This report shows a top-N of network consumption in the last X days of all IP analyzed by Pandora NTA:


Network traffic topN.png

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Time lapse: the time range taken backwards based on which the report will be drawn up (e.g. one month from the chosen date).
  • Quantity(n): Number of elements to be shown.

Pandora NTA sample report 1.png

1.4.5 General wizard

This tab allows to automatically create a complete report with just a few clicks. By applying common configurations you may generate alements applied to multiple agents and/or modiles. This is an Enterprise feature.

Once the type, the period, the agents and the modules have been selected, click on 'Add' and it will generate as many items as agents or modules have been selected for the report.

Wizard-tab-reporting builder.png

The fields belonging to this particular form are the following:

  • Name: The following macros can be used:
    • _agent_ : Name of the agent selected in report item.
    • _agentdescription_ : Description of the agent selected in report item.
    • _agentgroup_ : Group of the agent selected in report item.
    • _address_ : Address of the agent selected in report item.
    • _module_ : NAme od the agent module selected in report item.
    • _moduledescription_ : Description of the module selected in report item.
  • Type: A drop-down list where you may select the mass-generated type of item. Certain item types that require more detailed configuration are excluded. The available item types within this form are: Alert Report Agent, Alert Report Module, AVG Module, Event Report Agent, Event Report Module, Monitor Report, Simple Graph and Availability
  • Time interval: Time interval based on which the report is created (from the present moment).
  • Filter Group: A field intended to filter agents by group.
  • Agents: Multi selector with the list of available agents for the user.
  • Modules: Multi selector with the list of modules common to the selected ahents.
  • Elements to apply: Selected module list. Report items will be added to the elements of this list.
  • Label: Label an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.
  • Name: Name an element can be assigned. The following macros can be used: _agent_, _agentdescription_, _agentgroup_, _address_, _module_, _moduledescription_.
  • Time lapse: The time range taken backwards based on which the report will be drawn up (e.g. one month from the chosen date).

Report view example (availability):

Wizard report availability sample.png



1.4.6 The SLA Wizard Tab

This wizard allows to create SLA report items automatically.

You may choose different SLA analyses:

  • SLA: It displays a standard SLA reporting element, indicating the % of compliance in the selected period.
  • Monthly SLA: It will show a day by day analysis of the selected month, indicating the compliance %.
  • Weekly SLA: It will show an analysis of the compliance % week by week, indicating at all times the daily value.
  • Hourly SLA: It will display an hourly analysis of the selected period.
  • Availability graph: A graph will be generated with the availability data of the selected modules.
  • SLA services: A new reporting element representing the calculation of the SLAs of the selected services will be created.


You will be able to choose the validity value ranges of the modules to be selected. This feature will allow you to check the % of time that a module has maintained values within specific ranges.

If you do not define thresholds, they will be dynamically adjusted to the criticality thresholds of each module.


Other options can be found:

  • Time lapse: This is the range, or period of time over which the report renders the information for this report type. For example, a week means data from a week ago from now.
  • Show graph: Only basic SLA. It allows to choose whether to display a table with the data, a graph, or both.

Wizard sla skel.png


Example of report display:

Report avail1.png



1.4.7 Global

This section is where Exception, General or Top N elements can be easily created thanks to a wizard.

  • Exception: This shows values of several modules that meet a logical operation.
  • General: It shows values of several modules ordered (upward, downward, by agent name) or/and grouped by name.
  • Top N: It shows N values sorted out by maximun, minimun or average over the total of modules selected, ordered upward, downward or by agent name.

That way you may add different modules from different agents, while you can also choose the operation to be performed in each module: addition, average, min and max.

Global2.jpg


Example of report view:

Wizard global sample.png

1.4.8 Report advanced options

This report advanced configuration tab allows to edit some of its visual aspects such as:

  • Customize font.
  • Select a logo to use in the headers of the PDF files.
  • Edit the header and footer of each page.
  • Edit the report's cover.

Advance options-tab-reporting builder.png

  • Family font: The default font is Times New Roman. If you want to customize the font type, select the desired one from the drop-down list.

Note: This list is built on the basis of the 'ttf' files found in the directory:

/var/www/html/pandora_console/enterprise/include/mpdf50b/ttfonts

You may add font files in TTF format to that directory. They must have the correct permissions for the user that provides the web service to have access to thos files. By default apache:apache in CentOS based systems. Pandora FMS includes the "code" fotn that displays all existing characters in UTF8.

  • Custom Logo: pandora_logo.jpg is used by default. You may select from the drop-down list any of the possible logos to decorate the header of each PDF page.

Note: This list is built based on the image files found at the following directory:

/var/www/html/pandora_console/images/custom_logo/

You may add the image files to that directory. They must have the correct permissions for the user that provides the web service to have access tp those files. By default apache:apache in CentOS based systems.

  • Header: It is a rich text editor where to copy and paste formatted text from an office application or edit on site. This text will be displayed at each page's header.
  • First Page: Another rich text edit field, but in this case it allows to thedit the PDF cover page.
  • Footer: Rich text edit field where to edit the PDF footers.
1.4.8.1 Macros

To re-use edition templates, use the following macros:

  • (_DATETIME_): It is replaced by the date when the report is generated. The format is that configures in Pandora FMS console general options.
  • (_REPORT_NAME_): It isreplaced by the report's name.
  • (_TIMEFROM_): It is replaced by the start date specified in the report.

1.4.9 The Preview Tab

This tab displays the report as it is when generated in HTML format to be able to easily look at the results. It is displayed exactly as a user would see it in the report section.

1.5 Viewing a report

Check the report list through Reporting > Custom Reporting.

Report menu.png

In this section you can see the created reports or create new.

Report list.png

Reports can be displayed in HTML, XML, CSV or PDF formats.

Through this view, you may also send by email. For that purpose, indicate the tardet address where to receive the report in PDF format. If you need to send it to several addresses, indicate the different addresses separated by commas:

Send email.png

In order to see the report in the HTML format, click on the Pre46.png icon.

A programmed view will always be generated for the report. You may select other time frmase once the report is generated in HTML.

Pre47.png

In order to see a report in the XML format, click on the Pre48.pngicon.

Pre49.png



In order to see a report in PDF format, click on the Pre50.pngicon.

Pre51.png

1.6 Automatic report scheduling

The Pandora FMS Enterprise version includes the CRON extension. This extension allows to program different types of actions to be executed with a configurable periodicity.

Among the multiple options it offers, it allows to configure the sending of reports in PDF format through e-mails.

We will find this feature in the menu entry Servers > Cron Jobs.


Cron menu.png


1.6.1 Automatic sending of a report by e-mail

To send a report via email on a scheduled basis, use the console extension Enterprise CRON with the following options:

Task
Select send custom report by e-mail. It will allow you to program the generation and sending of an already existing report.
Scheduled
In this field specify the frequency with which the report will be sent.
First Execution
In this field establish the date and time of the first execution.
Report build
In this field select the report you want to send.
Send to mail
This field contains the e-mail address to which the report will be sent.

Pre52.png

Once the data has been filled in, click on create and the task will appear in the list of scheduled tasks.

Pre53.png


Once the task has been created, it is possible to force its execution by clicking on the circular icon to the left of the scheduled task. You may also edit or delete the scheduled task using the buttons on the right.




1.6.2 Application and sending of report template by e-mail

To apply a template and send the result via email on a scheduled basis, use the console extension enterprise CRON with the following options:

Task
Select Send custom report (from template) by e-mail: It will allow to apply a report template about agents od your choosing and schedule their creation and sending.
Scheduled
In this field we will specify the frequency with which the report will be sent.
Next Execution
In this field establish the date and time of the next execution.
Template to build
In this field,, select the template of the report you want to generate.
Agents
Select the agents on which to apply the template.
Send to mail
This field contains the e-mail address to which the report will be sent.

Cron report template.png



1.6.3 Configuration

For the email sending to work, it must be previously configured in Pandora FMS options.

To edit this configuration, go to Configuration > Setup > Enterprise.

Menu config enterprise.png

You will need to configure the email section at the bottom of the page correctly:

Menu config enterprise mail.png

2 Report Templates

2.1 Introduction

Report templates are components which allow to parametrize report creation. It also allows to apply them onto a set of agents and to easily create a lot of independent reports on different agent groups.

Each template element will look for matches with an agent and/or module through a regular expression or sub-string, making this system really trustworthy.

Templates1.png

As it can be seen on the previous image, a report template will be created, containing elements or items. These defined elements are report items that could be defined for a report. The difference is that each of this template items will generate one or more report items as long as when applying the template, it matches some agent/module of those chosen in said application.

The following section describes a report template practical example, with three template item examples.

2.2 Examples

In order to access the report template go to 'Reporting' > 'Custom Reports' and click on the 'list templates' button:

Report menu.png

Click on the Templates tab:

List templates.png


There you may see the complete list of templates defined in Pandora FMS console.



Template main.png



In this example the template contains three template items:

  • An automated combined graph which allows to create graphs on the modules that match within the application.
  • A 'Top N' report.
  • An agent event report.

Templates list items1.jpeg

2.3 Example 1: Automated Combined Graph

Creating combined graphs is an option within Reporting > Custom graphs which enables generating visual reports made of as many modules as needed.

This section allows defining a name for the graphic and other data such as frequency, graphic type or the weight of each of the modules.

Combinedgraph1.png

Combinedgraph2.png

Combinedgraph3.png

Combined graphs enable establishing the order of each individual module by means of the “sort” option, featured in the option list.

Combinedgraph5.png

The result of combined graphs clearly differences data from the selected different modules.

Combinedgraph4.png

In the following example, combined graphs will be created for every agent whose module name is equal to "Disk Read Latency" and "Disk Write Latency".

Once the combined graphs are created, they will be added to the generated report.

Template automatic graph.png

Along this example, the target modules have been chosen, but the modules could also be selected through a regular expression, filling out the Modules to match (Free text) field. For example, the regular expression *cpu.* would be applied on modules such as: cpu_user, total_cpu_usage, cpu, etc.

One of the available options is adding a dynamic label to the future report item. In this field, predefined macros will be able to be used to identify the item that will be generated. This is very useful when printing in PDF, since the report item that is searched in the menu can be certainly identified. Another important field of the form for this kind of model item is create a graph for each agent. Once activated, it will enable creating a combined graph for each agent. If disabled, the system will combine all data in a single combinated graph, where information about all matching agents and modules will be added.

2.4 Example 2: Top N

This item will generate a report of the 'Top N' type, showing the highest 10 CPU usage values of the last day. This item applies to all agents with modules which contain the literal "CPU User" element.

Template topn.png

As shown in the image, the modules will not be searched literally, but a regular expression will be used here. This performance is selected by clicking on the verification checkbox next to the agent's name ('exact match'). If left blank, the agent's name will match on all agents selected during template application.

2.5 Example 3: Agent Events

This element will generate a report of the events generated on the last day for all selected agents.

Template agentevent.png

As you can see in the Agent field, the regular expression ".*" has been used. It symbolizes any alphanumeric string, so it will be applied on any selected agent.

2.6 Applying a template

Once all the needed template items are defined, apply or instantiate this template through two methods:

2.6.1 Direct application

A template report can be applied and viewed by clicking on any of the format icons that appear on the same row of the template:

Template direct.png

A pop-up will be shown, where the agents on which this report template will be applied may be chosen:

Template direct2.png

2.6.2 Template wizard

Use the Template Wizard if you need to instantiate your report template in a real report to have it available in the Pandora FMS report list.


Template application.png


Activate the checkbox Create report per agent if you want to generate a report for each selected agent. If you do not activate it, a general report will be generated with all the information.

  • If a report is generated by an agent, the title of the report shall be as follows: [template title] - [agent name] ([agent name])
  • In the event that a full report is generated, the title shall be as follows: [report title] - agents ([number of agentes]) - [date]


Template application1.png

2.6.3 Examples

A "custom_graph" type element was created for the automatic combined graph. This graph has two elements for the modules "Read Disk Latency" and "Write Disk Latency".



Template application custom graph1.png



Editing the custom graph, you can see that it has both modules:



Template application custom graph.png



For the Top N report, an element was created with an expression based on the cpu text.

Template topn.png

Displaying the rendered report shows the ten most loaded CPUs:




Template application top n1.png



Three elements will be created for the agent event report (remember that all agents were selected using .*):



Template application eventagent.png

2.7 Editing the template

Within the template, you may modify the general parameters of the template as shown on the picture below.

Template general.png

2.8 Template list

In order to access the template list, click on Reporting > Custom reports:

Report menu.png

Once there, click on Templates:

List templates.png

In that page you may see the full list of defined templates in Pandora FMS console.

Template main.png

2.9 Item List

In this item list section, you may see and edit items created within a report template and modify their order besides deleting them.

Template list item.png

2.10 Item Editor

This item editor section was designed to create new template items.

The item types are the same as in the report section, but with two differences: when applying it to an agent or module, this must be searched as a regular expression. For instance, oracle_agent[.]* can match agent names oracle_agent_1, oracle_agent_2, etc.


If you left blank, this template item would be applied onto all selected agents when applying the report template.

Applying a template

When a module is specified, this can be literally interpreted, activating the verification checkbox Module exact match. If disabled, it will use the regular expression standard match method.


Template agentevent.png

2.11 Advanced Options

Within this section, you may edit visual aspects for the resulting report like fonts, logos, headers, the first page or the report footer as done with a standard report.

Template advance.png

2.12 Report Cleaning

To delete reports created in previous applications from a template from the Wizard, you can select a template and click on the delete button (broom button).

Template wizard cleanup.png



This action will automatically delete all reports created based on this template.

Go back to Pandora FMS Documentation Index