Reporting

This section describes the Reporting function which is used to generate reports that help overview your network environment to define objects, monitor the system and plan workloads.

This section covers the following topics:

• Report Types

• Viewing the Report Status List

• Generating or Regenerating Online Reports

• Viewing Report Properties and Deleting a Report

• Fields and Columns: Reporting

• Determination Date for Report Data

• Report Output Options

• Using Reports with Bar Charts

• Using Reports with Monitor Task Time Tables

• User Restrictions for Reports

• Retention Period for Reports from Entire Operations GUI Client

• Examples of Reports

• Generating Batch Reports

Related Topic:

• See also the cross-reference reports described in the section Cross-References.

Report Types

The report types available you can select from the Reporting dialog are described in the following table. Reports that require special user privileges are indicated in the table.

Viewing the Report Status List

To view all reports submitted for processing

1. In the object workspace, select the General node and choose Reporting from the context menu.

   Or:
   In the Command box, type REPORTS (see Direct Commands) and press ENTER.

   A Reporting window similar to the example below opens:

   

   A list of scheduled and ready reports appears.

   (If no reports exist, the table in the Reporting window is empty.)

   The reports listed in the table are used to manage and view all reports requested by the current user. Report generation is invoked within Entire Operations GUI Client whereas the reports themselves are generated asynchronously in the background via the Entire Operations Monitor.

   The report list contains the following columns:

   Creation time	Date and time when a report generation was initiated arranged in descending order (latest date first).
   Report type	Report type requested.
   Status	Indicates the progress in generating the report:     Queued Report is queued for processing. A report is queued, for example, if it must wait until the Entire Operations Monitor has finished another task before it can handle the report generation (asynchronous processing). This allows you to continue working while the report is processed in the background.     Running Report is being generated.     Completed Report has been generated successfully.     Aborted Report has been aborted. A probable reason for abortion is: No report data found for processing An inactive Entire Operations Monitor A system error
   Properties	Properties settings used to generate the report.

   Press F5 or choose Refresh or Auto Refresh (specifies an automatic refresh interval) from the context menu to refresh the processing status in the Status column.

2. From the table in the Reporting window, you can select the report you want to generate by choosing Save as File from the context menu to determine the file to be created from the report: see Report Output Options.

Generating or Regenerating Online Reports

This section provides instructions for generating or regenerating a report in online mode with the Reporting function.

Report data is evaluated for the current day by default. If you want to change the evaluation date, use the Determination Date function.

To generate a report

1. From the table in the Reporting window, select Add from the context menu.

   A Reporting dialog similar to the following opens:

   

2. From the drop-down list box next to Report type, select the required report type.

   Depending on the report type selected, additional input fields appear in the Preselection section of the Reporting dialog. They are explained in Fields and Columns: Reports.

3. In the Preselection section, enter the required selection criteria and output options.

   In the Completed message to E-mail field, enter an e-mail address if you want to send a notification when the report generation has finished.

4. Choose OK when you are finished.

   The report is added to the table in the Reporting window and queued for processing.

   If you choose Cancel, the selected report type and selection criteria are retained in the Reporting dialog until you open it again and choose OK.

5. When the report has been processed successfully, the Status in the Reporting window changes to Completed.

   You can then save the report as described in Report Output Options.

To regenerate a report

1. From the table in the Reporting window, select a generated report and choose Regenerate from the context menu.

   A Reporting dialog opens with the properties settings of the previous report generation.

   If required, change the current settings by replacing the values in the Preselection section and the Completed message to Email field of the dialog. The fields are explained in Fields and Columns: Reports.

2. Choose OK.

   The report is added to the table and queued for processing.

   The same applies as stated for generating a report.

Viewing Report Properties and Deleting a Report

To display the properties of a report

• Select the required report from the table in the Reporting window and choose Properties from the context menu.

  A Reporting dialog similar to the example below appears where the properties (report type, owner, network and e-mail) are displayed:

  

To delete single or multiple reports

• From the table in the Reporting window, select one or more generated reports and choose Delete from the context menu or press DELETE.

  The selected reports are removed from the table.

Fields and Columns: Reporting

