SQL managed Instances

[pattisanta]

I am trying to set resource symbolicname 'Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/rules/baselines@2022-05-01-preview' = {
name: 'string'
parent: resourceSymbolicName
properties: {
baselineResults: [
{
result: [
'string'
]
}
]
}
}

the issue I am having I can't find the parent . My understanding of the messages I am getting in my vscode is it wants 'Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/rules@somthing . I can't find it at all. Can someone point me to the right direction?

Thanks,
Patti

[johnlokerse]

It looks like the resource type 'rules' doesn't exist. So this means that referencing a parent using the property doesn't work, because the resource cannot be defined with a symbolic name. You can work with the name though:

resource resBaseline 'Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/rules/baselines@2023-02-01-preview' = {
  name: '<managed instance name>/<database name>/<vulnerability assessment name>/rules/<baseline name here>'
  properties: {
    ... properties here ....
  }
}

What we did in the example is we build up the "path" in the name property and we segmented it using the /. The amount of segments are equals to the amount of parents the 'baseline' resource type has. This way we can reference the parent 'rules'.

Hope this works for you!

[marsontret]

There are different patterns for declaring child resources in bicep. See: https://learn.microsoft.com/en-us/azure/azure-resource-manager/bicep/child-resource-name-type

If you declare the child resource outside of the parent resource declaration, you either set the resource deployment scope by using the 'parent' property, or use the / syntax, by which you show the relationship between all of elements that make up a resource using a slash delimited list. The number of segments in the name corresponds to the number of segments (slashes) after the base namespace (Microsoft.Sql, for example). Both are described in the document referenced above.

Per documentation there is no discrete rules type - see it as more of a namespace and within you create named baselines.

Taking the above, the 'Microsoft.Sql/managedIntances/databeses/vulnerabilityAssessments/rules/baselines' name will be written as: {managedInstances name}/{datababes name}/default/rules/{baselines name}.