Chat now with support
サポートとのチャット

Enterprise Reporter 3.2.1 - Report Manager User Guide

Quest Enterprise Reporter Report Manager Introducing the Report Manager Running and Scheduling Reports Creating and Editing Reports Troubleshooting Issues with Enterprise Reporter Appendix: Log Viewer

Parameter Operators

The operators that are available for use depend on the data type of the field you are working with. The following table outlines the operators available.

 

Between

Returns all data between the two values you provide.

For example, if you choose a field that contains text, and search between A and C, it will return all values that start with the letters A, B and C.

String

Number

Date

Contains

Returns all data containing the value you provide. The value can be found anywhere within the field.

For example, if you enter AN, as long as that sequence of letters is found anywhere in the field, the data is returned.

This is a very flexible operator. Many of the operations you can do with Contains can also be done using other operators. It is primarily intended for use with wildcard characters. Wildcard characters must be surrounded by square brackets. Supported characters (for strings only):

Returns all data that matches the combination of text and wildcard characters that you provide. For example:

String

Does not Contain

Returns all data except those containing the value you provide.

For example, if you enter AN, if that sequence of letters is found anywhere in the field, the data is not returned.

You can use wildcard characters in the same manner as Contains.

String

Does not end with

Returns all data except that ending with the value that you provide.

String

Does not start with

Returns all data except that starting with the value that you provide.

String

Ends with

Returns all data that end with the value you provide.

String

Equals

Returns only the data that exactly matches the value you provide. Equals is not case sensitive.

String

Number

GUID

Boolean

Date

Equals with group expansion

Enter an Account Name. Results include the data for the selected account as well as the data for any group of which it is a direct or indirect member.

For example, if an account is a member of Group A and Group A is a member of Group B, the results will include values/data for the account as well as Group A and Group B.

Account Name attribute

Identity unique display name attribute

Excludes

You provide a list of values. Returns all values except those matching your list. This acts as an OR when joining the list you provide—it returns data that does not match any one of the values.

For example, if your Excludes list is Austin, Dallas and Houston, if a field includes any of the values, the data will not be returned.

The Excludes operator also acts like an OR with numbers (integers). For example, use it to exclude NTFS folder level 1 OR folder level 4 OR folder level 5. However, to exclude NTFS folders up to folder level 5, use the operator Less than or equal to.

Supported wildcard characters (for strings only):

Wildcard characters must be surrounded by square brackets. For a full explanation of the use of these wildcard characters, see Contains .

String

Number

Date

Greater or equal to

Returns all data larger than and including the value you provide.

String

Number

Date

Greater than

Returns all data larger than the value you provide.

String

Number

Date

Has a value

Has two possible values: True or False. If you choose True, returns all data where the field is populated. If you choose False, returns all data where the field is empty.

String

Number

Boolean

Date

In the next

Enter a number of days. Returns data with a date range from the date and time you run the report to the number of days in the future that you enter.

For example, if you run the report at 16:30 on December 12, and you enter six days, you will get data with the dates from December 12 at 16:30 to December 18 at 16:30.

Date

In the past

Enter a number of days. Returns data with a date range from the date and time you run the report to the number of days in the past that you enter.

For example, if run the report at 16:30 on December 12, and you enter six days, you will only get data with a date from December 6 at 16:30 to December 12 at 16:30.

Date

Includes

You provide a list of values. Returns all values that match any item on your list. This acts as an OR when joining the list you provide—it returns data that does not match any one of the values.

For example, if your Includes list is Austin, Dallas and Houston, if a field includes any of the values, the data is returned.

The Includes operator also acts like an OR with numbers (integers). For example, use it to include NTFS folder level 1 OR folder level 4 OR folder level 5. However, to include NTFS folders up to folder level 5, use the operator Less than or equal to.

Supported wildcard characters (for strings only):

Wildcard characters must be surrounded by square brackets. For a full explanation of the use of these wildcard characters, see Contains .

String

Number

Date

Less than

Returns all data smaller than the value you provide.

String

Number

Date

Less than or equal to

Returns all data smaller than and including the value you provide.

String

Number

Date

Matches

You select two fields. Returns only the data where the contents of one field is identical to the other field. Matches is not case sensitive.

String

GUID

Not between

Returns all data that is not between the two values you provide.

For example, if you choose a date field, and set the values to not between December 10, 2011 and January 15, 2012, you will get all corresponding data from December 10 and before, and January 15 and after.

You must enter the lower value first, followed by the higher value.

String

Number

Date

Not equals

Returns all data except for the value you provide.

String

Number

Date

Boolean

GUID

Not in the next

Enter a number of days. Returns all data except for the time period from the date and time you run the report to the number of days in the future that you enter.

For example, if you run the report on December 12 at 16:30, and you enter six days, you will get all data except that with a date from December 12 at 16:30 to December 18 at 16:30.

Date

Not in the past

Enter a number of days. Returns data with any date except for the time period from the date and time you run the report to the number of days in the past that you enter.

