Formats for specifying property values in conditions

Various BLCLI commands enable you to define conditions that contain properties (for example, the addCondition command in the SmartServerGroup namespace). You define these conditions by specifying a left-hand-side (LHS) operand (the property name), an operator, and a right-hand-side (RHS) operand (the property value).

The following table describes how to format the RHS property value for each type of LHS property and operator:

Note

If the LHS property name contains special characters, such as a space or an asterisk (*), enclose it within double quotes.
(Applicable for smart groups) SQL Server does not support case-sensitive operators. Therefore, the operators containing (case sensitive) (for example, contains (case sensitive)) in the Operator column in the following table are not supported.

LHS (propName) type	Operator	RHS (propValue) type	RHS format (example)
String	Equals Does not equal Starts with Does not start with Ends with Does not end with Contains Does not contain Is substring of Is not substring of equals (case sensitive) does not equal (case sensitive) starts with (case sensitive) does not start with (case sensitive) ends with (case sensitive) does not end with (case sensitive) contains (case sensitive) is substring of (case sensitive) does not contain (case sensitive) is not substring of (case sensitive)	String	“propertyValue” String value with up to 2000 characters
String	Is one of Is not one of	List of Strings	“[comma,separated,values]”
String	Matches Does not match	String regular expression	“regexpattern” Regex expressions must be compatible with the Java implementation of regex.
Integer	less than less than or equal to greater than greater than or equal to	Integer	“1”
Integer	Between	Range of integers	“[1-5]”
Decimal	less than less than or equal to greater than greater than or equal to	Decimal	“4.8”
Decimal	Between	Range of decimals	“[1.2-5.5]”
Date	Before After	Date	Java SimpleDateFormat: “MM/dd/yyyy hh:mm:ss” For example: “09/26/2013 18:37:21”
Date	Between	Range of dates	“[MM/dd/yyyy hh:mm:ss -MM/dd/yyyy hh:mm:ss]” For example (on one line): “[09/26/2013 18:37:21 -09/26/2014 18:37:21]”
Date	Older than days Newer than days	Integer	“30”
Boolean	NOT AND OR	Boolean	“true” or “false”
FilePermission ACE RegistryPermission ACE RegistryAudit ACE FileAudit ACE	matches mask does not match mask	FilePermission ACE Mask	“domain\\name AceType [comma,separated,list, of,permissions]” AceTypes can be the following: -Allow -Deny -Successful -Failure -All For example (on one line): “MyACEName Allow [AceNode.TraverseExecute, AceNode.ListRead, AceNode.CreateWrite]”
FilePermission ACE RegistryPermission ACE RegistryAudit ACE FileAudit ACE	Is one of Is not one of	FilePermission ACE RegistryPermission ACE RegistryAudit ACE FileAudit ACE	“domain\\name AceType [+permission,-permission, …]” AceTypes can be the following: -Allow -Deny -Successful -Failure -All A + character before the permission signifies that the value must be set. A - character signifies that the value does not need to be set. Permissions that are to be ignored need not be listed. For example: “*\\Administrator Allow [+AceNode.TraverseExecute, -AceNode.ListRead]”
Unix Permission	has flag does not have flag	Unix Permission Flag	“Group Execute” A Unix Permission Flag is of the enum type (a predefined list of values). Any of its possible values can be given as a string.
Unix Permission	has any flag does not have any flag has all flags has no flags	List of Unix Permission Flags	“[Group Execute,World Read,Owner Write]” Comma separated list of Unix Permission Flag values enclosed in square brackets.
Unix Permission	Equals Does not equal	Unix Permission	“0444” The value is a long number that represents combination of read, write, and execute permissions.
Unix Permission	Is one of Is not one of	List of Unix Permissions	[“0444”, “0766”, “7777”] List of long numbers

Formats for specifying property values in conditions

On this page