ConsolidatedClusterGroup Template

The ClusterGroup spreadsheet uses data from the Cluster spreadsheet and defines groups of servers as well as computers that are members of these groups.

Table 1. Columns included with ConsolidatedClusterGroup templates

Column

Details

ClusterID

Type: big integer. Key

The unique identifier for the imported cluster. This may be a string or an integer and must match a value for the ClusterID in the cluster spreadsheet.

Destination:

ImportedClusterGroup.ClusterExternalID

ClusterGroupID

Type: big integer. Key

The unique identifier for this cluster group. This may be a string or an integer.

Destination:

ImportedClusterGroup.ExternalID

ImportedClusterGroupMember.ClusterGroupExternalID

ClusterGroupName

Type: text (max 128 characters). Nullable

The name of the cluster group. Depending on the value of the ClusterGroupType this will be a group of hosts or virtual machines.

Destination:

ImportedClusterGroup.Name

ClusterGroupType

Type: text (max 128 characters)

The kind of cluster included in the group. The value must be an exact case-insensitive match to one of the permitted values.

Possible values:

  • vMotion Cluster
  • Hyper-V Cluster
  • Host Affinity Group
  • VM Affinity Group
  • Oracle VM
  • Kubernetes Cluster

Destination:

ImportedClusterGroup.ClusterTypeID

ComputerID

Type: big integer. Key

The identifier used in the ‘Computer’ spreadsheet for a computer which is a member of the group. To identify all the members of the group, repeat as many lines as required in your spreadsheet where the other values in the row are identical, and only the ‘ComputerID’ value changes. Values in this column must match a ComputerID in the computer spreadsheet or the row will be skipped.

Destination:

ImportedClusterGroupMember.ComputerExternalID