Combining Conditions

You can combine conditions with the relational operators AND, OR, and NOT:

Conditions	Examples
Files Accessed Since 1 January 2003 and Larger Than 2 MB	To select all the files that have been accessed since 1 January 2003 and that are larger than 2 MB, enter the following: FILE_LAST_ACCESS_DATE > 1/1/2003 AND FILE_SIZE > 2MB
Files Belonging to JASON or JANET	To select all the files that belong to JASON or JANET, enter the following: FILE_OWNER_NAME="JASON" OR FILE_OWNER_NAME="JANET"

Conditions

Examples

Files Accessed Since 1 January 2003 and Larger Than 2 MB

To select all the files that have been accessed since 1 January 2003 and that are larger than 2 MB, enter the following:

FILE_LAST_ACCESS_DATE > 1/1/2003

AND FILE_SIZE > 2MB

Files Belonging to JASON or JANET

To select all the files that belong to JASON or JANET, enter the following:

FILE_OWNER_NAME="JASON"
OR FILE_OWNER_NAME="JANET"

You can combine conditions with the logical operators AND, OR, and NOT:

Conditions	Examples
TSM Servers With Average Transfer Rate Higher Than 3000 bps and Less Than 10 Failed Objects	To select all the TSM servers that have an average transfer rate higher than 3000 bps and that have less than 10 failed objects, enter the following: TSM_SERVER_AVERAGE_XFER_RATE > 3000 AND TSM_SERVER_OBJECTS_FAILED < 10

Conditions

Examples

TSM Servers With Average Transfer Rate Higher Than 3000 bps and Less Than 10 Failed Objects

To select all the TSM servers that have an average transfer rate higher than 3000 bps and that have less than 10 failed objects, enter the following:

TSM_SERVER_AVERAGE_XFER_RATE > 3000
AND TSM_SERVER_OBJECTS_FAILED < 10