Query: Get user details of each group membership

Description

This query is useful for identifying the users associated with each group membership in a specific identity store. It is particularly beneficial for managing user access rights and understanding the composition of each group within your AWS Identity Store.

Query

Tables used in this query:

• aws_identitystore_group_membership

SQL