Migratiehandleiding voor Az 3.0.0

In dit document worden de wijzigingen tussen de versies 2.0.0 en 3.0.0 van Az beschreven

• migratiehandleiding voor Az 3.0.0
  • Batch
    • Get-AzBatchNodeAgentSku
    • incompatibiliteit met eerdere versies van Az.Resources
  • Berekenen-
    • New-AzDiskConfig
  • HDInsight
    • Get-AzHDInsightJobOutput
    • Add-AzHDInsightConfigValues
    • Disable-AzHDInsightMonitoring
    • Enable-AzHDInsightMonitoring
    • Get-AzHDInsightMonitoring
    • Get-AzHDInsightProperty
    • Grant-AzHDInsightRdpServicesAccess
    • Remove-AzHDInsightCluster
    • Revoke-AzHDInsightRdpServicesAccess
    • Set-AzHDInsightGatewayCredential
  • IotHub-
    • New-AzIotHubImportDevices
    • New-AzIotHubExportDevices
    • Add-AzIotHubEventHubConsumerGroup
    • Get-AzIotHubEventHubConsumerGroup
    • Remove-AzIotHubEventHubConsumerGroup
    • Set-AzIotHub
  • RecoveryServices-
    • Edit-AzRecoveryServicesAsrRecoveryPlan
    • Get-AzRecoveryServicesAsrRecoveryPlan
    • New-AzRecoveryServicesAsrReplicationProtectedItem
  • bronnen
    • incompatibiliteit met eerdere versies van Az.Batch
  • ServiceFabric
    • Add-ServiceFabricApplicationCertificate
  • Sql
    • Get-AzSqlDatabaseSecureConnectionPolicy
    • Get-AzSqlDatabaseIndexRecommendations
    • Get-AzSqlDatabaseRestorePoints
    • Get-AzSqlDatabaseAuditing
    • Set-AzSqlDatabaseAuditing
    • Get-AzSqlServerAuditing
    • Set-AzSqlServerAuditing
    • Get-AzSqlServerAdvancedThreatProtectionSettings
    • Clear-AzSqlServerAdvancedThreatProtectionSettings
    • Update-AzSqlServerAdvancedThreatProtectionSettings
    • Get-AzSqlDatabaseAdvancedThreatProtectionSettings
    • Update-AzSqlDatabaseAdvancedThreatProtectionSettings
    • Clear-AzSqlDatabaseAdvancedThreatProtectionSettings
    • Update-AzSqlDatabaseVulnerabilityAssessmentSettings
    • Get-AzSqlDatabaseVulnerabilityAssessmentSettings
    • Clear-AzSqlDatabaseVulnerabilityAssessmentSettings
    • Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings
    • Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings
    • Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings
    • Update-AzSqlInstanceVulnerabilityAssessmentSettings
    • Get-AzSqlInstanceVulnerabilityAssessmentSettings
    • Clear-AzSqlInstanceVulnerabilityAssessmentSettings
    • Update-AzSqlServerVulnerabilityAssessmentSettings
    • Get-AzSqlServerVulnerabilityAssessmentSettings
    • Clear-AzSqlServerVulnerabilityAssessmentSettings
    • Get-AzSqlServerAdvancedThreatProtectionPolicy
    • Get-AzSqlServerThreatDetectionPolicy
    • Remove-AzSqlServerThreatDetectionPolicy
    • Set-AzSqlServerThreatDetectionPolicy
    • Get-AzSqlDatabaseThreatDetectionPolicy
    • Set-AzSqlDatabaseThreatDetectionPolicy
    • Remove-AzSqlDatabaseThreatDetectionPolicy

Batch

Get-AzBatchNodeAgentSku

• Get-AzBatchNodeAgentSku verwijderd en vervangen door Get-AzBatchSupportedImage.
• Get-AzBatchSupportedImage retourneert dezelfde gegevens als Get-AzBatchNodeAgentSku, maar in een gebruiksvriendelijker formaat.
• Nieuwe niet-geverifieerde afbeeldingen worden nu ook geretourneerd. Aanvullende informatie over Capabilities en BatchSupportEndOfLife voor elke afbeelding wordt ook opgenomen.

Voor

$Context = Get-AzBatchAccountKeys -AccountName "ContosoBatchAccount"
Get-AzBatchNodeAgentSku -BatchContext $Context

