Skip to main content

members

Creates, updates, deletes, gets or lists a members resource.

Overview

Namemembers
TypeResource
Idazure.fleet.members

Fields

NameDatatypeDescription
cluster_resource_idtextfield from the properties object
e_tagtextfield from the properties object
fleetMemberNametextfield from the properties object
fleetNametextfield from the properties object
grouptextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTfleetMemberName, fleetName, resourceGroupName, subscriptionIdGet a FleetMember
list_by_fleetSELECTfleetName, resourceGroupName, subscriptionIdList FleetMember resources by Fleet
createINSERTfleetMemberName, fleetName, resourceGroupName, subscriptionIdCreate a FleetMember
deleteDELETEfleetMemberName, fleetName, resourceGroupName, subscriptionIdDelete a FleetMember
updateUPDATEfleetMemberName, fleetName, resourceGroupName, subscriptionIdUpdate a FleetMember

SELECT examples

List FleetMember resources by Fleet

SELECT
cluster_resource_id,
e_tag,
fleetMemberName,
fleetName,
group,
provisioning_state,
resourceGroupName,
subscriptionId
FROM azure.fleet.vw_members
WHERE fleetName = '{{ fleetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new members resource.

/*+ create */
INSERT INTO azure.fleet.members (
fleetMemberName,
fleetName,
resourceGroupName,
subscriptionId,
properties
)
SELECT
'{{ fleetMemberName }}',
'{{ fleetName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

UPDATE example

Updates a members resource.

/*+ update */
UPDATE azure.fleet.members
SET
properties = '{{ properties }}'
WHERE
fleetMemberName = '{{ fleetMemberName }}'
AND fleetName = '{{ fleetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified members resource.

/*+ delete */
DELETE FROM azure.fleet.members
WHERE fleetMemberName = '{{ fleetMemberName }}'
AND fleetName = '{{ fleetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';