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": {}
}