Reports

The information to be presented within a report is organized into report elements. There are different types of elements that perform calculations and display information in very different ways.

Although they generally have a very similar configuration form, each type of element will be configured separately. You may have as many type and style items as you need.

Menu Operation → Reporting → Custom reports → Create report. A form will be presented, where the name of the report must be indicated, (Name) and select the group (Group) the report will belong to, and also whether the report is private or not (Write access) with its description (optional).

In the Write access field you will be able to choose the report editing rights:

• Only the group can edit the report: Only the group the report belongs to will be able to edit it.
• Only the user and the admin user can edit the report: Only the author and an administrator user can edit the report.
• The next group can edit the report: If you choose this option, a list will appear where you may choose another group that can also edit the report.

By default the report will be interactive (checked as No in Non-interactive Report). By checking a report as non-interactive, the report can only be sent by email. The options to create a cover page (Generate cover page in PDF render) and an index (Generate index in PDF render) when generating a PDF from the report are also enabled.

Click Save to save. Once done you will have an empty report ready to add elements to it by means of the icons arranged on the edit form.

Version 770 or later: In the List of reports, by clicking on the corresponding icon in the HTML column (except if the report is not interactive), you will be able to see the filters and the report itself on the screen. The report can be added (or removed) to your list of favorite reports by clicking on the star icon next to the report name.

Menu Operation → Reporting → Custom reports → Reports.

In the list of registered reports, for each item, in the Op. column you have the options of:

• Editing.
• Copying.
• Deleting.
• Selecting for mass deletion with the button Delete.

It is the only one available when creating a new report, since the basic data of the report is defined here. Once saved properly, you will have access to the rest of the tabs. These fields are the same for both report creation and editing.

When finished creating or editing, click Update to save the field data.

An overview of all items that make up a report is displayed. Use the Filters subsection to search among the items recorded in the report; for example displaying the Agents list will display the agents recorded in that selected report.

The items in the list will appear following the order in which they will be displayed in the report, this order can be modified in the Sort items subsection (or deleted in the Delete items subsection, see Op. column).

• P.: Position of the elements in the report, this number is also used to operate the sub-sections:
  • Sort items: An item must be checked first in order to be sorted.
  • Delete items: It deletes without the need to check any item, just indicate the position number and whether to delete up or down.
• Columns Type, Agent and Module: Show each value of each item and clicking on the column header allows sorting (Ascendant or Descendent) according to it, see Sort items.
• Op.: It displays buttons to edit or delete each item and, in addition, a checkbox for selecting each item. Clicking the checkbox in the Op. header allows you to check or uncheck all items.

Clicking Item editor will allow you to create a new item for the selected report.

The form is dynamic according to the type of item (Type) to create. If you are editing you may modify all fields except for type.

The fields common to all types are:

• Name: Report name. The following macros can be used:
  • _agent_: Name of the Agent you selected in the report item.
  • _agentdescription_: Description of the Agent you selected in the report item.
  • _agentgroup_: Group of the Agent you selected in the report item.
  • _address_: Address of the Agent you selected in the report item.
  • _module_: Name of the Agent Module you selected in the report item.
  • _moduledescription_: Description of the Agent Module you selected in the report element.
• Show item in landscape format (only PDF): Display the article in landscape format (PDF only).
• Page break at the end of the item (only PDF): Page break at the end of the article (PDF only).

The fields are filled in according to the type of item selected and to save click Create item.

There are different report types:

• Graphs: Reports with multiple types of graphs.
• IPAM: Reports with data taken from the IPAM PFMS IPAM feature.
• SLA: Reports of Service Level Agreement.
• Forecasting: Reports with data prediction.
• Modules: They are focused and oriented to present information from modules directly.
• Grouped: It allows to consolidate different sources of information to be presented.
• Text / HTML: To be able to insert headers, subtitles or report footers.
• Alerts: Everything related to alerts.
• Events: Everything related to events.
• Inventory: Everything related to inventory.
• Configuration: Report with the operating parameters of agents or groups.
• NetFlow: Reports on NetFlow and sFlow.
• Log: It will show the log entries in the selected period.
• Permissions report: It allows you to select users or groups of users and list their names, groups and permissions.
• NCM: It allows to display network changes in the NCM PFMS feature.
• Security hardening: Information aimed at increasing the security of the monitored devices.
• Vulnerabilities: Known security threats of varying degrees of importance.

In addition, in the Global tab you may add several additional report types.

This tab allows you to create a full report automatically and with a few clicks. By applying common configurations, it is possible to generate elements applied to multiple agents and/or modules.

Again this form is dynamic according to the report type chosen in the Type list:

• Graphs.
• Forecasting.
• Modules.
• Grouped.
• Alerts.
• Events.

This wizard allows you to specifically create SLA report items automatically.

• SLA: It will display a standard SLA report item, indicating the percentage of compliance for the selected period. Additional options are also available for monthly, weekly and hourly periods.
• Availability graph: A graph will be generated with the availability data of the selected modules.
• SLA services: A new report element representing the SLA calculation of the selected services will be created.

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

If no thresholds are defined, they will be dynamically adjusted to the criticality thresholds of each module.

In this report section you may create type elements:

• Exception: It displays values from several modules that satisfy a logical operation (field Condition).
• General: It displays values from mutiple modules sorted (ascending or descending, by agent name) and/or grouped by name.
• Top N: It displays N values discriminated by maximum, minimum or average over the total number of modules added, sorted in ascending or descending order or by agent name.

That way you may add different modules from different agents, in addition to being able to choose the operation to be performed in each module: summation, average, minimum, maximum.

Once the parameters have been chosen and the Add button is clicked, a report item containing the selected agents and modules will be created.

