Advanced Filtering

Advanced filtering lets you design complex searches to isolate data to just those values you want. Enter filter strings into the same edit fields you enter filter text.

IMPORTANT  You must enter a space character to separate the operator from the data in a filter entry. For example, the filter entry >= 500 includes a space character just after the equal sign.

Advanced filtering supports the following operations:

White Space

To search for white space in a string, include an asterisk for white space.

For example: Microsoft*Office OR Adobe*

Nested operators

All equations are processed from left to right. Use parenthesis to override these defaults.

For example: (("* adobe " OR *a*) AND *c*) OR NOT *d* AND < m

AND

Use the logical AND operator to search for data that must contain multiple values but can appear in different places in the string.

For example: Microsoft* AND *Office*  returns all items that contain both Microsoft and Office in any order.

OR

Use the logical OR operator to search for data that may contain multiple values but must contain at least one.

For example: *Microsoft* OR *MS* returns all items that contain either Microsoft and MS in any order.

NOT

Search for a string not containing the match data.

For example: NOT *Microsoft*   returns all non-Microsoft applications.

For example: NOT *Windows* AND NOT *update* returns all items that do not contain either the strings Windows or update.

<, <= (Less than or less than or equal to)

Performs a string comparison to return all data whose value is less than the entered value.

For example:   < G*  returns all applications starting with a letter less than G.

For example: < 3 returns the values 2, 21 and 287.

NOTE   Dates may also be tested for but must be in the following format: YYYYMMDD HH:MM:SS where YYYY is a four digit year, MM is a two digit month (01 to 12), DD is a two digit day (01 - 31), HH is a two digit hour (00 - 23), MM is a two digit minute (00 - 59), and SS is a two digit second (00 - 59). HH:MM:SS is optional. Date and time are separated with a space.

For example:    < 20040607 07:00:00  or < "20040607 07:00:00" returns all dates earlier than 7:00 on 7 June 2004. Ensure a space exists after the < operator.

>, >= (Greater than or greater than or equal to)

Performs a string comparison to return all data whose value is more than the entered value.

For example:  > G*  returns all applications starting with a letter greater than G.

For example: > 3 returns the value 3, 3abc and 30.129.101.76.

Agent Ver

Returns all machines using a specified agent version. For example, agent version 6.2.1.1 is specified as 6020101