Skip to main content

server_operations

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

Overview

Nameserver_operations
TypeResource
Idazure.sql.server_operations

Fields

The following fields are returned by SELECT queries:

The request for getting server operations has been executed successfully.

NameDatatypeDescription
propertiesobjectResource properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_by_serverselectresourceGroupName, serverName, subscriptionIdGets a list of operations performed on the server.

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.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverNamestringThe name of the server.
subscriptionIdstringThe subscription ID that identifies an Azure subscription.

SELECT examples

Gets a list of operations performed on the server.

SELECT
properties
FROM azure.sql.server_operations
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;