Na

$Context = Get-AzBatchAccountKey -AccountName "ContosoBatchAccount"
Get-AzBatchSupportedImage -BatchContext $Context

Incompatibiliteit van vorige versie met Az.Resources-module

Versie 2.0.1 van de module Az.Batch is niet compatibel met eerdere versies (versie 1.7.0 of eerder) van de module Az.Resources. Hierdoor kan versie 1.7.0 van de module Az.Resources niet worden geïmporteerd wanneer versie 2.0.1 van de module Az.Batch wordt geïmporteerd. Als u dit probleem wilt oplossen, werkt u de module Az.Resources bij naar versie 1.7.1 of hoger of installeert u gewoon de nieuwste versie van de Az-module.

Berekenen

New-AzDiskConfig

UploadSizeInBytes parameter wordt gebruikt in plaats van DiskSizeGB voor New-AzDiskConfig wanneer CreateOption uploadt

Voor

$diskconfig = New-AzDiskConfig -Location 'Central US' -DiskSizeGB 1023 -SkuName Standard_LRS -OsType Windows -CreateOption Upload -DiskIOPSReadWrite 500 -DiskMBpsReadWrite 8

Na

$diskconfig = New-AzDiskConfig -Location 'Central US' -UploadSizeInBytes 1023 * 1024 * 1024 * 1024 -SkuName Standard_LRS -OsType Windows -CreateOption Upload -DiskIOPSReadWrite 500 -DiskMBpsReadWrite 8

HDInsight

Get-AzHDInsightJobOutput

• De cmdlet Get-AzHDInsightJobOutput bijgewerkt ter ondersteuning van gedetailleerde op rollen gebaseerde toegang tot de opslagsleutel.
• Gebruikers met de rollen HDInsight-clusteroperator, Inzender of Eigenaar worden niet beïnvloed.
• Gebruikers met alleen de rol Lezer moeten expliciet DefaultStorageAccountKey parameter opgeven.

Voor

Get-AzHDInsightJobOutput  -ClusterName $clusterName -JobId $jobId

Na

Get-AzHDInsightJobOutput -ClusterName $clusterName -JobId $jobId -DefaultStorageAccountKey $storageAccountKey

Add-AzHDInsightConfigValues

Cmdlet Add-AzHDInsightConfigValue heeft alias van Add-AzHDInsightConfigValuesverwijderd.

Voor

Afgeschafte alias gebruiken

Add-AzHDInsightConfigValues

Na

Add-AzHDInsightConfigValue

Disable-AzHDInsightMonitoring

Er is een nieuwe Disable-AzHDInsightMonitoring-cmdlet toegevoegd. Gebruik deze cmdlet om bewaking in een HDInsight-cluster uit te schakelen (vervangt Disable-AzHDInsightOperationsManagementSuite en Disable-AzHDInsightOMS).

Voor

Disable-AzHDInsightOMS -Name testcluster

Disable-AzHDInsightOperationsManagementSuite -Name testcluster

Na

Disable-AzHDInsightMonitoring -Name testcluster

Enable-AzHDInsightMonitoring

Er is een nieuwe Enable-AzHDInsightMonitoring-cmdlet toegevoegd. Gebruik deze cmdlet om bewaking in te schakelen in een HDInsight-cluster (vervangt Enable-AzHDInsightOperationsManagementSuite en Enable-AzHDInsightOMS).

Voor

Enable-AzHDInsightOMS Enable-AzHDInsightMonitoring -Name testcluster -WorkspaceId 1d364e89-bb71-4503-aa3d-a23535aea7bd -PrimaryKey <key for workspace 1d364e89-bb71-4503-aa3d-a23535aea7bd>

Enable-AzHDInsightOperationsManagementSuite Enable-AzHDInsightMonitoring -Name testcluster -WorkspaceId 1d364e89-bb71-4503-aa3d-a23535aea7bd -PrimaryKey <key for workspace 1d364e89-bb71-4503-aa3d-a23535aea7bd>

Na

Enable-AzHDInsightMonitoring Enable-AzHDInsightMonitoring -Name testcluster -WorkspaceId 1d364e89-bb71-4503-aa3d-a23535aea7bd -PrimaryKey <key for workspace 1d364e89-bb71-4503-aa3d-a23535aea7bd>

Get-AzHDInsightMonitoring

