Download full document:

# about_Analytics_Filtering

TOPIC

XenDesktop - Advanced Dataset Filtering

SHORT DESCRIPTION

Describes the common filtering options for XenDesktop cmdlets.

LONG DESCRIPTION

Some cmdlets operate on large quantities of data and, to reduce the 
overhead of sending all of that data over the network, many of the Get- 
cmdlets support server-side filtering of the results.

The conventional way of filtering results in PowerShell is to pipeline 
them into Where-Object, Select-Object, and Sort-Object, for example:

  Get-<Noun> | Where { $_.Size = 'Small' } | Sort 'Date' | Select -First 10

However, for most XenDesktop cmdlets the data is stored remotely and it 
would be slow and inefficient to retrieve large amounts of data over the 
network and then discard most of it. Instead, many of the Get- cmdlets 
provide filtering parameters that allow results to be processed 
on the server, returning only the required results.

You can filter results by most object properties using parameters 
derived from the property name. You can also sort results or limit them 
to a specified number of records:

  Get-<Noun> -Size 'Small' -SortBy 'Date' -MaxRecordCount 10

You can express more complex filter conditions using a syntax and set of 
operators very similar to those used by PowerShell expressions.

Those cmdlets that support filtering have the following common parameters:

-MaxRecordCount <int> 
    Specifies the maximum number of results to return. 
    For example, to return only the first nine results use:

      Get-<Noun> -MaxRecordCount 9

    If not specified, only the first 250 records are returned, and if more 
    are available, a warning is produced:

    WARNING: Only first 250 records returned. Use -MaxRecordCount to 
    retrieve more.

    You can suppress this warning by using -WarningAction or by specifying 
    a value for -MaxRecordCount.

    To retrieve all records, specify a large number for -MaxRecordCount. 
    As the value is an integer, you can use the following:

      Get-<Noun> -MaxRecordCount [int]::MaxValue

-ReturnTotalRecordCount [<SwitchParameter>] 
    When specified, this causes the cmdlet to output an error record 
    containing the number of records available. This error record is 
    additional information and does not affect the objects written to the 
    output pipeline. For example:

      Get-<Noun> -MaxRecordCount 9 -ReturnTotalRecordCount 
      ....

      Get-<Noun> : Returned 9 of 10 items 
      At line:1 char:18 
      + Get-<Noun> <<<<  -MaxRecordCount 9 -ReturnTotalRecordCount 
      + CategoryInfo          : OperationStopped: (:) [Get-<Noun>], PartialDataException 
      + FullyQualifiedErrorId : PartialData,Citrix.<SDKName>.SDK.Get<Noun>

    The count can be accessed using the TotalAvailableResultCount property:

      $count = $error[0].TotalAvailableResultCount

-Skip <int> 
    Skips the specified number of records before returning results. 
    Also reduces the count returned by -ReturnTotalRecordCount.

-SortBy <string> 
    Sorts the results by the specified list of properties. The list is a 
    set of property names separated by commas, semi-colons, or spaces. 
    Optionally, prefix each name with a + or - to indicate ascending or 
    descending order, respectively. Ascending order is assumed if no 
    prefix is present.

    Sorting occurs before -MaxRecordCount and -Skip parameters are 
    applied. For example, to sort by Name and then by Count (largest first) 
    use:

      -SortBy 'Name,-Count'

    By default, sorting by an enumeration property uses the numeric value 
    of the elements. You can specify a different sort order by qualifying 
    the name with an ordered list of elements or their numeric values, 
    or <null> to indicate the placement of null values. 
    Elements not mentioned are placed at the end in their numeric order. 
    For example, to sort by two different enums and then by the object id:

      -SortBy 'MyState(StateC,<null>,StateA,StateB),Another(0,3,2,1),Id'

-Filter <String> 
    This parameter lets you specify advanced filter expressions, and 
    supports combination of conditions with -and and -or, and grouping 
    with braces. For example:

      Get-<Noun> -Filter 'Name -like "High*" -or (Priority -eq 1 -and Severity -ge 2)'

    The syntax is close enough to PowerShell syntax that you can use 
    script blocks in most cases. This can be easier to read as it reduces 
    quoting:

      Get-<Noun> -Filter { Count -ne $null }

    The full -Filter syntax is provided below.

EXAMPLES

