Azure SQL Firewall Rules IP parameters missing

[girolamom]

We are trying to help a customer using AzOps to Backup their Azure Infrastructure ARM configuration. The AIM is to have history of the changes in case of accidental deletion.

We found the JSON generated form the tool missing a parameter in case of Firewall Rules applied to an Azure SQL.

To reproduce:

• Create an Azure SQL
• Apply a Firewall rule with a source IP Address.
• Find the Source IP address in the generated JSON.

Here the resource in the portal:

Here the generated JSON:

{ "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#", "contentVersion": "1.0.0.0", "metadata": { "_generator": { "name": "AzOps" } }, "parameters": {}, "variables": {}, "resources": [ { "apiVersion": "2022-05-01-preview", "name": "deletedbtest/ClientIPAddress_2023-3-1_15-26-4", "type": "Microsoft.Sql/servers/firewallRules" } ], "outputs": {} }

[Jefajers]

Thank you for reporting this!

I confirm that we see the same behavior. Ideally it should contain the additional properties

Example from Azure Portal Export (missing additional properties):

We are striving to support all resource providers in pull, but also rely on that the RPs return all the correct schema. We are currently working on improving this to enable higher quality, but for now, it is best effort.