[Enter feedback here]
For commands:
-
az sql server audit-policy show
a) All parameters are listed as optional parameters: [--ids] [--name] [--resource-group] [--subscription]. There are no required parameters. However, to execute the command the following parameters are required: (--name --resource-group | --ids).
b) There is no user example, unlike in the update and wait commands below, on how to run this command.
-
az sql server audit-policy update
a) Executing the command without specifying any parameters gives this output: "(--name --resource-group | --ids) are required". Executing the same command again, but this time adding in the --name and --resource-group parameters returns this output: "Either state or blob storage or log analytics or event hub arguments are missing". From the documentation, required parameters are not specified and all parameters listed are stated as optional.
b) Example: "az sql server audit-policy update -g mygroup -n myserver
--actions FAILED_DATABASE_AUTHENTICATION_GROUP 'UPDATE on server::myserver by public'" returns the message: "Either state or blob storage or log analytics or event hub arguments are missing"
c) Example: "az sql server audit-policy update -g mygroup -n myserver --bsts Disabled" returns the message: "(DataSecurityInvalidUserSuppliedParameter) Invalid parameter 'storageEndpoint'. Value should be a blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net)."
-
az sql server audit-policy wait
a) Executing the command without specifying any parameters gives this output: "(--name --resource-group | --ids) are required". The parameters, --name, --resource-group, and --ids are all listed as optional parameters but this is not the case as they are required.
It is not very clear and there are no examples on how to use the --ids parameter. This applies to all options - show, wait and update.
Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
[Enter feedback here]
For commands:
az sql server audit-policy show
a) All parameters are listed as optional parameters: [--ids] [--name] [--resource-group] [--subscription]. There are no required parameters. However, to execute the command the following parameters are required: (--name --resource-group | --ids).
b) There is no user example, unlike in the update and wait commands below, on how to run this command.
az sql server audit-policy update
a) Executing the command without specifying any parameters gives this output: "(--name --resource-group | --ids) are required". Executing the same command again, but this time adding in the --name and --resource-group parameters returns this output: "Either state or blob storage or log analytics or event hub arguments are missing". From the documentation, required parameters are not specified and all parameters listed are stated as optional.
b) Example: "az sql server audit-policy update -g mygroup -n myserver
--actions FAILED_DATABASE_AUTHENTICATION_GROUP 'UPDATE on server::myserver by public'" returns the message: "Either state or blob storage or log analytics or event hub arguments are missing"
c) Example: "az sql server audit-policy update -g mygroup -n myserver --bsts Disabled" returns the message: "(DataSecurityInvalidUserSuppliedParameter) Invalid parameter 'storageEndpoint'. Value should be a blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net)."
az sql server audit-policy wait
a) Executing the command without specifying any parameters gives this output: "(--name --resource-group | --ids) are required". The parameters, --name, --resource-group, and --ids are all listed as optional parameters but this is not the case as they are required.
It is not very clear and there are no examples on how to use the --ids parameter. This applies to all options - show, wait and update.
Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.