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


Change Alvao version
Change language

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.