sql_servers_without_elastic_pool

Azure SQL Servers Without Elastic Pools

What It Does

This policy reports any Azure SQL Servers that do not have any elastic pools. Optionally, an email is sent with this report.

Input Parameters

• Email Addresses - Email addresses of the recipients you wish to notify.
• Azure Endpoint - Select the API endpoint to use for Azure. Use default value of management.azure.com unless using Azure China.
• Allow/Deny Subscriptions - Whether to treat Allow/Deny Subscriptions List parameter as allow or deny list. Has no effect if Allow/Deny Subscriptions List is left empty.
• Allow/Deny Subscriptions List - Filter results by subscription ID/name, either only allowing this list or denying it depending on how the above parameter is set. Leave blank to consider all the subscriptions.
• Allow/Deny Regions - Whether to treat Allow/Deny Regions List parameter as allow or deny list. Has no effect if Allow/Deny Regions List is left empty.
• Allow/Deny Regions List - Filter results by region, either only allowing this list or denying it depending on how the above parameter is set. Leave blank to consider all the regions.
• Exclusion Tags - The policy will filter resources containing the specified tags from the results. The following formats are supported:
  • Key - Filter all resources with the specified tag key.
  • Key==Value - Filter all resources with the specified tag key:value pair.
  • Key!=Value - Filter all resources missing the specified tag key:value pair. This will also filter all resources missing the specified tag key.
  • Key=~/Regex/ - Filter all resources where the value for the specified key matches the specified regex string.
  • Key!~/Regex/ - Filter all resources where the value for the specified key does not match the specified regex string. This will also filter all resources missing the specified tag key.
• Exclusion Tags: Any / All - Whether to filter instances containing any of the specified tags or only those that contain all of them. Only applicable if more than one value is entered in the Exclusion Tags field.

Policy Actions

• Send an email report

Prerequisites

This Policy Template uses Credentials for authenticating to datasources -- 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 Flexera Org Admin and ask them to register a Credential that is compatible with this policy. The information below should be consulted when creating the credential(s).

• Azure Resource Manager Credential (provider=azure_rm) which has the following permissions:

  • Microsoft.Sql/servers/read

• Flexera Credential (provider=flexera) which has the following roles:

  • billing_center_viewer

The Provider-Specific Credentials page in the docs has detailed instructions for setting up Credentials for the most common providers.

Supported Clouds

• Azure

Cost

This policy template does not incur any cloud costs.