Get-AzSecuritySqlVulnerabilityAssessmentScanRuleResult

Module:

Az.Security Module

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

-InputObject

Identity Parameter

Parameter properties

Type:	ISecurityIdentity
Default value:	None
Supports wildcards:	False
DontShow:	False

Parameter sets

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.

Inputs

ISecurityIdentity

Outputs

IScanResult