sql_vulnerability_assessment_scans
Creates, updates, deletes, gets or lists a sql_vulnerability_assessment_scans resource.
Overview
| Name | sql_vulnerability_assessment_scans |
| Type | Resource |
| Id | azure.security.sql_vulnerability_assessment_scans |
Fields
The following fields are returned by SELECT queries:
- get
- list
Returns the scan record details.
| Name | Datatype | 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 | object | A vulnerability assessment scan record properties. |
systemData | object | 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" |
Returns the list of scan records.
| Name | Datatype | 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 | object | A vulnerability assessment scan record properties. |
systemData | object | 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" |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | scanId, workspaceId | api-version, resourceId | |
list | select | workspaceId | api-version, resourceId |
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.
| Name | Datatype | Description |
|---|---|---|
scanId | string | The scan Id. Type 'latest' to get the scan record for the latest scan. |
workspaceId | string | The workspace Id. |
api-version | string | The api version. |
resourceId | string | Optional filter for listing the assignments of a specific resource. |
SELECT examples
- get
- list
Returns the scan record details.
SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scans
WHERE scanId = '{{ scanId }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;
Returns the list of scan records.
SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scans
WHERE workspaceId = '{{ workspaceId }}' -- required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;