Database Vulnerability Assessments - List By Database
Lists the vulnerability assessment policies associated with a database.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/vulnerabilityAssessments?api-version=2021-11-01
Name | In | Required | Type | Description |
---|---|---|---|---|
database
|
path | True |
string |
The name of the database for which the vulnerability assessment policies are defined. |
resource
|
path | True |
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. |
server
|
path | True |
string |
The name of the server. |
subscription
|
path | True |
string |
The subscription ID that identifies an Azure subscription. |
api-version
|
query | True |
string |
The API version to use for the request. |
Name | Type | Description |
---|---|---|
200 OK |
Successfully retrieved the database vulnerability assessment policies. |
|
Other Status Codes |
*** Error Responses: ***
|
Sample request
Sample response
{
"value": [
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/vulnerabilityaseessmenttest-4799/providers/Microsoft.Sql/servers/vulnerabilityaseessmenttest-6440/databases/testdb/vulnerabilityAssessments/default",
"name": "default",
"type": "Microsoft.Sql/servers/databases/vulnerabilityAssessments",
"properties": {
"recurringScans": {
"isEnabled": true,
"emailSubscriptionAdmins": true,
"emails": [
"email1@mail.com",
"email2@mail.com"
]
}
}
}
]
}
Name | Description |
---|---|
Database |
A database vulnerability assessment. |
Database |
A list of the database's vulnerability assessments. |
Vulnerability |
Properties of a Vulnerability Assessment recurring scans. |
A database vulnerability assessment.
Name | Type | Description |
---|---|---|
id |
string |
Resource ID. |
name |
string |
Resource name. |
properties.recurringScans |
The recurring scans settings |
|
properties.storageAccountAccessKey |
string |
Specifies the identifier key of the storage account for vulnerability assessment scan results. If 'StorageContainerSasKey' isn't specified, storageAccountAccessKey is required. Applies only if the storage account is not behind a Vnet or a firewall |
properties.storageContainerPath |
string |
A blob storage container path to hold the scan results (e.g. https://myStorage.blob.core.windows.net/VaScans/). It is required if server level vulnerability assessment policy doesn't set |
properties.storageContainerSasKey |
string |
A shared access signature (SAS Key) that has write access to the blob container specified in 'storageContainerPath' parameter. If 'storageAccountAccessKey' isn't specified, StorageContainerSasKey is required. Applies only if the storage account is not behind a Vnet or a firewall |
type |
string |
Resource type. |
A list of the database's vulnerability assessments.
Name | Type | Description |
---|---|---|
nextLink |
string |
Link to retrieve next page of results. |
value |
Array of results. |
Properties of a Vulnerability Assessment recurring scans.
Name | Type | Default value | Description |
---|---|---|---|
emailSubscriptionAdmins |
boolean |
True |
Specifies that the schedule scan notification will be is sent to the subscription administrators. |
emails |
string[] |
Specifies an array of e-mail addresses to which the scan notification is sent. |
|
isEnabled |
boolean |
Recurring scans state. |