Sql Vulnerability Assessment Settings - Get

Service:

Defender for Cloud

API Version:

2026-04-01-preview

Gets the SQL Vulnerability Assessment settings.

GET https://management.azure.com/{resourceId}/providers/Microsoft.Security/sqlVulnerabilityAssessments/default?api-version=2026-04-01-preview

URI Parameters

Name	In	Required	Type	Description
resourceId	path	True	string	The fully qualified Azure Resource manager identifier of the resource.
api-version	query	True	string minLength: 1	The API version to use for this operation.

Responses

Name	Type	Description
200 OK	SqlVulnerabilityAssessmentSettings	Azure operation completed successfully.
Other Status Codes	Common.CloudError	An unexpected error response.

Security

azure_auth

Azure Active Directory OAuth2 Flow.

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize

Scopes

Name	Description
user_impersonation	impersonate your user account

Examples

Get SQL Vulnerability Assessment settings on a resource - Sql Managed Instance

Get SQL Vulnerability Assessment settings on a resource - Sql Server

Get SQL Vulnerability Assessment settings on a resource - Synapse

Get SQL Vulnerability Assessment settings on a resource - Sql Managed Instance

Sample request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default?api-version=2026-04-01-preview

Go

package armsecurity_test

import (
	"context"
	"log"

	"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
	"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)

// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SqlManagedInstanceSettings_Get.json
func ExampleSQLVulnerabilityAssessmentSettingsClient_Get_getSqlVulnerabilityAssessmentSettingsOnAResourceSqlManagedInstance() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	res, err := clientFactory.NewSQLVulnerabilityAssessmentSettingsClient().Get(ctx, "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance", nil)
	if err != nil {
		log.Fatalf("failed to finish the request: %v", err)
	}
	// You could use response here. We use blank identifier for just demo purposes.
	_ = res
	// If the HTTP response code is 200 as defined in example definition, your response structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
	// res = armsecurity.SQLVulnerabilityAssessmentSettingsClientGetResponse{
	// 	SQLVulnerabilityAssessmentSettings: armsecurity.SQLVulnerabilityAssessmentSettings{
	// 		Name: to.Ptr("default"),
	// 		Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments"),
	// 		ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default"),
	// 		Properties: &armsecurity.SQLVulnerabilityAssessmentSettingsProperties{
	// 			CreationTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2022-04-03T04:41:33.937Z"); return t}()),
	// 			State: to.Ptr(armsecurity.SQLVulnerabilityAssessmentStateEnabled),
	// 		},
	// 	},
	// }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

JavaScript

const { SecurityCenter } = require("@azure/arm-security");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to gets the SQL Vulnerability Assessment settings.
 *
 * @summary gets the SQL Vulnerability Assessment settings.
 * x-ms-original-file: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SqlManagedInstanceSettings_Get.json
 */
async function getSQLVulnerabilityAssessmentSettingsOnAResourceSqlManagedInstance() {
  const credential = new DefaultAzureCredential();
  const client = new SecurityCenter(credential);
  const result = await client.sqlVulnerabilityAssessmentSettings.get(
    "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance",
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:

200

{
  "name": "default",
  "type": "Microsoft.Security/sqlVulnerabilityAssessments",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default",
  "properties": {
    "creationTime": "2022-04-03T04:41:33.937Z",
    "state": "Enabled"
  }
}

Get SQL Vulnerability Assessment settings on a resource - Sql Server

Sample request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default?api-version=2026-04-01-preview

Go

package armsecurity_test

import (
	"context"
	"log"

	"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
	"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)

// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SqlServerSettings_Get.json
func ExampleSQLVulnerabilityAssessmentSettingsClient_Get_getSqlVulnerabilityAssessmentSettingsOnAResourceSqlServer() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	res, err := clientFactory.NewSQLVulnerabilityAssessmentSettingsClient().Get(ctx, "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer", nil)
	if err != nil {
		log.Fatalf("failed to finish the request: %v", err)
	}
	// You could use response here. We use blank identifier for just demo purposes.
	_ = res
	// If the HTTP response code is 200 as defined in example definition, your response structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
	// res = armsecurity.SQLVulnerabilityAssessmentSettingsClientGetResponse{
	// 	SQLVulnerabilityAssessmentSettings: armsecurity.SQLVulnerabilityAssessmentSettings{
	// 		Name: to.Ptr("default"),
	// 		Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments"),
	// 		ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default"),
	// 		Properties: &armsecurity.SQLVulnerabilityAssessmentSettingsProperties{
	// 			CreationTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2022-04-03T04:41:33.937Z"); return t}()),
	// 			State: to.Ptr(armsecurity.SQLVulnerabilityAssessmentStateEnabled),
	// 		},
	// 	},
	// }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

JavaScript

const { SecurityCenter } = require("@azure/arm-security");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to gets the SQL Vulnerability Assessment settings.
 *
 * @summary gets the SQL Vulnerability Assessment settings.
 * x-ms-original-file: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SqlServerSettings_Get.json
 */
async function getSQLVulnerabilityAssessmentSettingsOnAResourceSqlServer() {
  const credential = new DefaultAzureCredential();
  const client = new SecurityCenter(credential);
  const result = await client.sqlVulnerabilityAssessmentSettings.get(
    "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer",
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:

200

{
  "name": "default",
  "type": "Microsoft.Security/sqlVulnerabilityAssessments",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default",
  "properties": {
    "creationTime": "2022-04-03T04:41:33.937Z",
    "state": "Enabled"
  }
}

Get SQL Vulnerability Assessment settings on a resource - Synapse

Sample request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default?api-version=2026-04-01-preview

Go

package armsecurity_test

import (
	"context"
	"log"

	"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
	"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)

// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SynapseSettings_Get.json
func ExampleSQLVulnerabilityAssessmentSettingsClient_Get_getSqlVulnerabilityAssessmentSettingsOnAResourceSynapse() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	res, err := clientFactory.NewSQLVulnerabilityAssessmentSettingsClient().Get(ctx, "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace", nil)
	if err != nil {
		log.Fatalf("failed to finish the request: %v", err)
	}
	// You could use response here. We use blank identifier for just demo purposes.
	_ = res
	// If the HTTP response code is 200 as defined in example definition, your response structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
	// res = armsecurity.SQLVulnerabilityAssessmentSettingsClientGetResponse{
	// 	SQLVulnerabilityAssessmentSettings: armsecurity.SQLVulnerabilityAssessmentSettings{
	// 		Name: to.Ptr("default"),
	// 		Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments"),
	// 		ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default"),
	// 		Properties: &armsecurity.SQLVulnerabilityAssessmentSettingsProperties{
	// 			CreationTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2022-04-03T04:41:33.937Z"); return t}()),
	// 			State: to.Ptr(armsecurity.SQLVulnerabilityAssessmentStateEnabled),
	// 		},
	// 	},
	// }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

JavaScript

const { SecurityCenter } = require("@azure/arm-security");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to gets the SQL Vulnerability Assessment settings.
 *
 * @summary gets the SQL Vulnerability Assessment settings.
 * x-ms-original-file: 2026-04-01-preview/sqlVulnerabilityAssessmentsSettingsOperations/SynapseSettings_Get.json
 */
async function getSQLVulnerabilityAssessmentSettingsOnAResourceSynapse() {
  const credential = new DefaultAzureCredential();
  const client = new SecurityCenter(credential);
  const result = await client.sqlVulnerabilityAssessmentSettings.get(
    "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace",
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:

200

{
  "name": "default",
  "type": "Microsoft.Security/sqlVulnerabilityAssessments",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default",
  "properties": {
    "creationTime": "2022-04-03T04:41:33.937Z",
    "state": "Enabled"
  }
}

Definitions

Name	Description
Common.CloudError	Common error response for all Azure Resource Manager APIs to return error details for failed operations. (This also follows the OData error response format.).
Common.CloudErrorBody	The error detail.
createdByType	The type of identity that created the resource.
ErrorAdditionalInfo	The resource management error additional info.
SqlVulnerabilityAssessmentSettings	SQL Vulnerability Assessment settings resource.
SqlVulnerabilityAssessmentSettingsProperties	SQL Vulnerability Assessment settings properties.
SqlVulnerabilityAssessmentState	Represents the state of a SQL Vulnerability Assessment.
systemData	Metadata pertaining to creation and last modification of the resource.

Common.CloudError

Object

Common error response for all Azure Resource Manager APIs to return error details for failed operations. (This also follows the OData error response format.).

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

Common.CloudErrorBody

Object

The error detail.

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

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.

SqlVulnerabilityAssessmentSettings

Object

SQL Vulnerability Assessment settings resource.

Name	Type	Description
id	string (arm-id)	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	SqlVulnerabilityAssessmentSettingsProperties	SQL Vulnerability Assessment settings properties.
systemData	systemData	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

SqlVulnerabilityAssessmentSettingsProperties

Object

SQL Vulnerability Assessment settings properties.

Name	Type	Description
creationTime	string (date-time)	The creation time of the SQL Vulnerability Assessment settings.
state	SqlVulnerabilityAssessmentState	Represents the state of a SQL Vulnerability Assessment.

SqlVulnerabilityAssessmentState

Enumeration

Represents the state of a SQL Vulnerability Assessment.

Value	Description
Enabled	Enabled
Disabled	Disabled

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.