Setting the Automatic License Assigning

In this dialog you can set a filter narrowing the set of computers to which the license will be assigned.
The filter is set using the conditions in SQL language syntax and it has to have the following form:

[@ObjectKind] | [@ObjectName] | [@ObjectPath] | [<object property name>]<operator><value>

[@ObjectKind] – Object kind
[@ObjectName] – Object name in the tree
[@ObjectPath] – Path in the tree (entered as: object1/object2/...)
[<object property name>] – the name of any object property (even inherited)

<operator> – you can use the following SQL operators:

= - equal to
!=,<> - not equal to
IN – specifies whether the entered value is found in subquery/list
LIKE – comparing strings with an option to use simple regular expressions
NOT – operator negation - in relation to other operator (IN, LIKE)
IS NULL – the value is NULL – e.g. the object has no specific property

<value> – N'string' where the N prefix specifies that the string is in Unicode

Note:

Value comparison may be case-sensitive.
Conditions can be combined using the AND and OR operators.

Filter examples:

[@ObjectKind] = N'Computer/Server'
Assigns the license only to "Computer/Server" type computers.
[@ObjectPath] LIKE N'Organization/Liverpool%'
The license is assigned only in a specific section of the tree according to the path in the tree.
[Subsidiary] IN (N'London',N'Liverpool')
Only assigns to computers located in the specific subsidiaries.
ISNULL([Subsidiary],'') != N'Manchester'
Assigns to all computers not located in the Manchester subsidiary. Note: If the ISNULL function was not used, the computers not located in any subsidiary would not be included.
[Subsidiary] IS NULL
Only assigns to computers not located in any subsidiary.
[Location] NOT IN (N'IT warehouse',N'Central warehouse') AND [Person responsible for software]=N'PC software managers'
An example of a filter composed of several conditions – computers not located in the specific warehouses and, at the same time, the "PC software managers" group being responsible for the software installed in the computers.
[Location] NOT LIKE N'Warehouse%'
All computers where the value of the "Location" property does not begin with "Warehouse".

Did not find what you were looking for? Ask our technical support team.