Skip Navigation LinksALVAO 11.0Index of windows and commandsALVAO Asset Management ConsoleSoftwareLicense registryEditSetting Automatic License Allocation Skip Navigation Links.


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'Software Administrators on computers'
    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 "Software Administrators on Computers" 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.