The input fields for specifying selection criteria and output options for the report to be produced are explained in the following table. The input fields correspond to the columns contained in the report output file.

Depending on the report type (to be) produced, the following fields and columns are available:

%% EOR0303 - times - Begin
0m0.121s 0m0.025s
0m0.043s 0m0.066s
%% EOR0304 - times - End

Range Specification and Usage Restrictions

If indicated in the table above, you can use an asterisk (*) or a smaller/greater than (< or >) wildcard character to determine a start or an end value (see also Valid Name Specifications in Direct Commands) or open a selection list of names.

The use of asterisk/wildcard report selection can be disallowed for non-administrator users (see User Definitions and Profile Settings in the Administration documentation).

By default, users of type A (system administrator) and O (operator) are allowed to use asterisk/wildcard selection; users of type G (general user) are not. It is not possible to disallow it for users of type A.

Determination Date for Report Data

Report data is evaluated for the current day by default. This evaluation date needs to be considered, in particular, when you maintain different versions of networks and symbol tables with either fix versions or versions dynamically loaded on this date.

The determination date can also affect named filters that use the selection criterion (current): see Filtering Objects and Changes to the Determination Date.

You can specify the date for which a report (or a named filter with (current)) evaluates the data to be generated.

To set the determination date

1. Select the General node.

2. Open the context menu and select Determination Date.

   A Determination Date window similar to the example below opens:

   

3. Open the drop-down list box and select the required date from a calendar.

   Or:
   Type the required date in the input box.

4. Choose OK to save the date.

Report Output Options

The Save as File dialog specifies the format for the report and the location where the report is written.

%LOCALAPPDATA%\Software AG\Natural\

The settings in the Save as File dialog are stored between sessions in a client-specific XML profile and are used as the default value for the next Save as File operation on a report of the same report type.

Using Reports with Bar Charts

The report types Network Start Overview (Bar Chart), Network and Job Start Overview (Bar Chart) and Network Schedule Overview (Bar Chart) generate the usual report columns but additionally provide an interactive diagram with a bar chart for better data visualization.

Bar charts of the report types visualize report column data as an interactive diagram. Bar charts are useful for overviewing the job flow and finding out the peak and off-peak times to balance the workload (CPU load) among the different networks.

Bar charts reports are not static but have interactive elements which are described in the following section:

• Filter Area

• Diagram Part

Filter Area

You can collapse the filter area by clicking on the arrow:

Depending on the diagram columns you select, different columns of the report are shown:

Diagram Part

If you select part of the time table as shown below,

the diagram is zoomed in so you can view more details:

If you move the mouse over the marker, you can view further information such as start and/or end times:

If you move the mouse over a bar, you can view additional information about the given network:

Using Reports with Monitor Task Time Tables

The report types Monitor Tasks and Functions Overview and Monitor Tasks and Exits Overview provide an interactive diagram with a bar chart and features to filter information as described in the following section.

• Filter Area

• Diagram Part

Filter Area

You can unmark or mark the items to deselect or select the items to be shown in the diagram.

You can choose Clear All or Select All to deselect or select all items marked in the Tasks, Exits and/or Functions rows.

Diagram Part

If you select part of the time table as shown below,

the diagram

is zoomed in so you can view more details:

If you move the mouse over the top of a bar graph in the diagram, you can view additional information such as the execution time, average execution time and the number of calls, for example:

User Restrictions for Reports

Administrator users (and reports run in batch) may report on any network in any owner. Non-administrator users, however, will only receive information on networks to which they have read access. A user is considered to have read access if:

1. The user is linked to owner SYSDBA.

2. The user is linked to the network owner.

3. Access to the network has been explicitly granted to the user.

User authorization for performing report functions are granted in the default user profile as described in Reporting Functions in the Administration documentation.

Retention Period for Reports from Entire Operations GUI Client

Data generated for a report from Entire Operations GUI Client is retained for the number of days specified for active jobs in the Retention Periods of the Entire Operations default settings (see Defaults for Time Ranges in the Administration documentation).

Older reports listed in the Reporting window of Entire Operations GUI Client are automatically removed after this period or during the next database cleanup (see also the Administration documentation).

Examples of Reports

This section contains examples of all types of reports you can generate with the Reporting function:

• Example of Log - Terminated Jobs

• Example of Log - Abended Jobs

• Example of Log - Jobs not started

• Example of Log - Jobs with permanent errors

• Example of Log – Networks not activated

• Example of Accounting Information

• Example of Network Description (short)

• Example of Network Description (detailed)

• Example of Schedule of Jobs

• Example of Network Start Summary

• Example of Network Schedule Overview

• Example of Activation Overview

• Example of Compare Symbol Tables

• Example of Compare Networks

• Example of Node Overview

• Example of Network/Job Usage

• Example of Network Start Overview (Bar Chart)

• Example of Network and Job Start Overview (Bar Chart)

• Example of Network Schedule Overview (Bar Chart)

• Example of Monitor Tasks and Exits Overview

• Example of Monitor Tasks and Functions Overview

Example of Log - Terminated Jobs

The following is an example of the report type Log - Terminated Jobs:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Log - Abended Jobs

The following is an example of the report type Log - Abended Jobs:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Log - Jobs not started

The following is an example of the report type Log - Jobs not started:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Log - Jobs with permanent errors

The following is an example of the report type Log - Jobs with permanent errors:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Log – Networks not activated

The following is an example of a Log – Networks not activated report:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Accounting Information

The following is an example of the report type Accounting Information:

The columns contained in the report are described under Accounting Information/Schedule of Jobs reports only in Fields and Columns: Reports.

Example of Network Description (short)

The following is an example of the report type Network Description (short):

The fields contained in the report are described in Fields and Columns: Reports.

Example of Network Description (detailed)

Example of Schedule of Jobs

The following is an example of the report type Schedule of Jobs:

The columns contained in the report are described under Accounting Information/Schedule of Jobs reports only in Fields and Columns: Reports.

Example of Network Start Summary

The following is an example of the report type Network Start Summary:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Network Schedule Overview

The following is an example of the report type Network Schedule Overview:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Activation Overview

The following is an example of the report type Activation Overview:

The columns contained in the report are described in Fields and Columns: Reports.

Example of Compare Symbol Tables

The following is an example of the report type Compare Symbol Tables:

Columns: Compare Symbol Tables

The columns contained in the report are described under Compare Networks/Symbol Tables reports only in Fields and Columns: Reports.

Example of Compare Networks

The following is an example of the report type Compare Networks:

Columns: Compare Networks

The columns contained in the report are described under Compare Networks/Symbol Tables reports only in Fields and Columns: Reports.

Example of Node Overview

The following is an example of the report type Node Overview:

The columns contained in the report are described under Node Overview reports only in Fields and Columns: Reports.

Example of Network/Job Usage

The following is an example of the report type Network/Job Usage:

The columns contained in the report are described under Network/Job Usage reports only in Fields and Columns: Reports.

Example of Network Start Overview (Bar Chart)

The following is an example of the report type Example of Network Start Overview (Bar Chart):

The columns contained in the report are described under Bar Chart reports only in Fields and Columns: Reports.

See also the section Using Reports with Bar Charts for information on how to handle bar charts.

Example of Network and Job Start Overview (Bar Chart)

The following is an example of the report type Network and Job Start Overview (Bar Chart):

The columns contained in the report are described under Bar Chart reports only in Fields and Columns: Reports.

See also the section Using Reports with Bar Charts for information on how to handle bar charts.

Example of Network Schedule Overview (Bar Chart)

The following is an example of the report type Network Schedule Overview (Bar Chart):

The columns contained in the report are described under Bar Chart reports only in Fields and Columns: Reports.

See also the section Using Reports with Bar Charts for information on how to handle bar charts.

Example of Monitor Tasks and Exits Overview

The following is an example of the report type Monitor Tasks and Exits Overview:

See also the section Using Reports with Monitor Task Time Tables for information on how to handle task time tables.

Example of Monitor Tasks and Functions Overview

The following is an example of the report type Monitor Tasks and Functions Overview:

See also the section Using Reports with Monitor Task Time Tables for information on how to handle task time tables.

Generating Batch Reports

You can use the batch command client of Entire Systems Management to generate a report in batch mode: see Commands for the Batch Command Client in the section Using Entire Operations in Batch Mode.