Panduan Migrasi untuk Az 3.0.0

Dokumen ini menjelaskan perubahan antara Az versi 2.0.0 dan 3.0.0

• Panduan Migrasi untuk Az 3.0.0
  • Batch
    • Get-AzBatchNodeAgentSku
    • Ketidakcocokan dengan versi Az.Resources sebelumnya
  • Compute
    • 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
  • Sumber
    • Ketidakcocokan dengan versi Az.Batch sebelumnya
  • 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

• Menghapus Get-AzBatchNodeAgentSku dan menggantinya dengan Get-AzBatchSupportedImage.
• Get-AzBatchSupportedImage menampilkan data yang sama dengan Get-AzBatchNodeAgentSku, tetapi dalam format yang lebih ramah.
• Gambar baru yang tidak diverifikasi juga sekarang ditampilkan. Informasi tambahan mengenai Capabilities dan BatchSupportEndOfLife untuk setiap gambar juga disertakan.

Sebelumnya

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

Sesudahnya

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

Ketidakcocokan Versi Sebelumnya dengan Modul Az.Resources

Versi 2.0.1 modul ‘Az.Batch’ tidak cocok dengan modul ‘Az.Resources’ versi sebelumnya (versi 1.7.0 atau lebih lama). Hal ini akan mengakibatkan ketidakmampuan untuk mengimpor versi 1.7.0 modul ‘Az.Resources’ jika versi 2.0.1 modul ‘Az.Batch’ diimpor. Untuk memperbaiki masalah ini, cukup perbarui modul ‘Az.Resources’ ke versi 1.7.1 atau yang lebih tinggi, atau instal versi modul ‘Az’ terbaru.

Compute

New-AzDiskConfig

Parameter UploadSizeInBytes digunakan, bukan DiskSizeGB, untuk New-AzDiskConfig ketika CreateOption Diunggah

Sebelumnya

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

Sesudahnya

$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

• Memperbarui cmdlet Get-AzHDInsightJobOutput untuk mendukung akses berbasis peran granular ke kunci penyimpanan.
• Pengguna dengan peran Operator Kluster HDInsight, Kontributor, atau Pemilik tidak akan terpengaruh.
• Pengguna dengan peran Pembaca saja perlu menentukan parameter DefaultStorageAccountKey secara eksplisit.

Sebelumnya

Get-AzHDInsightJobOutput  -ClusterName $clusterName -JobId $jobId

Sesudahnya

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

Add-AzHDInsightConfigValues

Cmdlet Add-AzHDInsightConfigValue menghapus alias untuk Add-AzHDInsightConfigValues.

Sebelumnya

Menggunakan alias yang tidak digunakan lagi

Add-AzHDInsightConfigValues

Sesudahnya

Add-AzHDInsightConfigValue

Disable-AzHDInsightMonitoring

Menambahkan cmdlet Disable-AzHDInsightMonitoring baru. Gunakan cmdlet ini untuk menonaktifkan pemantauan di kluster HDInsight (mengganti Disable-AzHDInsightOperationsManagementSuite dan Disable-AzHDInsightOMS).

Sebelumnya

Disable-AzHDInsightOMS -Name testcluster

Disable-AzHDInsightOperationsManagementSuite -Name testcluster

Sesudahnya

Disable-AzHDInsightMonitoring -Name testcluster

Enable-AzHDInsightMonitoring

Menambahkan cmdlet Enable-AzHDInsightMonitoring baru. Gunakan cmdlet ini untuk mengaktifkan pemantauan di kluster HDInsight (mengganti Enable-AzHDInsightOperationsManagementSuite dan Enable-AzHDInsightOMS).

Sebelumnya

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>

Sesudahnya

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

Get-AzHDInsightMonitoring

Menambahkan cmdlet Get-AzHDInsightMonitoring baru. Gunakan cmdlet ini untuk mendapatkan status pemantauan penginstalan di kluster Azure HDInsight (mengganti Get-AzHDInsightOperationsManagementSuite dan Get-AzHDInsightOMS).

Sebelumnya

Get-AzHDInsightOMS -Name testcluster

Get-AzHDInsightOperationsManagementSuite -Name testcluster

Sesudahnya

Get-AzHDInsightMonitoring -Name testcluster

Get-AzHDInsightProperty

Cmdlet Get-HDInsightProperty menghapus alias untuk Get-AzHDInsightProperties.

Sebelumnya

Menggunakan alias yang tidak digunakan lagi

Get-AzHDInsightProperties -Location "East US 2"

Sesudahnya

