The uppercase VulnerabilityAssessmentName returned by the DatabaseVulnerabilityAssessments_CreateOrUpdate API

[sinbai]

When creating a DatabaseVulnerabilityAssessments resource. The value of VulnerabilityAssessmentName is fixed as "default" , but the name in response body is "Default". details:

The response body is:

{
  "properties": {
    "storageContainerPath": "https://accsa.blob.core.windows.net/testsc/",
    "recurringScans": {
      "isEnabled": false,
      "emailSubscriptionAdmins": true,
      "emails": []
    }
  },
  "id": "/subscriptions/xxx/resourceGroups/testRG-mssql/providers/Microsoft.Sql/servers/testsqlserver/databases/testdb/vulnerabilityAssessments/Default",
  "name": "Default",
  "type": "Microsoft.Sql/servers/databases/vulnerabilityAssessments"
}

Actual: The "name" in response body is "Default". The VulnerabilityAssessmentName of "id" in response body is "Default".
Expected: All VulnerabilityAssessmentName in response body should be "default".

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

Issue Details

---

When creating a DatabaseVulnerabilityAssessments resource. The value of VulnerabilityAssessmentName is fixed as "default" , but the name in response body is "Default". details:

The response body is:

{
  "properties": {
    "storageContainerPath": "https://accsa.blob.core.windows.net/testsc/",
    "recurringScans": {
      "isEnabled": false,
      "emailSubscriptionAdmins": true,
      "emails": []
    }
  },
  "id": "/subscriptions/xxx/resourceGroups/testRG-mssql/providers/Microsoft.Sql/servers/testsqlserver/databases/testdb/vulnerabilityAssessments/Default",
  "name": "Default",
  "type": "Microsoft.Sql/servers/databases/vulnerabilityAssessments"
}

Actual: The "name" in response body is "Default". The VulnerabilityAssessmentName of "id" in response body is "Default".
Expected: All VulnerabilityAssessmentName in response body should be "default".

Author:	sinbai
Assignees:	-
Labels:	question, SQL, Service Attention, customer-reported, needs-triage
Milestone:	-

[MrImpossibru]

@ruowan will this be fixed soon? It broke managing Azure SQL VAs via Terraform. Thanks.

[catt231]

agreed this is forcing replacements of resources and creating noise in my pipelines I don't need... would love to see it resolved soon please

[krohm]

Any progress on that ?