Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult
Gets the scan results of a single rule in a scan record.
Syntax
List (Default)
Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult
-ResourceId <String>
-ScanId <String>
[-DatabaseName <String>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Get
Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult
-ResourceId <String>
-ScanId <String>
-ScanResultId <String>
[-DatabaseName <String>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
GetViaIdentity
Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult
-InputObject <ISecurityIdentity>
[-DatabaseName <String>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Description
Gets the scan results of a single rule in a scan record.
Examples
Example 1: List the rule results of a SQL Vulnerability Assessment scan
Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult -ResourceId "/subscriptions/{subId}/resourceGroups/{rg}/providers/Microsoft.Sql/servers/{server}/databases/{database}" -ScanId "latest"
Name Status IsTrimmed
---- ------ ---------
VA1020 Finding False
VA1143 NonFinding False
This command lists all rule results produced by the latest SQL Vulnerability Assessment scan of the given database.
Example 2: Get a specific rule result of a SQL Vulnerability Assessment scan
Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult -ResourceId "/subscriptions/{subId}/resourceGroups/{rg}/providers/Microsoft.Sql/servers/{server}/databases/{database}" -ScanId "latest" -ScanResultId "VA1143"
Name Status IsTrimmed
---- ------ ---------
VA1143 NonFinding False
This command gets the result of rule "VA1143" from the latest SQL Vulnerability Assessment scan of the given database.
Parameters
-DatabaseName
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.
Parameter properties
Type: String
Default value: None
Supports wildcards: False
DontShow: False
Parameter sets
(All)
Position: Named
Mandatory: False
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
-DefaultProfile
The DefaultProfile parameter is not functional.
Use the SubscriptionId parameter when available if executing the cmdlet against a different subscription.
Parameter properties
Type: PSObject
Default value: None
Supports wildcards: False
DontShow: False
Aliases: AzureRMContext, AzureCredential
Parameter sets
(All)
Position: Named
Mandatory: False
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
Identity Parameter
GetViaIdentity
Position: Named
Mandatory: True
Value from pipeline: True
Value from pipeline by property name: False
Value from remaining arguments: False
-ResourceId
The fully qualified Azure Resource manager identifier of the resource.
Parameter properties
Type: String
Default value: None
Supports wildcards: False
DontShow: False
Parameter sets
List
Position: Named
Mandatory: True
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
Get
Position: Named
Mandatory: True
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
-ScanId
The scan Id.
Parameter properties
Type: String
Default value: None
Supports wildcards: False
DontShow: False
Parameter sets
List
Position: Named
Mandatory: True
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
Get
Position: Named
Mandatory: True
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
-ScanResultId
The rule Id of the results.
Parameter properties
Type: String
Default value: None
Supports wildcards: False
DontShow: False
Parameter sets
Get
Position: Named
Mandatory: True
Value from pipeline: False
Value from pipeline by property name: False
Value from remaining arguments: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable,
-InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable,
-ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see
about_CommonParameters .
Outputs