Azure / Azure/Azure-Proactive-Resiliency-Library-v2

💡 Feature Request - Backup on SQL Virtual Machine

Open
#396 1 comment 0 reactions 0 assignees View on GitHub
Area: Resource Graph Query(s) :hash: Area: Resource Guidance :memo: Enhancement :new: Needs: Attention from aprl-sql :wave:
Dominant language
No language data
Stars
105
Forks
125
Avg merge
20m
Merged PRs (30d)
7

Description

Current script does not check for this, and I missed it for one of my customers which is not good for both customer and Microsoft. Please consider adding this query that checks for SQL virtual machine backup into the APRL script:

resources
| where type == "microsoft.sqlvirtualmachine/sqlvirtualmachines"
| project name, id, resourceGroup
| join kind=leftouter (
recoveryservicesresources
| where type =~ "Microsoft.RecoveryServices/vaults/backupFabrics/protectionContainers/protectedItems"
| where properties.dataSourceInfo.datasourceType =~ "SQLDataBase"
| project isBackedupByRSV=properties.sourceResourceId
| extend name=strcat_array(array_slice(split(isBackedupByRSV, "/"), 8, -1), "/")
) on name
| extend isBackedupByRSV = iff(isBackedupByRSV startswith "/subscriptions","True","False")
| distinct *
| join kind=leftouter (
resources
| where type == "microsoft.compute/virtualmachines/extensions"
| where name == "SqlIaasExtension"
| project isAutoBackedUp=properties.settings.AutoBackupSettings.Enable ,id
| extend name=strcat_array(array_slice(split(id, "/"), 8, -3), "/")
) on name
| extend isAutoBackedUp = iff(isAutoBackedUp =~ "true", "True", "False")
| join kind=leftouter (
resources
| where type == "microsoft.compute/virtualmachines"
| project name, PowerStatus = properties.extended.instanceView.powerState.displayStatus
) on name
| project id, resourceGroup, isBackedupByRSV, isAutoBackedUp, PowerStatus

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.