Skip to main content

server_usages

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

Overview

Nameserver_usages
TypeResource
Idazure.sql.server_usages

Fields

NameDatatypeDescription
namestringName of the server usage metric.
currentValuenumberThe current value of the metric.
displayNamestringThe metric display name.
limitnumberThe current limit of the metric.
nextResetTimestringThe next reset time for the metric (ISO8601 format).
resourceNamestringThe name of the resource.
unitstringThe units of the metric.

Methods

NameAccessible byRequired ParamsDescription
list_by_serverSELECTresourceGroupName, serverName, subscriptionIdReturns server usages.

SELECT examples

Returns server usages.

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