Archive Criteria Tab, Report Request Editor

Use the Archive Criteria tab to provide criteria for a list of Archive Directory entries. This list is typically used to review Archive Files for which the retention period is about to lapse before they are deleted.

If needed, you can extend the retention period using the Archive Directory Entry Information dialog. See Update Directory Entry for more information. You can also generate lists to evaluate usage of Storage Profiles, Optim™ Servers, or backup devices for maintenance purposes.

The Archive Criteria tab is available only if you select Archive Directory as the Report Type on the General tab.

Archive Criteria tab of the Report Request Editor

The elements of the Archive Criteria tab are described as follows.

Combine all criteria with

Option for combining criteria:

AND
An Archive Directory entry must match all criteria.
OR
An Archive Directory entry must match one or more criteria.

All entries that match any criteria for a single criteria type are selected, regardless of the Combine all criteria with setting.

Variable Delimiter

Character used to separate multiple criteria for a type. To change the delimiter, click the down arrow.

Criteria grid

Use the grid to provide criteria for Archive Directory entries to be listed in the report or leave the grid blank to report on all entries. The report lists entries in the order in which matching Criteria are selected on the Archive Criteria tab. Click a Criteria grid cell to select a criteria type and enter one or more Values for each criteria type, using the Value Delimiter to separate multiple values. You can select the Sort Ascending check box to list Archive Directory Entries that match the criteria for the Criteria type in ascending order or clear the check box to list entries in descending order. Criteria types and values that you can enter as criteria are as follows:

Server
Optim Server(s) for Archive File(s) associated with Directory entries in report. Possible values are:
blank, (Local), or (None)
Archive Files reside on the local Optim Server.
servername
Name or pattern for one or more Optim Servers.
Group
Group name(s) for Archive File(s) associated with Directory entries in report. Possible values are:
blank or (None)
Entries with no specified group name.
groupname
1 to 8-character name or pattern.
Filename
Archive File(s) associated with Directory entries to be listed. Possible values are:
filename
Explicit path and name or pattern for Archive File.
Creator
Creator ID(s) under which the Archive File(s) associated with Directory entries in report were created. Possible values are:
creatorid
1 to 26-character name or pattern.
Creation Date Range
Date range in which Archive File(s) associated with Directory entries in report were created. Separate start and end dates with the Variable Delimiter and enclose in parentheses.

Assuming a comma as the Variable Delimiter, the date range is in the format: (startdate, enddate).

startdate
Date (in the format MM/DD/YYYY) after which the Directory entry was created. (Required)
enddate
Date (in the format MM/DD/YYYY) before which the Directory entry was created. (Required)
Retention Date Range
Date range in which Archive File(s) associated with Directory entries in report are to be deleted. Separate start and end dates with the Variable Delimiter and enclose in parentheses.

Assuming a comma as the Variable Delimiter, the date range is in the format: (startdate, enddate).

startdate
Date (in the format MM/DD/YYYY or as a number of days from 1 to 9132) after which the Archive File is to be deleted.
enddate
Date (in the format MM/DD/YYYY or as a number of days from 1 to 9132) before which the Archive File is to be deleted.
blank
Archive Files with no retention policy.
Storage Profile
Storage Profile criteria for Archive File(s) associated with Directory entries in report. Possible values are:
blank or (None)
Entries that do not reference a Storage Profile.
profilename
Name or pattern for the Storage Profile.
Backup Device
Backup device criteria for Archive File(s) associated with Directory entries in report. Possible values are:
blank or (No Device)
Archive Files that are not saved to a backup device.
Centera
Archive Files saved to Centera.
EMC NetWorker
Archive Files saved to EMC NetWorker.
IBM® Tivoli®
Archive Files saved to IBM Tivoli.
Description
Description for Archive File(s) associated with Directory entries in report.
blank or (None)
Entries that do not have a description.
description
Name or pattern of the description.
Table Name
Names of table(s) in Archive File(s) associated with Directory entries in report. Possible values are:
tablename
Name or pattern for the table name. (Required)
Litigation Hold
Litigation Hold status for Archive Files stored on Centera. Values are:
Yes
Archive Files with Litigation Hold value of Yes.
No
Archive Files with Litigation Hold value of No.
%
Use the percent (%) wildcard to include Archive Files with any of the following values for Litigation Hold:
Yes
The value is Yes.
No
The value is No.
Unavailable
Attempt to connect to Centera failed or the Archive File entry is invalid.
(None)
Archive File is not stored on Centera and the archive criteria are combined with OR.
Centera Advanced Retention Management is not licensed
Centera is not licensed for Advanced Retention Management and archive criteria are combined with OR.
Delete Hold
Delete Hold status for Archive Files stored on an Optim Server. Values are:
Yes
Archive Files with Delete Hold value of Yes.
No
Archive Files with Delete Hold value of No.
%
Use the percent (%) wildcard to include Archive Files with any of the following values for Delete Hold:
Yes
Archive Files with Delete Hold value of Yes.
No
Archive Files with Delete Hold value of No.
None
Archive Files with no specification for Delete Hold.

Sort Ascending

The report lists Archive Directory entries in the order in which matching Criteria are selected on the Archive Criteria tab. Select the Sort Ascending check box to list Archive Directory Entries that match the criteria for the Criteria type in ascending order or clear the check box to list entries in descending order.

Shortcut Menu

To clear an entry, right-click a row to display the shortcut menu and select Remove. Select Remove All to clear all criteria.

Edit Criteria Values

The Edit Criteria dialog provides additional space to help you more easily define values for a single criteria type.

Click the browse button to open the Edit Criteria dialog. The Edit Criteria allows you to:

  • Enter multiple criteria values on individual rows.
  • Select dates from a calendar utility.
  • Select Backup Devices from a list of available devices.
Note: You can use the % (percent) wild card to represent one or more characters or use the _ (underscore) wild card to represent a single character. (The underscore must be selected as an SQL LIKE character on the General tab of Personal Options.)
Edit Criteria dialog with a list of servers

If the Criteria type is Backup Device, the Edit Criteria dialog displays a list of available backup devices.

Edit Criteria dialog with a list of backup devices (Centera, NetWorker, and Tivoli)