This policy checks all Azure SQL Servers to ensure that they have an AD (Active Directory) Admin configured. An incident is raised with the offending SQL Servers if any are found that don't.
The Azure Resource Manager API is used to get a list of subscriptions and SQL Servers within those subscriptions. The policy then queries the "administrators" endpoint for each SQL Server to make sure it is not an empty set and contains a list of AD Admins.
This policy has the following input parameters required when launching the policy.
- Email addresses to notify - Email addresses of the recipients you wish to notify when new incidents are created
- Azure Endpoint - Azure Endpoint to access resources
This policy uses credentials for connecting to the cloud -- in order to apply this policy you must have a credential registered in the system that is compatible with this policy. If there are no credentials listed when you apply the policy, please contact your cloud admin and ask them to register a credential that is compatible with this policy. The information below should be consulted when creating the credential.
For administrators creating and managing credentials to use with this policy, the following information is needed:
Provider tag values to match this policy: azure_rm
Required permissions in the provider:
- Microsoft.Resources/subscriptions/read
- Microsoft.Sql/servers/read
- Microsoft.Sql/servers/administrators/read
- Azure Resource Manager
This Policy Template does not incur any cloud costs.