Filtering by strings performs a case-insensitive wildcard match. 
Separate parameters are combined with an implicit -and operator. 
Normal PowerShell quoting rules apply, so you can use single or double 
quotes, and omit the quotes altogether for many strings. The order of 
parameters does not make any difference. The following are equivalent:

  Get-<Noun> -Company Citrix -Product Xen* 
  Get-<Noun> -Company "citrix" -Product '[X]EN*' 
  Get-<Noun> -Product "Xen*" -Company "CITRIX" 
  Get-<Noun> -Filter { Company -eq 'Citrix' -and Product -like 'Xen*' }

See about_Quoting_Rules and about_Wildcards for details about PowerShell 
handling of quotes and wildcards.

To avoid wildcard matching or include quote characters, you can escape 
the wildcards using the normal PowerShell escape mechanisms (see 
about_Escape_Characters), or switch to a filter expression and the -eq 
operator:

  Get-<Noun> -Company "Abc[*]"                 # Matches Abc* 
  Get-<Noun> -Company "Abc`*"                  # Matches Abc* 
  Get-<Noun> -Filter { Company -eq "Abc*" }    # Matches Abc* 
  Get-<Noun> -Filter { Company -eq "A`"B`'C" } # Matches A"B'C

Simple filtering by numbers, booleans, and TimeSpans perform direct 
equality comparisons, although if the value is nullable you can also 
search for null values. Here are some examples:

  Get-<Noun> -Uid 123 
  Get-<Noun> -Enabled $true 
  Get-<Noun> -Duration 1:30:40 
  Get-<Noun> -NullableProperty $null

More comparisons are possible using advanced filtering with -Filter:

  Get-<Noun> -Filter 'Capacity -ge 10gb' 
  Get-<Noun> -Filter 'Age -ge 20 -and Age -lt 40' 
  Get-<Noun> -Filter 'VolumeLevel -like "[123]"' 
  Get-<Noun> -Filter 'Enabled -ne $false' 
  Get-<Noun> -Filter 'NullableProperty -ne $null'

You can check boolean values without an explicit comparison operator, 
and you can also combine them with -not:

  Get-<Noun> -Filter 'Enabled'      # Equivalent to 'Enabled -eq $true' 
  Get-<Noun> -Filter '-not Enabled' # Equivalent to 'Enabled -eq $false'

See about_Comparison_Operators for an explanation of the operators, but 
note that only a subset of PowerShell operators are supported (-eq, -ne, 
-gt, -ge, -lt, -le, -like, -notlike, -in, -notin, -contains, -notcontains).

Enumeration values can either be specified using typed values or the 
string name of the enumeration value:

  Get-<Noun> -Shape [Shapes]::Square 
  Get-<Noun> -Shape Circle

With filter expressions, typed values can be specified with simple 
variables or quoted strings. They also support enumerations with wildcards:

  $s = [Shapes]::Square 
  Get-<Noun> -Filter { Shape -eq $s -or Shape -eq "Circle" } 
  Get-<Noun> -Filter { Shape -like 'C*' }

By their nature, floating point values, DateTime values, and TimeSpan 
values are best suited to relative comparisons rather than just equality. 
DateTime strings are converted using the locale and time zone of the user 
device, but you can use ISO8601 format strings (YYYY-MM-DDThh:mm:ss.sTZD) 
to avoid ambiguity. You can also use standard PowerShell syntax to 
create these values:

  Get-<Noun> -Filter { StartTime -ge "2010-08-23T12:30:00.0Z" } 
  $d = [DateTime]"2010-08-23T12:30:00.0Z" 
  Get-<Noun> -Filter { StartTime -ge $d } 
  $d = (Get-Date).AddDays(-1) 
  Get-<Noun> -Filter { StartTime -ge $d }

Relative times are quite common and, when using filter expressions, 
you can also specify DateTime values using a relative format:

  Get-<Noun> -Filter { StartTime -ge '-2' }         # Two days ago 
  Get-<Noun> -Filter { StartTime -ge '-1:30' }      # Hour and a half ago 
  Get-<Noun> -Filter { StartTime -ge '-0:0:30' }    # 30 seconds ago

ARRAY PROPERTIES When filtering against list or array properties, simple parameters perform a case-insensitive wildcard match against each of the members. With filter expressions, you can use the -contains and -notcontains operators. Unlike PowerShell, these perform wildcard matching on strings. Note that for array properties the naming convention is for the returned property to be plural, but the parameter used to search for any match is singular. The following are equivalent (assuming Users is an array property):

  Get-<Noun> -User Fred* 
  Get-<Noun> -Filter { User -like "Fred*" } 
  Get-<Noun> -Filter { Users -contains "Fred*" }

You can also use the singular form with -Filter to search using other 
operators:

  # Match if any user in the list is called "Frederick" 
  Get-<Noun> -Filter { User -eq "Frederick" } 
  # Match if any user in the list has a name alphabetically below 'F' 
  Get-<Noun> -Filter { User -lt 'F' }

COMPLEX EXPRESSIONS When matching against multiple values, you can use a sequence of comparisons joined with -or operators, or you can use -in and -notin:

  Get-<Noun> -Filter { Shape -eq 'Circle' -or Shape -eq 'Square' } 
  $shapes = 'Circle','Square' 
  Get-<Noun> -Filter { Shape -in $shapes } 
  $sides = 1..4 
  Get-<Noun> -Filter { Sides -notin $sides }

Braces can be used to group complex expressions, and override the default 
left-to-right evaluation of -and and -or. You can also use -not to invert 
the sense of any sub-expression:

  Get-<Noun> -Filter { Size -gt 4 -or (Color -eq 'Blue' -and Shape -eq 'Circle') } 
  Get-<Noun> -Filter { Sides -lt 5 -and -not (Color -eq 'Blue' -and Shape -eq 'Circle') }

PAGING The simplest way to page through data is to use the -Skip and -MaxRecordCount parameters. So, to read the first three pages of data with 10 records per page, use:

  Get-<Noun> -Skip 0  -MaxRecordCount 10 <other filtering criteria> 
  Get-<Noun> -Skip 10 -MaxRecordCount 10 <other filtering criteria> 
  Get-<Noun> -Skip 20 -MaxRecordCount 10 <other filtering criteria>

You must include the same filtering criteria on each call, and 
ensure that the data is sorted consistently.

The above approach is often acceptable, but as each call performs an 
independent query, data changes can result in records being skipped or 
appearing twice. One approach to improve this is to sort by a unique id 
field and then start the search for the next page at the unique id after 
the last unique id of the previous page. For example:

  # Get the first page 
  Get-<Noun> -MaxRecordCount 10 -SortBy SerialNumber

  SerialNumber  ... 
  ------------  --- 
  A120004 
  A120007 
  ... 7 other records ... 
  A120900

  # Get the next page 
  Get-<Noun> -MaxRecordCount 10 -Filter { FirstName -gt 'A120900' }

  SerialNumber  ... 
  ------------  --- 
  A120901 
  B220000 
  ...

FILTER SYNTAX DEFINITION

<Filter>        ::= <ScriptBlock> | <ComponentList>

<ScriptBlock>   ::= "{" <ComponentList> "}"

<ComponentList> ::= <Component> <AndOrOperator> <ComponentList> | 
                    <Component>

<Component>     ::= <NotOperator> <Factor> | 
                    <Factor>

<Factor>        ::= "(" <ComponentList> ")" | 
                    <PropertyName> <ComparisonOperator> <Value> | 
                    <PropertyName>

<AndOrOperator> ::= "-and" | "-or"

<NotOperator>   ::= "-not" | "!"

<ComparisonOperator> 
                ::= "-eq" | "-ne" | "-le" | "-ge" | "-lt" | "-gt" | 
                    "-like" | "-notlike" | "-contains" | "-notcontains" | 
                    "-in" | "-notin"

<PropertyName>  ::= <simple name of property>

<Value>         ::= <string literal>  | <numeric literal> | 
                    <scalar variable> | <array variable>  | 
                    "$null" | "$true" | "$false"

Numeric literals support decimal and hexadecimal literals, with optional 
multiplier suffixes (kb, mb, gb, tb, pb).

Dates and times can be specified as string literals. The current culture 
determines what formats are accepted. To avoid any ambiguity, use strings 
formatted to the ISO8601 standard. If not specified, the current time zone 
is used.

Relative date-time string literals are also supported, using a minus sign 
followed by a TimeSpan. For example, "-1:30" means 1 hour and 30 minutes 
ago.