Get-AzHDInsightProperty -Location "East US 2"

Grant-AzHDInsightRdpServicesAccess

Menghapus cmdlet Grant-AzHDInsightRdpServicesAccess dan Revoke-AzHDInsightRdpServicesAccess. Cmdlet ini tidak lagi diperlukan karena kluster yang menggunakan jenis OS Windows tidak didukung. Sebagai gantinya, buat kluster yang menggunakan jenis OS Linux.

Remove-AzHDInsightCluster

Jenis output Remove-AzHDInsightCluster berubah dari Microsoft.Azure.Management.HDInsight.Models.ClusterGetResponse menjadi bool.

Sebelumnya

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

Sesudahnya

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

Revoke-AzHDInsightRdpServicesAccess

Cmdlet tidak digunakan lagi. Tidak ada pengganti untuk cmdlet ini.

Set-AzHDInsightGatewayCredential

Jenis output Set-AzHDInsightGatewayCredential berubah dari HttpConnectivitySettings menjadi AzureHDInsightGatewaySettings.

IotHub

New-AzIotHubImportDevices

Alias ini dihapus, gunakan New-AzIotHubImportDevice sebagai gantinya.

Sebelumnya

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"

Sesudahnya

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

Alias ini dihapus, gunakan New-AzIotHubExportDevice sebagai gantinya.

Sebelumnya

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

Sesudahnya

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 tidak digunakan lagi tanpa diganti karena IotHub dilengkapi dengan hanya satu titik akhir bawaan ("peristiwa") yang dapat menangani sistem dan pesan perangkat.

Sebelumnya

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

Sesudahnya

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

Get-AzIotHubEventHubConsumerGroup

Parameter EventHubEndPointName tidak digunakan lagi tanpa diganti karena IotHub dilengkapi dengan hanya satu titik akhir bawaan ("peristiwa") yang dapat menangani sistem dan pesan perangkat.

Sebelumnya

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

Sesudahnya

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

Remove-AzIotHubEventHubConsumerGroup

Parameter EventHubEndPointName tidak digunakan lagi tanpa diganti karena IotHub dilengkapi dengan hanya satu titik akhir bawaan ("peristiwa") yang dapat menangani sistem dan pesan perangkat.

Sebelumnya

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

Sesudahnya

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

Set-AzIotHub

Parameter OperationsMonitoringProperties tidak digunakan lagi tanpa diganti karena IotHub tidak lagi menggunakan titik akhir bawaan ("operationsMonitoringEvents").

RecoveryServices

Edit-AzRecoveryServicesAsrRecoveryPlan

ASRRecoveryPlanGroup.ReplicationProtectedItems, ASRRecoveryPlanGroup.StartGroupActions, dan ASRRecoveryPlanGroup.EndGroupActions dihapus dari output.

Get-AzRecoveryServicesAsrRecoveryPlan

ASRRecoveryPlanGroup.ReplicationProtectedItems, ASRRecoveryPlanGroup.StartGroupActions, dan ASRRecoveryPlanGroup.EndGroupActions dihapus dari output.

New-AzRecoveryServicesAsrReplicationProtectedItem

Parameter IncludeDiskId diubah untuk mendukung penulisan langsung ke disk terkelola di Azure Site Recovery.

Sebelumnya

$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

Sesudahnya

$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

Sumber

Ketidakcocokan Versi Sebelumnya dengan Modul Az.Batch

Versi 1.7.1 modul ‘Az.Resources’ tidak cocok dengan modul ‘Az.Batch’ versi sebelumnya (versi 1.1.2 atau lebih lama). Hal ini akan mengakibatkan ketidakmampuan untuk mengimpor versi 1.1.2 modul ‘Az.Batch’ jika versi 1.7.1 modul ‘Az.Resources’ diimpor. Untuk memperbaiki masalah ini, perbarui modul ‘Az.Batch’ ke versi 2.0.1 atau yang lebih tinggi, atau cukup instal versi modul ‘Az’ terbaru.

ServiceFabric

Add-ServiceFabricApplicationCertificate

Menghapus Add-ServiceFabricApplicationCertificate karena skenario ini dicakup dengan Add-AzVmssSecret.

Sebelumnya

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

Sesudahnya

$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

Perhatikan bahwa koneksi yang aman tidak digunakan lagi sehingga perintah dihapus. Gunakan bilah database SQL di portal Azure untuk menampilkan string koneksi

Get-AzSqlDatabaseIndexRecommendations

Alias Get-AzSqlDatabaseIndexRecommendations dihapus. Gunakan Get-AzSqlDatabaseIndexRecommendation sebagai gantinya.