Er is een nieuwe Get-AzHDInsightMonitoring-cmdlet toegevoegd. Gebruik deze cmdlet om de status van de bewakingsinstallatie op te halen in een Azure HDInsight-cluster (vervangt Get-AzHDInsightOperationsManagementSuite en Get-AzHDInsightOMS).

Voor

Get-AzHDInsightOMS -Name testcluster

Get-AzHDInsightOperationsManagementSuite -Name testcluster

Na

Get-AzHDInsightMonitoring -Name testcluster

Get-AzHDInsightProperty

Cmdlet Get-HDInsightProperty heeft alias van Get-AzHDInsightPropertiesverwijderd.

Voor

Afgeschafte alias gebruiken

Get-AzHDInsightProperties -Location "East US 2"

Na

Get-AzHDInsightProperty -Location "East US 2"

Grant-AzHDInsightRdpServicesAccess

De cmdlets Grant-AzHDInsightRdpServicesAccess en Revoke-AzHDInsightRdpServicesAccess verwijderd. Deze zijn niet meer nodig omdat clusters met het Type Windows-besturingssysteem niet worden ondersteund. Maak in plaats daarvan een cluster met het Linux-besturingssysteemtype.

Remove-AzHDInsightCluster

Het uitvoertype van Remove-AzHDInsightCluster gewijzigd van Microsoft.Azure.Management.HDInsight.Models.ClusterGetResponse in bool.

Voor

$cluster = Remove-AzHDInsightCluster -ClusterName "your-hadoop-001"

Na

Remove-AzHDInsightCluster -ClusterName "your-hadoop-001" -PassThru
True

Revoke-AzHDInsightRdpServicesAccess

De cmdlet is verouderd verklaard. Er is geen vervanging voor.

Set-AzHDInsightGatewayCredential

Het uitvoertype van Set-AzHDInsightGatewayCredential gewijzigd van HttpConnectivitySettings in AzureHDInsightGatewaySettings.

IotHub

New-AzIotHubImportDevices

Deze alias wordt verwijderd. Gebruik in plaats daarvan New-AzIotHubImportDevice.

Voor

New-AzIotHubImportDevices -ResourceGroupName "myresourcegroup" -Name "myiothub" -InputBlobContainerUri "https://mystorageaccount.blob.core.windows.net/mystoragecontainer?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D" -OutputBlobContainerUri "https://mystorageaccount.blob.core.windows.net/?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D"

Na

New-AzIotHubImportDevice -ResourceGroupName "myresourcegroup" -Name "myiothub" -InputBlobContainerUri "https://mystorageaccount.blob.core.windows.net/mystoragecontainer?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D" -OutputBlobContainerUri "https://mystorageaccount.blob.core.windows.net/?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D"

New-AzIotHubExportDevices

Deze alias wordt verwijderd. Gebruik in plaats daarvan New-AzIotHubExportDevice.

Voor

New-AzIotHubExportDevices -ResourceGroupName "myresourcegroup" -Name "myiothub" -ExportBlobContainerUri "https://mystorageaccount.blob.core.windows.net/mystoragecontainer?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D" -ExcludeKeys

Na

New-AzIotHubExportDevice -ResourceGroupName "myresourcegroup" -Name "myiothub" -ExportBlobContainerUri "https://mystorageaccount.blob.core.windows.net/mystoragecontainer?sv=2015-04-05&ss=bfqt&sr=c&srt=sco&sp=rwdl&se=2016-10-27T04:01:48Z&st=2016-10-26T20:01:48Z&spr=https&sig=QqpIhHsIMF8hNuFO%3D" -ExcludeKeys

Add-AzIotHubEventHubConsumerGroup

Parameter EventHubEndPointName wordt afgeschaft zonder te worden vervangen omdat IotHub wordt geleverd met slechts één ingebouwd eindpunt("gebeurtenissen") waarmee systeem- en apparaatberichten kunnen worden verwerkt.

Voor

Add-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub" -EventHubConsumerGroupName "myconsumergroup" -EventHubEndpointName "/EventHubEndpointName"

Na

Add-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub" -EventHubConsumerGroupName "myconsumergroup"

Get-AzIotHubEventHubConsumerGroup

Parameter EventHubEndPointName wordt afgeschaft zonder te worden vervangen omdat IotHub wordt geleverd met slechts één ingebouwd eindpunt("gebeurtenissen") waarmee systeem- en apparaatberichten kunnen worden verwerkt.

