Support AzureRm powershell sending database/server audit logs to write to Log Analytics
Azure Automation account still dont fully support Az modules. It is very hard to setup a new Automation account with Az only.
I have a lot of Runbooks written using AzureRm and would like the RM to be updated to include the log analytics workspace instead of only storage.
AZ command: (supports Log Analytics)
AzureRm Command: (does not support Log Analytics)
Yes it is very useful and must have it
It could be a UI glitch on new Set-AzSqlServerAudit commandlet.
As the log analytics config appeared after a reopened the browser.
But this one doesnt connect and Ui does NOT change
Set-AzDiagnosticSetting does not work At all.
I dont have access issues as i am Global admin
The DB Audit does not apply log analytics either :(
Set-AzSqlDatabaseAudit -ResourceGroupName $resourceRG -ServerName $resourceParent -DatabaseName $resourceName -LogAnalyticsTargetState Enabled -WorkspaceResourceId $LogAnalytics_URI -debug
The new command switches on the audit.
but Does NOT apply the Log analytics config.
There are no errors.
i tried this command on cloud shell.
Set-AzSqlServerAudit -ResourceGroupName $resourceRG -ServerName $resourceName -LogAnalyticsTargetState Enabled -WorkspaceResourceId $LogAnalytics_URI