Set-AzSqlServerAudit not working for LogAnalytics workspace generates error in latest version of Az.sql (4.2.0)

[ar3c]

Description

Running the PowerShell command to configure auditing generated an error. The same command works in version 4.1.0 of Az.sql.

Set-AzSqlServerAudit -ResourceGroupName "myrg" -ServerName "myserver" -LogAnalyticsTargetState Enabled -WorkspaceResourceId "/subscriptions/xxxxxxxxxx/resourcegroups/myrg/providers/microsoft.operationalinsights/workspaces/mywsnamehere

The error states that Workspace resource id not provided.

Issue script & Debug output

The error states that Workspace resource id not provided.

Environment data

Name                           Value                                                                                                                                                                                                                             
----                           -----                                                                                                                                                                                                                             
PSVersion                      5.1.19041.2364                                                                                                                                                                                                                    
PSEdition                      Desktop                                                                                                                                                                                                                           
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                                           
BuildVersion                   10.0.19041.2364                                                                                                                                                                                                                   
CLRVersion                     4.0.30319.42000                                                                                                                                                                                                                   
WSManStackVersion              3.0                                                                                                                                                                                                                               
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                                               
SerializationVersion           1.1.0.1

Module versions

cript     2.11.1     Az.Accounts                         {Add-AzEnvironment, Clear-AzConfig, Clear-AzContext, Clear-AzDefault...}                                                                                                                               
Script     4.2.0      Az.Sql                              {Add-AzSqlDatabaseToFailoverGroup, Add-AzSqlElasticJobStep, Add-AzSqlElasticJobTarget, Add-AzSqlInstanceKeyVaultKey...}

Error output

The error states that Workspace resource id not provided.

Thank you for your feedback. This has been routed to the support team for assistance.

[RakeshMohanMSFT]

@ar3c We are unable to reproduce this issue at our end. Please see below screenshot, can you please share the debug trace for this issue?
Set-AzSqlServerAudit -ResourceGroupName "Issue20703" -ServerName "issuer20703sqlserver" -LogAnalyticsTargetState Enabled -WorkspaceResourceId "/subscriptions/<subid>/resourcegroups/issue20703/providers/microsoft.operationalinsights/workspaces/issue20703workspace"

[ar3c]

Debug Output:
PS C:> Set-AzSqlServerAudit -ResourceGroupName '--REMOVED--' -ServerName '--REMOVED--' -LogAnalyticsTargetState Enabled -WorkspaceResourceId '/subscriptions/--REMOVED--/resourcegroups/--REMOVED--/providers/--REMOVED--'
DEBUG: 8:41:58 AM - SetAzSqlServerAudit begin processing with ParameterSet 'ServerParameterSet'.
DEBUG: 8:41:58 AM - using account id '--REMOVED--'...
DEBUG: 8:41:58 AM - [ConfigManager] Got nothing from [DisplayBreakingChangeWarning], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: ============================ HTTP REQUEST ============================

DEBUG: 8:41:58 AM - [ConfigManager] Got nothing from [EnableDataCollection], Module = [], Cmdlet = []. Returning default value [True].
Set-AzSqlServerAudit : Workspace resource id is not provided
At line:1 char:1

• Set-AzSqlServerAudit -ResourceGroupName '--REMOVED--' ...

•   + CategoryInfo          : CloseError: (:) [Set-AzSqlServerAudit], PSArgumentException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.Auditing.Cmdlet.SetAzSqlServerAudit
  
  

DEBUG: 8:41:59 AM - [ConfigManager] Got nothing from [DisplayBreakingChangeWarning], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: AzureQoSEvent: Module: Az.Sql:4.2.0; CommandName: Set-AzSqlServerAudit; PSVersion: 5.1.19041.2364; IsSuccess: False; Duration: 00:00:00.7394845; Exception: Workspace resource id is not provided;
DEBUG: 8:41:59 AM - SetAzSqlServerAudit end processing.

Resolve-AzError Output
PS C:> Resolve-AzError
DEBUG: 8:47:04 AM - ResolveError begin processing with ParameterSet 'AnyErrorParameterSet'.
DEBUG: 8:47:04 AM - using account id '--REMOVED--'...
DEBUG: 8:47:04 AM - [ConfigManager] Got nothing from [DisplayBreakingChangeWarning], Module = [], Cmdlet = []. Returning default value [True].
WARNING: Upcoming breaking changes in the cmdlet 'Resolve-AzError' :
The Resolve-Error alias will be removed in a future release. Please change any scripts that use this alias to use Resolve-AzError instead.
Note : Go to https://aka.ms/azps-changewarnings for steps to suppress this breaking change warning, and other information on breaking changes in Azure PowerShell.

HistoryId: 12

Message : Workspace resource id is not provided
StackTrace : at Microsoft.Azure.Commands.Sql.Auditing.Services.SqlAuditAdapter2.VerifyAuditBeforePersistChanges(AuditModelType model) at Microsoft.Azure.Commands.Sql.Auditing.Services.SqlAuditAdapter2.PersistAuditChanges(AuditModelType model)
at Microsoft.Azure.Commands.Sql.Auditing.Cmdlet.SetSqlServerAuditCmdlet3.PersistChanges(ServerAuditModelType entity) at Microsoft.Azure.Commands.Sql.Common.AzureSqlCmdletBase2.<>c__DisplayClass16_0.b__0()
at Microsoft.WindowsAzure.Commands.Utilities.Common.AzurePSCmdlet.ConfirmAction(String processMessage, String target, Action action)
at Microsoft.Azure.Commands.Sql.Common.AzureSqlCmdletBase`2.ExecuteCmdlet()
at Microsoft.WindowsAzure.Commands.Utilities.Common.AzurePSCmdlet.ProcessRecord()
Exception : System.Management.Automation.PSArgumentException
InvocationInfo : {Set-AzSqlServerAudit}
Line : Set-AzSqlServerAudit -ResourceGroupName '--REMOVED--' -ServerName '--REMOVED--' -LogAnalyticsTargetState Enabled -WorkspaceResourceId
'/subscriptions/--REMOVED--/resourcegroups/--REMOVED--/providers/microsoft.operationalinsights/workspaces/--REMOVED--'
Position : At line:1 char:1
+ Set-AzSqlServerAudit -ResourceGroupName '--REMOVED--' ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HistoryId : 12

DEBUG: AzureQoSEvent: Module: Az.Accounts:2.11.1; CommandName: Resolve-AzError; PSVersion: 5.1.19041.2364; IsSuccess: True; Duration: 00:00:00.0605361
DEBUG: 8:47:04 AM - [ConfigManager] Got nothing from [EnableDataCollection], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 8:47:04 AM - ResolveError end processing.