Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord

Gets all vulnerability assessment scan record(s) associated with a given database.

Syntax

Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord
   [-ServerName] <String>
   [-DatabaseName] <String>
   [-InputObject <AzureSqlDatabaseModel>]
   [-ScanId <String>]
   [-ResourceGroupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Description

The Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord cmdlet retrieves all vulnerability assessment scan record(s) associated with a given database. Note that you need to run Enable-AzSqlServerAdvancedDataSecurity and Update-AzSqlServerVulnerabilityAssessmentSettings cmdlet as a prerequisite for using this cmdlets.

Examples

Example 1 - Gets a specific vulnerability assessment scan results identified by the scan ID

PS C:\> Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord `
            -ResourceGroupName "ResourceGroup01" `
            -ServerName "Server01" `
            -DatabaseName "Database01" `
            -ScanId "myScan" 

ResourceGroupName	        	: ResourceGroup01
ServerName	                	: Server01
DatabaseName		            : Database01
ScanId 		                	: myScan
TriggerType	                	: OnDemand
State 			                : Passed
StartTime 	                	: 6/11/2018 1:57:27 PM
EndTime 	            		: 6/11/2018 1:57:31 PM
Errors 		                	: {}
ScanResultsLocationPath     	: https://myaccount.blob.core.windows.net/vulnerability-assessment         
                                    scans/Server01/Database01/scan_myScan/.json
NumberOfFailedSecurityChecks    : 9

Example 2 - Gets a specific vulnerability assessment scan results identified by the scan ID with database object

PS C:\>  Get-AzSqlDatabase `
            -ResourceGroupName "ResourceGroup01" `
            -ServerName "Server01" `
            -DatabaseName "Database01" `
            | Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord  `
                -ScanId "myScan"

ResourceGroupName	        	: ResourceGroup01
ServerName	                	: Server01
DatabaseName		            : Database01
ScanId 		                	: myScan
TriggerType	                	: OnDemand
State 			                : Passed
StartTime 	                	: 6/11/2018 1:57:27 PM
EndTime 	            		: 6/11/2018 1:57:31 PM
Errors 		                	: {}
ScanResultsLocationPath     	: https://myaccount.blob.core.windows.net/vulnerability-assessment         
                                    scans/Server01/Database01/scan_myScan/.json
NumberOfFailedSecurityChecks    : 9

Example 3 - Gets all vulnerability assessment scan results on the specified database

PS C:\>  Get-AzSqlDatabase `
            -ResourceGroupName "ResourceGroup01" `
            -ServerName "Server01" `
            -DatabaseName "Database01" `
            | Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord

ResourceGroupName	        	: ResourceGroup01
ServerName	                	: Server01
DatabaseName		            : Database01
ScanId 		                	: myScan
TriggerType	                	: OnDemand
State 			                : Passed
StartTime 	                	: 6/11/2018 1:57:27 PM
EndTime 	            		: 6/11/2018 1:57:31 PM
Errors 		                	: {}
ScanResultsLocationPath     	: https://myaccount.blob.core.windows.net/vulnerability-assessment         
                                    scans/Server01/Database01/scan_myScan/.json
NumberOfFailedSecurityChecks    : 9


ResourceGroupName	        	: ResourceGroup01
ServerName	                	: Server01
DatabaseName		            : Database01
ScanId 		                	: myScan1
TriggerType	                	: OnDemand
State 			                : Passed
StartTime 	                	: 6/12/2018 1:57:27 PM
EndTime 	            		: 6/12/2018 1:57:31 PM
Errors 		                	: {}
ScanResultsLocationPath     	: https://myaccount.blob.core.windows.net/vulnerability-assessment         
                                    scans/Server01/Database01/scan_myScan/.json
NumberOfFailedSecurityChecks    : 9

Parameters

-DatabaseName

SQL Database name.

Type:String
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-DefaultProfile

The credentials, account, tenant, and subscription used for communication with Azure.

Type:Microsoft.Azure.Commands.Common.Authentication.Abstractions.Core.IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InputObject

The database object to get Vulnerability Assessment scan record for

Type:AzureSqlDatabaseModel
Position:Named
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-ResourceGroupName

The name of the resource group.

Type:String
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ScanId

Specifies the scan ID.

Type:String
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ServerName

SQL Database server name.

Type:String
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Inputs

String

AzureSqlDatabaseModel

Outputs

Microsoft.Azure.Commands.Sql.VulnerabilityAssessment.Model.DatabaseVulnerabilityAssessmentScanRecordModel