member_accounts
Creates, updates, deletes, gets or lists a member_accounts resource.
Overview
| Name | member_accounts |
| Type | Resource |
| Id | aws.notifications.member_accounts |
Fields
The following fields are returned by SELECT queries:
- list_member_accounts
| Name | Datatype | Description |
|---|---|---|
account_id | string | The AWS account ID of the member account. (pattern: <code>\d{12}</code>) |
notification_configuration_arn | string | The Amazon Resource Name (ARN) of the notification configuration associated with the member account. (pattern: <code>arn:aws:notifications::[0-9]{12}:configuration/[a-z0-9]{27}</code>) |
organizational_unit_id | string | The unique identifier of the organizational unit containing the member account. (pattern: <code>(Root|r-[0-9a-z]{4,32}|ou-[0-9a-z]{4,32}-[a-z0-9]{8,32})</code>) |
status | string | The current status of the member account. (ACTIVE, PENDING, INACTIVE, CREATING, DELETING) |
status_reason | string | The reason for the current status of the member account. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list_member_accounts | select | notificationConfigurationArn, region | maxResults, nextToken, memberAccount, status, organizationalUnitId | Returns a list of member accounts associated with a notification configuration. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
notificationConfigurationArn | string | The Amazon Resource Name (ARN) of the notification configuration used to filter the member accounts. |
region | string | AWS region (default: us-east-1) |
maxResults | integer | The maximum number of results to return in a single call. Valid values are 1-100. |
memberAccount | string | The member account identifier used to filter the results. |
nextToken | string | The token for the next page of results. Use the value returned in the previous response. |
organizationalUnitId | string | The organizational unit ID used to filter the member accounts. |
status | string | The status used to filter the member accounts. |
SELECT examples
- list_member_accounts
Returns a list of member accounts associated with a notification configuration.
SELECT
account_id,
notification_configuration_arn,
organizational_unit_id,
status,
status_reason
FROM aws.notifications.member_accounts
WHERE notificationConfigurationArn = '{{ notificationConfigurationArn }}' -- required
AND region = '{{ region }}' -- required
AND maxResults = '{{ maxResults }}'
AND nextToken = '{{ nextToken }}'
AND memberAccount = '{{ memberAccount }}'
AND status = '{{ status }}'
AND organizationalUnitId = '{{ organizationalUnitId }}'
;