For example, if you run the report at 16:30 on December 12, and you enter six days, you will get all data except that with a date of December 6 at 16:30 to December 12 at 16:30.

Date

Starts with

Returns all data that starts with the value you provide.

String

Custom Query Data Types

The Enterprise Reporter Report Library contains many reports generated by custom queries. This table outlines the data types used in the Report Library custom queries and the operators supported for each of them. The equals operator returns only data that exactly matches a provided value, so wildcard parameters are not supported for custom query reports in the Report Library. When creating your own custom query reports, the query you write defines whether or not parameters with wildcard characters will be handled.

int

Holds signed 32-bit (4-byte) integers that range in value from -2,147,483,648 through 2,147,483,647. Use int to select the top ‘n’ records to limit the results of a report.

Equals

datetime

Defines a date that is combined with a time of day with fractional seconds that is based on a 24-hour clock. Use datetime to select records modified between two dates.

Equals

nvarchar [(n | max)]

The NVARCHAR data type is variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes.

Equals

table

A special data type that can be used to store a list of nvarchars. Use table to supply multiple values (such as a list of computer names) for a single parameter.

Includes

varchar [(n | max)]

The VARCHAR data type is variable-length string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB).

Equals

Working with Parameters

2
Click Parameters.
3
Click Add.
8
If desired, select Supply a default value, and enter the value.
9
Click OK to close the Edit Report Parameter dialog box.
10
Click OK to close the Edit Report Definition dialog box.
2
Click Parameters, and select the parameter.
3
Click Edit.
4
Make changes as needed, and click OK to close the Edit Report Parameter dialog box.
5
Click OK to close the Edit Report Definition dialog box.
2
Click Parameters, and select the parameter.
3
Click Delete.
4
Click Yes to confirm the deletion.
5
Click OK to close the Edit Report Definition dialog box.
2
Click Parameters.
5
Click OK to close the Edit Report Definition dialog box.
2
Click Parameters.
3
Press CTRL and select the parameters within a group that are to be ungrouped.
4
Click the Ungoup button.
5
Click OK to close the Edit Report Definition dialog box.
2
Click Parameters.
4
Click the AND/OR button to change the operator from AND to OR or vice versa.
5
Click OK to close the Edit Report Definition dialog box.

Some reports support adding a parameter that allows you to expand nested group members and specify how they are displayed in the report. Some reports already contain this parameter which can be edited.

2
Click Fields.
4
Click Parameters.
5
Click Add.
12
Optionally click Add Fields to add more fields for nested group members. For more information on adding fields, see To add more nested group member fields when running a report .
13
Click OK to close the Edit Report Parameter dialog box.
14
Click OK to close the Edit Report Definition dialog box.
2
Click the Parameters tab.
4
Click Edit.
11
Optionally click Add Fields to add more fields for nested group members. For more information on adding fields, see To add more nested group member fields when running a report .
12
Click OK to close the Edit Report Parameter dialog box.
13
Click OK to close the Edit Report Definition dialog box.

Changing the Layout

If you add or remove fields to or from your report and the report has a layout, you will need to verify that the layout is still appropriate. You may also want to modify the layout to suit your own preferences.

If you have date and time fields in the report, you might want to add your local time zone to the report layout. When date and time data is collected, it is stored in local time. When a report is run, the time is expressed in the time zone of the console running the report. For example, if a user in New York City logged on at 4:15 pm, but the report was run in Los Angeles, which is three hours behind, the report will show that user logging in at 1:15 pm.

The Layout is modified using the Report Designer from DevExpress. You may change the layout manually, import a layout from an existing report, or auto-generate a layout. For more information, see Report Designer Tips and Tricks or the Report Designer User Guide (Developer Express), located in the folder where you installed the Quest Enterprise Reporter Report Manager.

1
Click My Reports.
Expand My Reports and select the category containing the report.
4
Select the Layout tab.
5
Click Edit to open the Report Designer.
6
To add any parameter (such as the time zone) to your report, in the Report Designer, click Field List, expand the parameters container, and drag the parameter (for example, TimeZone) to the appropriate location on the report.
For details on using the features of the Report Designer, see Report Designer Tips and Tricks or the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.
8
Optionally, click Show preview to generate a sample of the report to review the edits.
9
Click OK to close the Report Definition dialog box.
1
Click My Reports.
Expand My Reports and select the category containing the report.
4
Select the Layout tab.
5
Click Import layout.
For details on using the features of the Report Designer, see Report Designer Tips and Tricks or the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.
8
Optionally, click Show preview to generate a sample of the report to review the edits.
9
Click OK to close the Report Definition dialog box.
1
Click My Reports.
Expand My Reports and select the category containing the report. In the treeview, select the report you want to edit.
3
4
Click Auto-generate to start the layout wizard.
6
Once you have completed the wizard, click OK to close the Report Definition dialog box.
7
Optionally, click Show preview to generate a sample of the report to review the edits.
関連ドキュメント