Voor

Get-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub" -EventHubEndpointName "/EventHubEndpointName"

Na

Get-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub"

Remove-AzIotHubEventHubConsumerGroup

Parameter EventHubEndPointName wordt afgeschaft zonder te worden vervangen omdat IotHub wordt geleverd met slechts één ingebouwd eindpunt("gebeurtenissen") waarmee systeem- en apparaatberichten kunnen worden verwerkt.

Voor

Remove-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub" -EventHubConsumerGroupName myconsumergroup -EventHubEndpointName "/EventHubEndpointName"

Na

Remove-AzIotHubEventHubConsumerGroup -ResourceGroupName "myresourcegroup" -Name "myiothub" -EventHubConsumerGroupName myconsumergroup

Set-AzIotHub

Parameter OperationsMonitoringProperties wordt afgeschaft zonder te worden vervangen omdat IotHub geen ingebouwd eindpunt meer gebruikt("operationsMonitoringEvents").

RecoveryServices

Edit-AzRecoveryServicesAsrRecoveryPlan

ASRRecoveryPlanGroup.ReplicationProtectedItems, ASRRecoveryPlanGroup.StartGroupActions en ASRRecoveryPlanGroup.EndGroupActions worden uit de uitvoer verwijderd.

Get-AzRecoveryServicesAsrRecoveryPlan

ASRRecoveryPlanGroup.ReplicationProtectedItems, ASRRecoveryPlanGroup.StartGroupActions en ASRRecoveryPlanGroup.EndGroupActions worden uit de uitvoer verwijderd.

New-AzRecoveryServicesAsrReplicationProtectedItem

Parameter IncludeDiskId wordt gewijzigd ter ondersteuning van rechtstreeks schrijven naar een beheerde schijf in Azure Site Recovery.

Voor

$job = New-AzRecoveryServicesAsrReplicationProtectedItem -RecoveryAzureStorageAccountId $recoveryAzureStorageAccountId -IncludeDiskId $includeDiskId -VMwareToAzure -Account $fabric.FabricSpecificDetails.RunAsAccounts[0] -RecoveryResourceGroupId $RecoveryResourceGroupId -RecoveryAzureNetworkId $RecoveryAzureNetworkId -name $name -ProcessServer $fabric.FabricSpecificDetails.ProcessServers[0] -ProtectableItem $protectableItem -ProtectionContainerMapping $pcm -RecoveryAzureSubnetName $RecoveryAzureSubnetName -RecoveryVmName $RecoveryVmName -LogStorageAccountId $LogStorageAccountId

Na

$disk1 = New-AzRecoveryServicesAsrInMageAzureV2DiskInput -DiskId $diskId -LogStorageAccountId $logStorageAccountId -DiskType $diskType
$disk2 = New-AzRecoveryServicesAsrInMageAzureV2DiskInput -DiskId $diskId2 -LogStorageAccountId $logStorageAccountId -DiskType $diskType2
$job = New-AzRecoveryServicesAsrReplicationProtectedItem -VMwareToAzure -Account $fabric.FabricSpecificDetails.RunAsAccounts[0] -RecoveryResourceGroupId $RecoveryResourceGroupId -RecoveryAzureNetworkId $RecoveryAzureNetworkId -name $name -ProcessServer $fabric.FabricSpecificDetails.ProcessServers[0] -ProtectableItem $protectableItem -ProtectionContainerMapping $pcm -RecoveryAzureSubnetName $RecoveryAzureSubnetName -RecoveryVmName $RecoveryVmName -LogStorageAccountId $LogStorageAccountId -InMageAzureV2DiskInput $disk1,$disk2

Middelen

Incompatibiliteit van vorige versie met Az.Batch-module

Versie 1.7.1 van de module Az.Resources is niet compatibel met eerdere versies (versie 1.1.2 of eerder) van de module Az.Batch. Hierdoor kan versie 1.1.2 van de module Az.Batch niet worden geïmporteerd wanneer versie 1.7.1 van de module Az.Resources wordt geïmporteerd. Als u dit probleem wilt oplossen, werkt u de module Az.Batch bij naar versie 2.0.1 of hoger of installeert u gewoon de nieuwste versie van de Az-module.

ServiceFabric

