subscription_usages

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

Overview

Name	subscription_usages
Type	Resource
Id	azure.sql.subscription_usages

Fields

vw_subscription_usages

Name	Datatype	Description
current_value	text	field from the properties object
display_name	text	field from the properties object
limit	text	field from the properties object
locationName	text	field from the properties object
subscriptionId	text	field from the properties object
unit	text	field from the properties object
usageName	text	field from the properties object

subscription_usages

Name	Datatype	Description
properties	object	Properties of a subscription usage.

Methods

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

SELECT examples

Gets all subscription usage metrics in a given location.

vw_subscription_usages

SELECT
current_value,
display_name,
limit,
locationName,
subscriptionId,
unit,
usageName
FROM azure.sql.vw_subscription_usages
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';

subscription_usages

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