Sql Server Licenses - List

Service:

Arc Data

API Version:

2026-01-01

List sqlServerLicense resources in the subscription

GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.AzureArcData/sqlServerLicenses?api-version=2026-01-01

URI Parameters

Name	In	Required	Type	Description
subscriptionId	path	True	string	The ID of the Azure subscription
api-version	query	True	string	The API version to use for the request

Responses

Name	Type	Description
200 OK	SqlServerLicenseListResult	OK
Other Status Codes	ErrorResponse	*** Error Responses: *** 400 InvalidParameterValue - An invalid value was given to parameter. 400 InvalidCrossSubscriptionVmMove - Invalid cross subscription move of resource. 404 ResourceNotFound - The requested resource was not found.

Examples

Gets all SQL Server license in a subscription.

Sample request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.AzureArcData/sqlServerLicenses?api-version=2026-01-01

Sample response

Status code:

200

{
  "value": [
    {
      "properties": {
        "billingPlan": "PAYG",
        "licenseCategory": "Core",
        "physicalCores": 24,
        "activationState": "Deactivated",
        "scopeType": "Subscription",
        "lastActivatedAt": "2020-01-01T17:18:19.1234567Z",
        "lastDeactivatedAt": "2020-01-01T17:18:19.1234567Z",
        "tenantId": "89fdfcc3-4c62-41c3-93c4-16bae3bcf5ea"
      },
      "location": "northeurope",
      "systemData": {
        "createdBy": "user1",
        "createdByType": "User",
        "createdAt": "2020-01-01T17:18:19.1234567Z",
        "lastModifiedBy": "user2",
        "lastModifiedByType": "User",
        "lastModifiedAt": "2020-01-02T17:18:19.1234567Z"
      },
      "tags": {
        "mytag": "myval"
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/SqlServerLicenses/sqlServerLicense1",
      "name": "sqlServerLicense1",
      "type": "Microsoft.AzureArcData/SqlServerLicenses"
    },
    {
      "properties": {
        "billingPlan": "PAYG",
        "licenseCategory": "Core",
        "physicalCores": 24,
        "activationState": "Deactivated",
        "scopeType": "Subscription",
        "lastActivatedAt": "2020-01-01T17:18:19.1234567Z",
        "lastDeactivatedAt": "2020-01-01T17:18:19.1234567Z",
        "tenantId": "89fdfcc3-4c62-41c3-93c4-16bae3bcf5ea"
      },
      "location": "northeurope",
      "systemData": {
        "createdBy": "user1",
        "createdByType": "User",
        "createdAt": "2020-01-01T17:18:19.1234567Z",
        "lastModifiedBy": "user2",
        "lastModifiedByType": "User",
        "lastModifiedAt": "2020-01-02T17:18:19.1234567Z"
      },
      "tags": {
        "mytag": "myval"
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/SqlServerLicenses/sqlServerLicense2",
      "name": "sqlServerLicense2",
      "type": "Microsoft.AzureArcData/SqlServerLicenses"
    }
  ]
}

Definitions

Name	Description
activationState	The activation state of the license.
billingPlan	SQL Server license type.
createdByType	The type of identity that created the resource.
ErrorAdditionalInfo	The resource management error additional info.
ErrorDetail	The error detail.
ErrorResponse	Error response
licenseCategory	This property represents the choice between SQL Server Core and ESU licenses.
scopeType	The Azure scope to which the license will apply.
SqlServerLicense	Describe SQL Server license resource.
SqlServerLicenseListResult	A list of SQL Server licenses.
SqlServerLicenseProperties	Properties of SQL Server License.
systemData	Metadata pertaining to creation and last modification of the resource.

activationState

Enumeration

The activation state of the license.

Value	Description
Activated
Deactivated

billingPlan

Enumeration

SQL Server license type.

Value	Description
PAYG
Paid

createdByType

Enumeration

The type of identity that created the resource.

Value	Description
User
Application
ManagedIdentity
Key

ErrorAdditionalInfo

Object

The resource management error additional info.

Name	Type	Description
info	object	The additional info.
type	string	The additional info type.

ErrorDetail

Object

The error detail.

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	The error additional info.
code	string	The error code.
details	ErrorDetail[]	The error details.
message	string	The error message.
target	string	The error target.

ErrorResponse

Object

Error response

Name	Type	Description
error	ErrorDetail	The error object.

licenseCategory

Enumeration

This property represents the choice between SQL Server Core and ESU licenses.

Value	Description
Core

scopeType

Enumeration

The Azure scope to which the license will apply.

Value	Description
Tenant
Subscription
ResourceGroup

SqlServerLicense

Object

Describe SQL Server license resource.

Name	Type	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location	string	The geo-location where the resource lives
name	string	The name of the resource
properties	SqlServerLicenseProperties	SQL Server license properties
systemData	systemData	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

SqlServerLicenseListResult

Object

A list of SQL Server licenses.

Name	Type	Description
nextLink	string	Link to retrieve next page of results.
value	SqlServerLicense[]	Array of results.

SqlServerLicenseProperties

Object

Properties of SQL Server License.

Name	Type	Description
activationState	activationState	The activation state of the license.
billingPlan	billingPlan	SQL Server license type.
lastActivatedAt	string (date-time)	The timestamp of the most recent activation of the SqlServerLicense.
lastDeactivatedAt	string (date-time)	The timestamp of the most recent deactivation of the SqlServerLicense.
licenseCategory	licenseCategory	This property represents the choice between SQL Server Core and ESU licenses.
physicalCores	integer (int32) minimum: 16 multipleOf: 2	The number of total cores of the license covers.
scopeType	scopeType	The Azure scope to which the license will apply.
tenantId	string	The tenantId the SQL Server license resource subscription resides in.

systemData

Object

Metadata pertaining to creation and last modification of the resource.

Name	Type	Description
createdAt	string (date-time)	The timestamp of resource creation (UTC).
createdBy	string	The identity that created the resource.
createdByType	createdByType	The type of identity that created the resource.
lastModifiedAt	string (date-time)	The timestamp of resource last modification (UTC)
lastModifiedBy	string	The identity that last modified the resource.
lastModifiedByType	createdByType	The type of identity that last modified the resource.