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

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
baselineAdjustedResult	object	The rule result adjusted with baseline.
isTrimmed	boolean	Indicates whether the results specified here are trimmed.
queryResults	array	The results of the query that was run.
remediation	object	Remediation details.
ruleId	string	The rule Id.
ruleMetadata	object	vulnerability assessment rule metadata details.
status	string	The rule result status. Known values are: "NonFinding", "Finding", "InternalError", and "NotApplicable". (NonFinding, Finding, InternalError, NotApplicable)
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

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
baselineAdjustedResult	object	The rule result adjusted with baseline.
isTrimmed	boolean	Indicates whether the results specified here are trimmed.
queryResults	array	The results of the query that was run.
remediation	object	Remediation details.
ruleId	string	The rule Id.
ruleMetadata	object	vulnerability assessment rule metadata details.
status	string	The rule result status. Known values are: "NonFinding", "Finding", "InternalError", and "NotApplicable". (NonFinding, Finding, InternalError, NotApplicable)
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	scan_id, scan_result_id, resource_id	databaseName	Gets the scan results of a single rule in a scan record. Gets the scan results of a single rule in a scan record.
list	select	scan_id, resource_id	databaseName	Gets a list of scan results for a single scan record. Gets a list of scan results for a single scan record.

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
resource_id	string	The fully qualified Azure Resource manager identifier of the resource. Required.
scan_id	string	The scan Id. Required.
scan_result_id	string	The rule Id of the results. Required.
databaseName	string	The name of the database to assess. Required when the API is called on the parent resource (e.g., server level) rather than on a specific database resource, since the database name is not part of the resource URI. This is the only way to assess system databases (e.g., master), which cannot be referenced directly in the resource URI. Default value is None.

SELECT examples

get

Gets the scan results of a single rule in a scan record. Gets the scan results of a single rule in a scan record.

SELECT
id,
name,
baselineAdjustedResult,
isTrimmed,
queryResults,
remediation,
ruleId,
ruleMetadata,
status,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scan_results
WHERE scan_id = '{{ scan_id }}' -- required
AND scan_result_id = '{{ scan_result_id }}' -- required
AND resource_id = '{{ resource_id }}' -- required
AND databaseName = '{{ databaseName }}'
;

list

Gets a list of scan results for a single scan record. Gets a list of scan results for a single scan record.

SELECT
id,
name,
baselineAdjustedResult,
isTrimmed,
queryResults,
remediation,
ruleId,
ruleMetadata,
status,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_scan_results
WHERE scan_id = '{{ scan_id }}' -- required
AND resource_id = '{{ resource_id }}' -- required
AND databaseName = '{{ databaseName }}'
;