Add-ServiceFabricApplicationCertificate

Verwijderd Add-ServiceFabricApplicationCertificate omdat dit scenario wordt gedekt door Add-AzVmssSecret.

Voor

Add-AzServiceFabricApplicationCertificate -ResourceGroupName "Group1" -Name "Contoso01SFCluster" -SecretIdentifier "http://keyVaultName.vault.contoso.net/secrets/secretName/secretVersion"

Na

$Vault = Get-AzKeyVault -VaultName "ContosoVault"
$CertConfig = New-AzVmssVaultCertificateConfig -CertificateUrl "http://keyVaultName.vault.contoso.net/secrets/secretName/secretVersion" -CertificateStore "Certificates"
$VMSS = New-AzVmssConfig
Add-AzVmssSecret -VirtualMachineScaleSet $VMSS -SourceVaultId $Vault.ResourceId -VaultCertificate $CertConfig

SQL

Get-AzSqlDatabaseSecureConnectionPolicy

Houd er rekening mee dat beveiligde verbinding is afgeschaft en dat de opdracht daarom wordt verwijderd. Gebruik het SQL-database-blade in het Azure-portaal om de verbindingsstrings weer te geven.

Get-AzSqlDatabaseIndexRecommendations

Get-AzSqlDatabaseIndexRecommendations alias wordt verwijderd. Gebruik in plaats daarvan Get-AzSqlDatabaseIndexRecommendation.

Get-AzSqlDatabaseRestorePoints

Get-AzSqlDatabaseRestorePoints alias wordt verwijderd. Gebruik in plaats daarvan Get-AzSqlDatabaseRestorePoint.

Get-AzSqlDatabaseAuditing

• De cmdlet Get-AzSqlDatabaseAudit vervangt deze cmdlet.
• Het uitvoertype verandert van het bestaande type :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' naar het nieuwe type :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseAuditingSettingsModel', waarbij eigenschappen worden verwijderd AuditState en StorageAccountName. en StorageAccountSubscriptionId. Scripts kunnen opslagaccountgegevens ophalen uit de nieuwe eigenschap StorageAccountResourceId.

Voor

PS C:\> Get-AzSqlDatabaseAuditing -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
DatabaseName                 : database01
AuditAction                  : {}
AuditActionGroup             : {SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP,
                                BATCH_COMPLETED_GROUP, ...}
ResourceGroupName            : resourcegroup01
ServerName                   : server01
AuditState                   : Enabled
StorageAccountName           : mystorage
StorageKeyType               : Primary
RetentionInDays              : 0
StorageAccountSubscriptionId : 7fe3301d-31d3-4668-af5e-211a890ba6e3
PredicateExpression          : statement <> 'select 1'

Na

PS C:\> Get-AzSqlDatabaseAudit -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
ServerName                          : server01
DatabaseName                        : database01
AuditAction                         : {}
ResourceGroupName                   : resourcegroup01
AuditActionGroup                    : {SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP,
                                       BATCH_COMPLETED_GROUP, ...}
PredicateExpression                 : statement <> 'select 1'
BlobStorageTargetState              : Enabled
StorageAccountResourceId            : /subscriptions/7fe3301d-31d3-4668-af5e-211a890ba6e3/resourceGroups/resourcegroup01/providers/Microsoft.Storage/storageAccounts/mystorage
StorageKeyType                      : Primary
RetentionInDays                     : 0
EventHubTargetState                 : Enabled
EventHubName                        : eventHubName
EventHubAuthorizationRuleResourceId : EventHubAuthorizationRuleResourceId
LogAnalyticsTargetState             : Enabled
WorkspaceResourceId                 : "/subscriptions/4b9e8510-67ab-4e9a-95a9-e2f1e570ea9c/resourceGroups/insights-integration/providers/Microsoft.OperationalInsights/workspaces/viruela2"

Set-AzSqlDatabaseAuditing

• De cmdlet Set-AzSqlDatabaseAudit vervangt deze cmdlet.
• Het uitvoertype verandert van het bestaande type :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' in het nieuwe type :'bool'

Voor

Set-AzSqlDatabaseAuditing -State Enabled -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -StorageAccountName "Storage22" -DatabaseName "Database01"

Na

