subscription_usages

Creates, updates, deletes, gets or lists a subscription_usages resource.

Overview

Name	subscription_usages
Type	Resource
Id	azure.sql.subscription_usages

Fields

The following fields are returned by SELECT queries:

get

Successfully retrieved particular subscription location usage.

Name	Datatype	Description
properties	object	Resource properties.

list_by_location

Successfully retrieved the subscription location usages.

Name	Datatype	Description
properties	object	Resource properties.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	locationName, usageName, subscriptionId		Gets a subscription usage metric.
list_by_location	select	locationName, subscriptionId		Gets all subscription usage metrics in a given location.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
locationName	string	The name of the region where the resource is located.
subscriptionId	string	The subscription ID that identifies an Azure subscription.
usageName	string	Name of usage metric to return.

SELECT examples

get

Gets a subscription usage metric.

SELECT
properties
FROM azure.sql.subscription_usages
WHERE locationName = '{{ locationName }}' -- required
AND usageName = '{{ usageName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

list_by_location

Gets all subscription usage metrics in a given location.

SELECT
properties
FROM azure.sql.subscription_usages
WHERE locationName = '{{ locationName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;