Query: List assignments with specific provisioning state

Description

Explore the Azure Lighthouse assignments that have a specific provisioning state. This helps in monitoring the status and ensuring that assignments are correctly provisioned.

Query

Tables used in this query:

• azure_lighthouse_assignment

SQL