Set-AzSqlDatabaseAudit -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -BlobStorageTargetState Enabled -StorageAccountResourceId "/subscriptions/7fe3301d-31d3-4668-af5e-211a890ba6e3/resourceGroups/resourcegroup01/providers/Microsoft.Storage/storageAccounts/mystorage"

Get-AzSqlServerAuditing

• De cmdlet Get-AzSqlServerAudit vervangt deze cmdlet.
• Het uitvoertype verandert van het bestaande type :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' in het nieuwe type :'Microsoft.Azure.Commands.Sql.Auditing.Model.ServerAuditingSettingsModel'. Eigenschappen AuditState, StorageAccountNameen StorageAccountSubscriptionId worden verwijderd. Scripts die gebruikmaken van StorageAccountName en StorageAccountSubscriptionId proeprties kunnen deze informatie ophalen uit de nieuwe eigenschap StorageAccountResourceId.

Voor

PS C:\> Get-AzSqlServerAuditing -ResourceGroupName "resourcegroup01" -ServerName "server01"
AuditActionGroup             : {SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP, BATCH_COMPLETED_GROUP, ...}
ResourceGroupName            : resourcegroup01
ServerName                   : server01
AuditState                   : Enabled
StorageAccountName           : mystorage
StorageKeyType               : Primary
RetentionInDays              : 0
StorageAccountSubscriptionId : 7fe3301d-31d3-4668-af5e-211a890ba6e3
PredicateExpression          : statement <> 'select 1'

Na

PS C:\> Get-AzSqlServerAudit -ResourceGroupName "resourcegroup01" -ServerName "server01"
ServerName                          : server01
ResourceGroupName                   : resourcegroup01
AuditActionGroup                    : {SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP, BATCH_COMPLETED_GROUP, ...}
PredicateExpression                 : statement <> 'select 1'
BlobStorageTargetState              : Enabled
StorageAccountResourceId            : /subscriptions/7fe3301d-31d3-4668-af5e-211a890ba6e3/resourceGroups/resourcegroup01/providers/Microsoft.Storage/storageAccounts/mystorage
StorageKeyType                      : Primary
RetentionInDays                     : 0
EventHubTargetState                 : Enabled
EventHubName                        : eventHubName
EventHubAuthorizationRuleResourceId : EventHubAuthorizationRuleResourceId
LogAnalyticsTargetState             : Enabled
WorkspaceResourceId                 : "/subscriptions/4b9e8510-67ab-4e9a-95a9-e2f1e570ea9c/resourceGroups/insights-integration/providers/Microsoft.OperationalInsights/workspaces/viruela2"

Set-AzSqlServerAuditing

• De cmdlet Set-AzSqlServerAudit vervangt deze cmdlet.
• Het uitvoertype verandert van het bestaande type :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' in het nieuwe type :'bool'

Voor

Set-AzSqlServerAuditing -State Enabled -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -StorageAccountName "Storage22"

Na

PS C:\> Set-AzSqlServerAudit -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -BlobStorageTargetState Enabled -StorageAccountResourceId "/subscriptions/7fe3301d-31d3-4668-af5e-211a890ba6e3/resourceGroups/resourcegroup01/providers/Microsoft.Storage/storageAccounts/mystorage"

Get-AzSqlServerAdvancedThreatProtectionSettings

Cmdlet-Get-AzSqlServerAdvancedThreatProtectionSettings wordt vervangen door Get-AzSqlServerAdvancedThreatProtectionSetting

Voor

Get-AzSqlServerAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Na

Get-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Clear-AzSqlServerAdvancedThreatProtectionSettings

Cmdlet-Clear-AzSqlServerAdvancedThreatProtectionSettings wordt vervangen door Clear-AzSqlServerAdvancedThreatProtectionSetting

Voor

Clear-AzSqlServerAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Na

Clear-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Update-AzSqlServerAdvancedThreatProtectionSettings

Cmdlet-Update-AzSqlServerAdvancedThreatProtectionSettings wordt vervangen door Update-AzSqlServerAdvancedThreatProtectionSetting

Voor

Update-AzSqlServerAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability","SQL_Injection" -StorageAccountName "mystorageAccount"

Na

Update-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability","SQL_Injection" -StorageAccountName "mystorageAccount"

Get-AzSqlDatabaseAdvancedThreatProtectionSettings

Cmdlet-Get-AzSqlDatabaseAdvancedThreatProtectionSettings wordt vervangen door Get-AzSqlDatabaseAdvancedThreatProtectionSetting

