Filter a list

Filtering a list

When you choose a list in the left-hand pane of the RM Management Console, the contents of the list are displayed in the right-hand pane. You can filter a list by entering filter criteria in one or more of the fields at the top of each list column.

If a list column contains options defined by the RM Management Console (for example, whether or not a package is available for assignment), you can select an option to filter on from the drop-down list at the top of the column. Otherwise, you can type text appropriate to the contents of the list column, for example part of a computer name.

Filtering on text strings

Type the text you want to filter on, and the list will update to show the matches for that text. You can also include AND and OR and NOT to refine your filter further. For example:

To filter the All Groups list so that it only shows security groups related to servers, type server in the field above the Name column.
To filter the All Packages list so that it only shows Microsoft .NET packages, type Microsoft AND Net in the field above the Name column.
To filter the All Users list so that it only shows users with the first name Andy or Andrew, type Andy OR Andrew in the field above the First Name column.

To filter the All Groups list so that it does not show security groups related to servers, type * NOT server in the field above the Name column. You can also type another filter string instead of the * character.

Filtering on numbers

Type the number you want to filter on. If you type 6, the list will update to show matches only for the number 6, not 66 or 126.

You can also use the following operators to filter numbers:

< Returns a filtered list containing all numbers up to the specified number. For example, <6 returns all matches up to 5.
<= Returns a filtered list containing all numbers up to and including the specified number. For example, <=10 returns all matches up to 10.
> Returns a filtered list containing all numbers greater than the specified number. For example, >10 returns all matches from 11 upwards.
>= Returns a filtered list containing all numbers including and greater than the specified number. For example, >=12 returns all matches from 12 upwards.

These operators can also be combined. For example, entering >4 <12 would return all numbers between, but not including, 4 and 12.

You can also include decimals in filter criteria, for example 4.5.

Filtering on dates

The following criteria apply to filtering on dates and times:

To filter on a year, enter the full four digits of the year (for example, 2007).
To filter on a month and year, enter the details using the month number or abbreviated name, and the full or abbreviated year, separated by a forward slash, a space, or a hyphen. For example, 10/2007, 10-2007, 10-07, Oct-2007, Oct 2007, Oct-07.
To filter on specific dates, you can enter the day, month and year in the same formats as for the month and year. For example, 12-Feb-07, 12/02/2007, 12 Feb 2007.
If you filter on a specific date, you can also include a time in the format hh:mm. For example, 15/11/07 12:00.
You can also use the < and > operators for all date filters.