Setting Automatic License Allocation
In this dialog, you can set a filter to narrow the set of computers to which the license will be assigned.
The filter is set using SQL syntax conditions and must have the following format:
[@ObjectKind] | [@ObjectName] | [@ObjectPath] | [<object property name>]<operator><value>
[@ObjectKind] - object kind
[@ObjectName] - Name of the object in the tree
[@ObjectPath] - Path in the tree (entered as: object1/object2/...)
[<object property name>] - Name of any object property (even inherited)
<operator> - The following SQL operators can be used:
- = - equals
- !=,<> - does not equal
- IN - determines whether the specified value is in the subquery/list
- LIKE - string comparison with the possibility of using simple regular expressions
- NOT - operator negation - concatenation with another operator (IN, LIKE)
- IS NULL - the value is NULL - e.g. the object does not have a specific property
<value> - N'string', where the prefix N specifies that the string is in Unicode encoding
Note:
Comparing values can be case sensitive.
Conditions can be combined using AND and OR operators.
Filter examples:
- [@ObjectKind] = N'Computer/Server'
License assignment only to computers of type "Computer/Server".
- [@ObjectPath] LIKE N'Organization/Brno%'
License assignment only in a specific part of the tree, according to the path in the tree.
- [Branch] IN (N'Praha',N'Brno')
Add only to computers that are in specific branches.
- ISNULL([Branch],'') != N'Ostrava'
Add to all computers that are not in the Ostrava branch. Note:
If the ISNULL function was not used, computers that are not in any branch would not be included.
- [Branch] IS NULL
Only allocate to computers that are not on any branch.
- [Location] NOT IN (N'IT Warehouse',N'Central Warehouse') AND [Software Responsible]=N'PC software managers'
Example of a filter composed of multiple conditions - computers that are not in specific warehouses AND the software on the computer is the responsibility of the "PC software managers" group.
- [Location] NOT LIKE N'Stock%'
All computers where the value of the "Location" property does not begin with the word "Warehouse".
Did not find what you were looking for? Ask our technical support team.