Get-AzSqlServerVulnerabilityAssessmentSetting
Gets the vulnerability assessment settings of a server.
Syntax
Get-AzSqlServerVulnerabilityAssessmentSetting
[-ResourceGroupName] <String>
[-ServerName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSqlServerVulnerabilityAssessmentSetting
[-InputObject] <AzureSqlServerModel>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Description
The Get-AzSqlServerVulnerabilityAssessmentSetting cmdlet gets the vulnerability assessment settings of an Azure SQL Server. Note that you need to run Enable-AzSqlServerAdvancedDataSecurity cmdlet as a prerequisite for using this cmdlet.
Examples
Example 1: Get the vulnerability assessment settings of an Azure SQL server
Get-AzSqlServerVulnerabilityAssessmentSetting `
-ResourceGroupName "ResourceGroup01" `
-ServerName "Server01"
ResourceGroupName : ResourceGroup01
ServerName : Server01
StorageAccountName : mystorage
ScanResultsContainerName : vulnerability-assessment
RecurringScansInterval : None
EmailSubscriptionAdmins : False
NotificationEmail : {}Example 2: Get the vulnerability assessment settings of an Azure SQL server from an Azure SQL server object
Get-AzSqlServer `
-ResourceGroupName "ResourceGroup01" `
-ServerName "Server01" `
| Get-AzSqlServerVulnerabilityAssessmentSetting
ResourceGroupName : ResourceGroup01
ServerName : Server01
StorageAccountName : mystorage
ScanResultsContainerName : vulnerability-assessment
RecurringScansInterval : None
EmailSubscriptionAdmins : False
NotificationEmail : {}Parameters
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InputObject
The database object to get Vulnerability Assessment settings for
| Type: | AzureSqlServerModel |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ResourceGroupName
The name of the resource group.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ServerName
SQL Database server name.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