Voor

Get-AzSqlDatabaseAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

Na

Get-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

Update-AzSqlDatabaseAdvancedThreatProtectionSettings

Cmdlet Update-AzSqlDatabaseAdvancedThreatProtectionSettings wordt vervangen door Update-AzSqlDatabaseAdvancedThreatProtectionSetting

Voor

Update-AzSqlDatabaseAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability", "SQL_Injection" -StorageAccountName "mystorageAccount"

Na

Update-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability", "SQL_Injection" -StorageAccountName "mystorageAccount"

Clear-AzSqlDatabaseAdvancedThreatProtectionSettings

Cmdlet Clear-AzSqlDatabaseAdvancedThreatProtectionSettings is vervangen door Clear-AzSqlDatabaseAdvancedThreatProtectionSetting

Voor

Clear-AzSqlDatabaseAdvancedThreatProtectionSettings -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

Na

Clear-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

Update-AzSqlDatabaseVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlDatabaseVulnerabilityAssessmentSettings wordt vervangen door Update-AzSqlDatabaseVulnerabilityAssessmentSetting

Voor

Update-AzSqlDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01"`
    -ServerName "Server01"`
    -DatabaseName "Database01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Na

Update-AzSqlDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01"`
    -ServerName "Server01"`
    -DatabaseName "Database01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Get-AzSqlDatabaseVulnerabilityAssessmentSettings

Cmdlet-Get-AzSqlDatabaseVulnerabilityAssessmentSettings wordt vervangen door Get-AzSqlDatabaseVulnerabilityAssessmentSetting

Voor

Get-AzSqlDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Get-AzSqlDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Clear-AzSqlDatabaseVulnerabilityAssessmentSettings

Cmdlet-Clear-AzSqlDatabaseVulnerabilityAssessmentSettings wordt vervangen door Clear-AzSqlDatabaseVulnerabilityAssessmentSetting

Voor

Clear-AzSqlDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Clear-AzSqlDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings

Cmdlet-Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings is vervangen door Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Voor

Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -InstanceName "ManagedInstance01" `
    -DatabaseName "Database01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Na

Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -InstanceName "ManagedInstance01" `
    -DatabaseName "Database01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings

Cmdlet-Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings wordt vervangen door Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Voor

Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings

Cmdlet-Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings wordt vervangen door Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Voor

Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Update-AzSqlInstanceVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlInstanceVulnerabilityAssessmentSettings is vervangen door Update-AzSqlInstanceVulnerabilityAssessmentSetting

Voor

Update-AzSqlInstanceVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -InstanceName "ManagedInstance01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Na

Update-AzSqlInstanceVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -InstanceName "ManagedInstance01" `
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Get-AzSqlInstanceVulnerabilityAssessmentSettings

Cmdlet Get-AzSqlInstanceVulnerabilityAssessmentSettings is vervangen door Get-AzSqlInstanceVulnerabilityAssessmentSetting

Voor

Get-AzSqlInstanceVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Get-AzSqlInstanceVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Clear-AzSqlInstanceVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlInstanceVulnerabilityAssessmentSettings is vervangen door Clear-AzSqlInstanceVulnerabilityAssessmentSetting

Voor

Clear-AzSqlInstanceVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Clear-AzSqlInstanceVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Update-AzSqlServerVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlServerVulnerabilityAssessmentSettings is vervangen door Update-AzSqlServerVulnerabilityAssessmentSetting

Voor

Update-AzSqlServerVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01"`
    -ServerName "Server01"`
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Na

Update-AzSqlServerVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01"`
    -ServerName "Server01"`
    -StorageAccountName "mystorage" `
    -ScanResultsContainerName "vulnerability-assessment" `
    -RecurringScansInterval Weekly `
    -EmailSubscriptionAdmins $true `
    -NotificationEmail @("mail1@mail.com" , "mail2@mail.com")

Get-AzSqlServerVulnerabilityAssessmentSettings

Cmdlet Get-AzSqlServerVulnerabilityAssessmentSettings wordt vervangen door Get-AzSqlServerVulnerabilityAssessmentSetting

Voor

Get-AzSqlServerVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Get-AzSqlServerVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Clear-AzSqlServerVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlServerVulnerabilityAssessmentSettings wordt vervangen door Clear-AzSqlServerVulnerabilityAssessmentSetting

Voor

Clear-AzSqlServerVulnerabilityAssessmentSettings `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Na

