sql_vulnerability_assessment_scan_results

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

Overview

Name	sql_vulnerability_assessment_scan_results
Type	Resource
Id	azure.security.sql_vulnerability_assessment_scan_results

Fields

The following fields are returned by SELECT queries:

get

Returns the scan results.

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 result properties for a single rule.
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"

list

Returns the list of scan results.

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 result properties for a single rule.
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, scanResultId, workspaceId	api-version, resourceId
list	select	scanId, 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 results for the latest scan.
scanResultId	string	The rule Id of the results.
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

Returns the scan results.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scan_results
WHERE scanId = '{{ scanId }}' -- required
AND scanResultId = '{{ scanResultId }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;

list

Returns the list of scan results.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scan_results
WHERE scanId = '{{ scanId }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;