Table Find Examples

The criteria in this example will find cells whose AvgDiskBytes/Write value is at or above 5,000 and that were written on first day of the month ( Return a subset of the string in the formula is set to start at the fourth character in the time stamp, so it will find 06/01/09 and 10/01/09 but not 06/13/09).
ColumnType
AvgDiskBytes/Write>= 5,000 
Timestamp== 4,01 
The criteria in this example were written for the table in the EIB Change Log workspace to find entries that have been updated and that have "Disk" somewhere in the name. ( Return a subset of the string and Scan for string within a string are described in STR and SCAN.)
ColumnType
Table Name== IDDefSituation 
Operation== Update 
Object NameSCAN== 'Disk' 
Most special characters are processed correctly in the find function. If you attempt to find text that includes a special character and it is not found, but you know it exists in your environment, precede the character with the \ backslash escape character. In this example, the user is searching through Temporary Storage Queues for a Queue ID of #ETC. This is how it is entered in the Value cell:
ColumnType
QueueID== '\#ETC' 
CICS RegionName