Request a sample Diagnostics setting for enabling auditing for SQL server to send logs to existing Loganalytics workspace(aso v2)

[Blueberrish]

Describe the current behavior

_A sample code is shared where the audit logs are redirected to storage account:https://github.com/Azure/azure-service-operator/blob/main/v2/samples/sql/v1api20211101/v1api20211101_serversauditingsetting.yaml

Can you please share the edited version where audit logs for sql server are redirected to existing loganalytics workspace
I went through the documentation , fields are not clearly explaining which field to use for enabling log. As part of my understanding I have enabled auditing settings with 'Enabled' state and set 'IsAzureMonitorTargetEnabled . Currently am seeing the destination of audit logs is not set.
In page https://learn.microsoft.com/en-us/samples/azure/azure-quickstart-templates/sql-auditing-server-policy-to-oms/ : it is mentioned to configure Diagnostic Settings as well with 'SQLSecurityAuditEvents' diagnostic logs category on the 'master' database (for server level auditing).Please elaborate on this.

Describe the improvement

Please share a sample with combination of auditsetting and diagnosticssettings for enabling audit logs for SQL server and send the destination logs to existing log analytics workspace using aso v2 helm chart.

Additional context

I tried this combination but some information on the master database seemed little unclear when i want to enable currently for sqlserver. I get some errors when category or category groups are mentioned as not existing e.g allLogs as value. Please share a sample aso v2 helm chart for this.
Thanks in advance .

[Blueberrish]

Hi , is it possible to set this with combination of auditsetting and diagnosticssettings for enabling audit logs for SQL server and send the destination logs to existing log analytics workspace using aso v2 helm chart ?