NetVault 13.0.2 - Administration Guide

Setting filters for report

When you run a canned report that includes any filter conditions, the Set filters for report dialog box is displayed. You can set one or more conditions, based on which the reporting system generates the output. For each filter field that you want to use, you must select the filter operator and specify the comparison value. For example, the following Set filters for report dialog box is displayed for the report- Data Stored By Client.

Figure 30. Set filters for report dialog box

To set report filters:

In the operator list corresponding to the filter field, select the comparison operator. You can use the following comparison operators: =, !=, >, <, >= or <=.

In the associated box, type the comparison value. The value must match the data type of the field.

Fields can be of the following types: date, integer, string, or time.

To specify date values, you can use the following formats:

•

YYYY/MM/DD

•

YYYYMMDD

•

Relative date: TODAY-n[time variable]

You can use the following time variables: YE = Year, MO = Month, WE = Week, DA = Date, HO = Hour, MI = Minute, and SE = Second

Example: TODAY-7DA

To specify time values, you can use the following formats:

•

HH:MM:SS

•

HHMMSS

•

Relative time: NOW-n[timevaribale] or TODAY-n[time variable]

You can use the following time variables: YE = Year, MO = Month, WE = Week, DA = Date, HO =

Hour, MI = Minute, and SE = Second.

Example: NOW-12HO

Some reports may also include the following filter options:

•

State: You can select this check box to compare the field state as opposed to the value it contains. The field state comparison option is designed for advanced users who have a good understanding of the NetVault reporting system.

You can set the field status to one of the following values:

•

•

•

•

•

For example, you can specify the state Unknown to find or exclude records that are not available in one of the tables.

•

Regexp: You can select this check box to match a regular expression instead of a constant value. The expression can contain text and wildcard characters.

•

As above: The As above check box is shown when the same filter field is applied to multiple report components. You can select this check box to use the same comparison value that is configured for the preceding field.

After setting the filters, click OK to close the dialog box.

Editing report job definitions

You can edit a report job definition to modify the report schedule or configure user‑defined events for the report. NetVault lets you distribute the generated reports by email or print the reports through the notification system.

To edit a report job:

In the Navigation pane, click View Reports.

On the View Reports page, select the report that you want to edit, and click Edit Report.

On the Edit Report Job Definition page, configure the following options.

Table 108. Edit report job definition
Option	Description
Schedule	You can use this option to run the report at specified times. The scheduling option is useful for generating reports on a regular basis. To configure a report schedule, select an existing Schedule Set, or click Create New, and specify the schedule type and schedule method. For more information, see Creating Schedule Sets. For scheduled events, make sure that you specify the user-defined event in the Report Completed Event and Report Failure Event field.
Report Completed Event	Specify the event that you want to raise when the job completes successfully.
Report Failure Event	Specify the event that you want to raise when the job fails.


	NOTE: Report events are only raised if you specify a report schedule or use the Run & Notify method.

Click Save, and in the Save Report Job dialog box, click OK.

When you save the job, the configured events are added to the Report Job event class. You can use the global notification methods or user notification profiles to receive event notifications when the report is generated. For more information, see Using notification methods to send reports by email or print reports.

Using notification methods to send reports by email or print reports

You can configure user-defined events for a report job and receive notifications when a job completes successfully or fails. NetVault adds these events to the Report Job event class. You can use this feature to send reports by email or to send the reports to a designated printer.

Depending on whether you want to distribute the report by email or print the report, do the following:

•

To send the report to the Administrator, set up the Sysop E-mail notification method. For more information, see Setting up a global notification method. By default, the report is generated in PDF file format and delivered as an email attachment.

•

To send the report to other users, set up the notification profiles for the users. For more information, see Setting up user notification profile. By default, the report is generated in PDF file format and delivered as an email attachment.

•

To print the report, set up the Print a report notification method. For more information, see Setting up a global notification method.

Customizing table views for reports

After a report is generated, you can modify the table views to include or exclude columns, change the column order, and add column totals and other aggregate values. You can add multiple table views for a component. The reporting system lets you save these settings to the job definition so that the custom format is used every time you run the report.

To customize table views for reports:

Access the report that you want to customize. For instructions on generating a report, see Generating reports.

In the report window, click the Settings link at the upper-right corner of the table. If the report contains multiple components, click the link associated with the table that you want to modify.

In the Table Settings dialog box, the available columns are listed. The columns that have the corresponding Show check box selected are included in the table view. For example, the following Table Settings dialog box is displayed for the report- Data Stored By Client.

Figure 31. Table Settings dialog box

You can make the following modifications:

•

Hide columns: To hide one or more columns, clear the check marks for those columns.

•

Show columns: To show hidden columns, click the corresponding Show check boxes.

•

Display aggregate values: To add fields that display the total, minimum, maximum, and other aggregate values for the columns, select the field type in the Aggregate list. This list is only displayed for columns that contain numeric values.

The available options include the following:

•

Total: Displays the sum of all the values in the column.

•

Average: Displays the average value of all the values in the column.

•

Min: Displays the maximum value of all values in the column.

•

Max: Displays the minimum value of all values in the column.

•

Count: Displays the count of records.

•