Clear-AzSqlDatabaseVulnerabilityAssessmentSetting `
    -ResourceGroupName "ResourceGroup01" `
    -ServerName "Server01" `
    -DatabaseName "Database01"

Get-AzSqlServerAdvancedThreatProtectionPolicy

Cmdlet Get-AzSqlServerAdvancedThreatProtectionPolicy wordt verwijderd en er komt geen cmdlet voor in de plaats.

Get-AzSqlServerThreatDetectionPolicy

Cmdlet Get-AzSqlServerThreatDetectionPolicy is vervangen door Get-AzSqlServerThreatDetectionSetting

Voor

PS C:\> Get-AzSqlServerThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01"
ResourceGroupName            : ResourceGroup11
ServerName                   : Server01
ThreatDetectionState         : Enabled
NotificationRecipientsEmails : admin@myCompany.com
StorageAccountName           : mystorage
EmailAdmins                  : True
ExcludedDetectionTypes       : {}
RetentionInDays              : 0

Na

PS C:\> Get-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01"
ResourceGroupName            : ResourceGroup11
ServerName                   : Server01
ThreatDetectionState         : Enabled
NotificationRecipientsEmails : admin@myCompany.com
StorageAccountName           : mystorage
EmailAdmins                  : True
ExcludedDetectionTypes       : {}
RetentionInDays              : 0

Remove-AzSqlServerThreatDetectionPolicy

Cmdlet Remove-AzSqlServerThreatDetectionPolicy wordt vervangen door Clear-AzSqlServerAdvancedThreatProtectionSetting

Voor

Remove-AzSqlServerThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Na

Clear-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Set-AzSqlServerThreatDetectionPolicy

Cmdlet Set-AzSqlServerThreatDetectionPolicy wordt vervangen door Update-AzSqlServerAdvancedThreatProtectionSetting

Voor

Set-AzSqlServerThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability","SQL_Injection" -StorageAccountName "mystorageAccount"

Na

Update-AzSqlServerAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability","SQL_Injection" -StorageAccountName "mystorageAccount"

Get-AzSqlDatabaseThreatDetectionPolicy

Cmdlet-Get-AzSqlDatabaseThreatDetectionPolicy wordt vervangen door Get-AzSqlDatabaseThreatDetectionSetting

Voor

PS C:\> Get-AzSqlDatabaseThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName   "Database01"
DatabaseName                 : Database01
ResourceGroupName            : ResourceGroup11
ServerName                   : Server01
ThreatDetectionState         : Enabled
NotificationRecipientsEmails : admin@myCompany.com
StorageAccountName           : mystorage
EmailAdmins                  : True
ExcludedDetectionTypes       : {}
RetentionInDays              : 0

Na

PS C:\> Get-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01"   -DatabaseName "Database01"
DatabaseName                 : Database01
ResourceGroupName            : ResourceGroup11
ServerName                   : Server01
ThreatDetectionState         : Enabled
NotificationRecipientsEmails : admin@myCompany.com
StorageAccountName           : mystorage
EmailAdmins                  : True
ExcludedDetectionTypes       : {}
RetentionInDays              : 0

Set-AzSqlDatabaseThreatDetectionPolicy

Cmdlet Set-AzSqlDatabaseThreatDetectionPolicy is vervangen door Update-AzSqlDatabaseAdvancedThreatProtectionSetting

Voor

Set-AzSqlDatabaseThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability", "SQL_Injection" -StorageAccountName "mystorageAccount"

Na

Update-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01" -NotificationRecipientsEmails "admin01@contoso.com;secadmin@contoso.com" -EmailAdmins $False -ExcludedDetectionType "Sql_Injection_Vulnerability", "SQL_Injection" -StorageAccountName "mystorageAccount"

Remove-AzSqlDatabaseThreatDetectionPolicy

Cmdlet Remove-AzSqlDatabaseThreatDetectionPolicy is vervangen door Clear-AzSqlDatabaseAdvancedThreatProtectionSetting

Voor

Remove-AzSqlDatabaseThreatDetectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"

Na

Clear-AzSqlDatabaseAdvancedThreatProtectionSetting -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -DatabaseName "Database01"