Query builder for intelligent groups reference
You can use the Query builder to create rules to automatically add SQL Server instances to an intelligent group.
OData keywords are indicated for when you build queries for intelligent groups with the NetBackup APIs. The feature displays the query string that contains OData keywords and operators. For example, the query to search for the host names that end with "domain.com" is: endswith(tolower(clientName), tolower('domain.com')).
Table: Query builder options for intelligent groups describes the fields and options for creating intelligent groups with the Query builder.
Table: Query builder options for intelligent groups
Query Builder fields | Description |
|---|---|
AND OR | When you add two or more conditions, you can select a connector to join the rules. |
Field | Select a parameter on which to build the rule. |
Operator | Select an operator. The available operators depend on the parameter that is selected for the Field. |
Value | Specifies a Value for the Field parameter. The Value field can be a list of possible values or a manual entry, depending on the selections that are made in the other fields. |
Field (keywords)
Table: Keywords in the Field dropdown describes the keywords that are available in the Field dropdown. The values for each keyword (in the Value field) are case-insensitive.
Note:
Use OData Field keywords are indicated for when you build queries for intelligent groups with the NetBackup APIs.
Table: Keywords in the Field dropdown
Field keyword | OData field keyword | Description |
|---|---|---|
Availability group ID | availabilityGroup/groupId | The ID of the availability group. Use the format: |
Availability group name | agName | The name of the availability group. |
Cluster name | clusterName | The name of the cluster that the SQL Server is configured in. |
Cluster type | clusterType | The type of the cluster that the SQL Server is configured in. |
Credential name | credentialName | The name of the NetBackup credential. |
Database name | displayName | The name of the SQL Server database. |
Database size | dbSize | The size of the SQL Server database. Enter a whole numeric value, in MB. |
Database state | dbState | The state of the SQL Server database. |
Edition |
| The edition that is associated with the SQL Server version. |
Host name | clientName | The name of the host. This name depends on the SQL Server environment, as follows:
|
Instance name | instanceName | The name of the SQL Server instance. |
Instance cluster name | sqlClusterName | The name of the SQL Server cluster. |
Microsoft SQL Server host name | clientName | The name of the SQL Server host. |
Microsoft SQL Server release | sqlRelease | The release version of SQL Server that is installed on the host. |
Microsoft SQL Server version | sqlVersion | The version of SQL Server that is installed on the host. |
NetBackup version | nbuVersion | The version of NetBackup that is installed on the host. |
SP | sqlServicePack | The service pack of the SQL Server version. |
State | instanceState | The state of the SQL Server instance. |
Operators
Table: Operators in the list describes the operators available in the list. The values for each keyword (in the Value field) are case-insensitive.
Table: Operators in the list
Operator | OData operator | Description |
|---|---|---|
Starts with | startswith | Matches the value in the field when it occurs at the start of a string. For example: If the entry is "box", matches the string "box_car" but not "flatbox". |
Ends with | endswith | Matches the value in the field when it occurs at the end of a string. For example: If the Value entry is "dev", matches the string "01dev" but not "01dev99", "devOP", or "Development_machine". |
Contains | contains | Matches the value in the field wherever that value occurs in the string. For example: If the entry is "dev", matches strings such as "01dev", "01dev99", "devOP", and "Development_machine". |
Equal to | eq | Matches only the value that is specified in the field. For example: If the host name to search for is "SQLtest27", matches the virtual machine names such as SQLTest27 or sqltest27 or sqlTEST27, and so forth. The name SQLtest28 is not matched. |
Not equal | ne | Matches any value that is not equal to the value in the field. |
Less than | lt | Applies only to the field . Matches any value that is less than the specified , according to the UTF-8 collating sequence. |
Less than or equal to | le | Applies only to the field . Matches any value that is less than or equal to the specified , according to the UTF-8 collating sequence. |
Greater than | gt | Applies only to the field . Matches any value that is greater than the specified , according to the UTF-8 collating sequence. |
Greater than or equal to | ge | Applies only to the field . Matches any value that is greater than or equal to the specified , according to the UTF-8 collating sequence. |