Get-AzSqlDatabaseRestorePoints

Alias Get-AzSqlDatabaseRestorePoints dihapus. Gunakan Get-AzSqlDatabaseRestorePoint sebagai gantinya.

Get-AzSqlDatabaseAuditing

• Cmdlet Get-AzSqlDatabaseAudit menggantikan cmdlet ini.
• Jenis output berubah dari jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' yang ada menjadi jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseAuditingSettingsModel' baru, yang menghapus properti AuditState dan StorageAccountName. dan StorageAccountSubscriptionId. Skrip dapat mengambil informasi akun penyimpanan dari properti StorageAccountResourceId baru.

Sebelumnya

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'

Sesudahnya

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

• Cmdlet Set-AzSqlDatabaseAudit menggantikan cmdlet ini.
• Jenis output berubah dari jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' yang ada menjadi jenis :'bool' baru

Sebelumnya

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

Sesudahnya

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

• Cmdlet Get-AzSqlServerAudit menggantikan cmdlet ini.
• Jenis output berubah dari jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' yang ada menjadi jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.ServerAuditingSettingsModel' baru. Properti AuditState, StorageAccountName, dan StorageAccountSubscriptionId dihapus. Skrip yang menggunakan properti StorageAccountName dan StorageAccountSubscriptionId dapat mengambil informasi ini dari properti StorageAccountResourceId baru.

Sebelumnya

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'

Sesudahnya

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

• Cmdlet Set-AzSqlServerAudit menggantikan cmdlet ini.
• Jenis output berubah dari jenis :'Microsoft.Azure.Commands.Sql.Auditing.Model.DatabaseBlobAuditingSettingsModel' yang ada menjadi jenis :'bool' baru

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlServerAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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

Clear-AzSqlServerAdvancedThreatProtectionSettings

Cmdlet Clear-AzSqlServerAdvancedThreatProtectionSettings diganti dengan Clear-AzSqlServerAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlServerAdvancedThreatProtectionSettings

Cmdlet Update-AzSqlServerAdvancedThreatProtectionSettings diganti dengan Update-AzSqlServerAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlDatabaseAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlDatabaseAdvancedThreatProtectionSettings

Cmdlet Update-AzSqlDatabaseAdvancedThreatProtectionSettings diganti dengan Update-AzSqlDatabaseAdvancedThreatProtectionSetting

Sebelumnya

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"

Sesudahnya

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 diganti dengan Clear-AzSqlDatabaseAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlDatabaseVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlDatabaseVulnerabilityAssessmentSettings diganti dengan Update-AzSqlDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Clear-AzSqlDatabaseVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlDatabaseVulnerabilityAssessmentSettings diganti dengan Clear-AzSqlDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings diganti dengan Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings diganti dengan Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlInstanceVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlInstanceVulnerabilityAssessmentSettings diganti dengan Update-AzSqlInstanceVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlInstanceVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Clear-AzSqlInstanceVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlInstanceVulnerabilityAssessmentSettings diganti dengan Clear-AzSqlInstanceVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Update-AzSqlServerVulnerabilityAssessmentSettings

Cmdlet Update-AzSqlServerVulnerabilityAssessmentSettings diganti dengan Update-AzSqlServerVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlServerVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Clear-AzSqlServerVulnerabilityAssessmentSettings

Cmdlet Clear-AzSqlServerVulnerabilityAssessmentSettings diganti dengan Clear-AzSqlServerVulnerabilityAssessmentSetting

Sebelumnya

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

Sesudahnya

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

Get-AzSqlServerAdvancedThreatProtectionPolicy

Cmdlet Get-AzSqlServerAdvancedThreatProtectionPolicy dihapus dan tidak ada cmdlet yang menggantikannya

Get-AzSqlServerThreatDetectionPolicy

Cmdlet Get-AzSqlServerThreatDetectionPolicy diganti dengan Get-AzSqlServerThreatDetectionSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Clear-AzSqlServerAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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

Set-AzSqlServerThreatDetectionPolicy

Cmdlet Set-AzSqlServerThreatDetectionPolicy diganti dengan Update-AzSqlServerAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Get-AzSqlDatabaseThreatDetectionSetting

Sebelumnya

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

Sesudahnya

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 diganti dengan Update-AzSqlDatabaseAdvancedThreatProtectionSetting

Sebelumnya

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"

Sesudahnya

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 diganti dengan Clear-AzSqlDatabaseAdvancedThreatProtectionSetting

Sebelumnya

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

Sesudahnya

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