server_usages

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

Overview

Name	server_usages
Type	Resource
Id	azure.sql.server_usages

Fields

The following fields are returned by SELECT queries:

list_by_server

Name	Datatype	Description
name	string	Name of the server usage metric.
currentValue	number (double)	The current value of the metric.
displayName	string	The metric display name.
limit	number (double)	The current limit of the metric.
nextResetTime	string (date-time)	The next reset time for the metric (ISO8601 format).
resourceName	string	The name of the resource.
unit	string	The units of the metric.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_server	select	subscriptionId, resourceGroupName, serverName		Returns server usages.

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
resourceGroupName	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName	string	The name of the server.
subscriptionId	string	The subscription ID that identifies an Azure subscription.

SELECT examples

list_by_server

Returns server usages.

SELECT
name,
currentValue,
displayName,
limit,
nextResetTime,
resourceName,
unit
FROM azure.sql.server_usages
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
;