Query: Find a specific organizational unit and all its descendants

Description

By filtering OUs based on their path, the query efficiently retrieves information about a specific subset of your organization's structure, which is particularly useful for large organizations with complex hierarchies.

Query

Tables used in this query:

• aws_organizations_organizational_unit

SQL