Intelligent group examples
This topic provides examples of the kinds of intelligent groups that you can create to back up SQL Server assets.
In the following example, the intelligent group is applied to any instances where one of the following conditions applies.
Cluster type | Equal to | Windows Server Failover Cluster (WSFC) |
Host name | Equal to | instance-cluster-name |
The query string with OData keywords and operators is: (tolower(clusterType) eq tolower('WSFC') or tolower(clientName) eq tolower('instance-cluster-name'))
In the following example, the intelligent group is applied to any availability groups one of the following criteria applies.
Cluster type | Equal to | Windows Server Failover Cluster (WSFC) |
Host name | Equal to | cluster-name |
Availability group ID | Equal to | 01234567-89ab-0123-4567-89abcdef0123 |
Availability group name | Equal to | ag-name |
The query string with OData keywords and operators is: (tolower(clusterType) eq tolower('WSFC') or tolower(clientName) eq tolower('cluster-name') or availabilityGroup/groupId eq 01234567-89ab-0123-4567-89abcdef0123 or tolower(agName) eq tolower('ag-name'))
In the following example, the intelligent group locates any databases that are not part of an availability group and adds them to the group.
Availability group name | Equal to | <empty> |
The query string with OData keywords and operators is: Availability Group name Equal to <empty> (tolower(agName) eq tolower(")).
In the following example, the intelligent group finds any non-AG databases that are not part of an availability group and adds them to the group.
Availability group name | Not equal to | <empty> |
The query string with OData keywords and operators is: Availability Group name Not equal <empty> (tolower(agName) eq tolower(")).