By default pandora_log.jpg will be used. You may select from the drop-down list any of the possible logos to decorate the header of each PDF page. This list is built from the image files contained in the directory:

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

You may add the image files to this directory. They must have the correct permissions so that the user with which the web service is provided has access to these files, by default apache:apache.

To reuse editing templates, you may use the following macros in rich text fields:

• (_DATETIME_): It will be replaced by the date of the moment the report is generated, in the date format configured in Pandora FMS Console general options.
• (_REPORT_NAME_): It will be replaced by the name of the report.

This tab displays the report in HTML format, and it is the same as the HTML view option included in the list of registered reports.

Menu Operation → Reporting → Custom reports → icon List of reports.

Reports can be displayed in HTML, XML, PDF, JSON or CSV format by clicking on the corresponding icons for each column and report item.

To send them by e-mail, click on the corresponding icon in the E-mail column and a pop-up form will open where the recipient(s) and optionally a subject field and a message field will be displayed.

See section for importing and exporting in PRD format.

To create scheduled reports use the Operation → Reporting → Custom reports → Custom reports → Schedule menu with the Send custom report by e-mail option from the drop-down list in Task. The interface is the same for creating or editing a scheduled report (except for the Create report or Update schedule button to save an edit).

Automatic report scheduling is also included in the Console tasks.

Some common fields:

1. Scheduled: Periodicity of the task: daily, monthly, etc. or once only (Not scheduled, see next item).
2. Next execution: Next execution of the task, select date in the first field and time in the second field (pop-up menu when clicking on each).
3. Report pending to be created: From the registered reports, select the one to be sent.
4. Report Type: Type of report to be sent (XML, etc.). If you select Send custom report (from template) by email in the Task list, additionally configure:

• Template pending to be created: Custom template for report creation.
• Agents: Agents to include in the report, use Regex agent filter to select agents by means of regular expressions.
• Report per agent: Information of the Agents selected in Agents for the report, if you wish to generate separate reports for each report.

If Save to disk in path is selected, the path to be saved in the report and, optionally, a prefix for the file names must be specified.

Report templates are components that allow parameterizing the creation of reports that can later be applied on a set of agents.

When creating a report template, a number of elements are defined. These defined elements are the same report items that are defined for a report.

Menu Operation → Reporting → Custom Reports and click on the icon List of templates in the upper right corner, right next to the List of reports icon. Then click Create template:

• Group: Group the new staff will belong to.
• Agents to apply: A regular expression, case insensitive, to filter the agents to which the new template will be applied. For example, if you use Network*, the agents named network_agent1 or NetworK CHECK will match when the template is applied.
• Generate cover page in PDF render: To generate a PDF cover page.
• Generate index in PDF render: To generate an index in the rendering or PDF generation.

To save the template when you finish filling in the fields, click Save.

By clicking the icon item editor new items may be created within the screen.

The item types are the same ones as those of reports, except that when applyed to an agent or module, this one will be chosen as a regular expression. For example, oracle_agent.* it may correspond the agents: oracle_agent_1, oracle_agent_2, oracle_agent_producción, etc.

In case of leaving the field empty, the template item may be applied on all agents when applying the report template.

When a module is specified, this one may be literally interpreted by enabling the verification checkbox Module exact match. If not activated, it will use the matching standard method by regular expression.

Menu Operation → Reporting → Custom reports → icon List of templates → button Edit template → icon List items.

In the item list section you may see and edit the items created within the template and modify their order as well as delete them.

Menu Operation → Reporting → Custom reports → icon List of templates → button Edit template → icon Advanced options.

In this section you may configure visual aspects of the resulting report such as font, logo, header, first page or report footer, as you would do with a standard report.

Once you have finished editing the visual aspects, click Update to save the changes.

Menu Operation → Reporting → Custom Reports and click on the List of templates icon.

• From there you will be able to delete a report template through its corresponding trash can icon in the Operations column. You may also select multiple templates and then click the Delete button.
• Similarly by clicking on the Duplicate button of each template you may copy with prefix copy of plus the template name to a new template.
• By clicking on the pencil icon corresponding to each item you may edit the selected template.

Menu Operation → Reporting → Custom reports → icon List of templates. Then in each template there are buttons for each display: HTML, JSON, and so on. Clicking on one of them will open the form Generate a dynamic report which will only bring the consultation written in Agents to apply when the template was created.

• In Filter group and Filter agent, dynamically, it will be possible to filter from the list initially presented in Agents available.
• Click on one or more of the available agents (or select all in Select all) and click the right arrow button to add to the Agents to apply list.
• Conversely you may uncheck agents, use all the fields and buttons until you get the required list of agents.
• Click Generate.

You may make use of the template wizard (Template Wizard) if you need to instantiate a report template in a real report to have it available in Pandora FMS report list:

The Create report per agent check box can be activated to generate a report for each selected agent. If it is not checked, a general report with all information will be generated.

• In case a report is generated per agent, the title of the report will follow this format:
  • [title of the template] - [agent name] ([agent name])
• In case a total report is generated, the title will follow this format:
  • [report title] - agents ([number of agents]) - [date].

The Report template wizard is used to delete reports created in previous applications from a template.

There select a template from the Templates drop-down list and then click on the delete button (broom icon).

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

By means of the “Enterprise ACL System” it is possible to create custom profiles with which you may assign viewing, modification, creation and deletion permissions for reports.

To do this, go to the ACL Enterprise System settings (Management → Profiles → Enterprise ACL setup), select the profile the permissions are to be assigned to from the drop-down list at User profile.

Select Reporting in Section and then add in Section 2 the necessary permissions:

• New custom reports: It allows you to create reports to the selected user profile.
• Edit custom reports: It allows you to edit reports to the selected user profile.
• Remove custom reports: It allows you to delete reports to the selected user profile.

Go back to Pandora FMS documentation index