Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
434 questions
Azure Arc - availability group databases
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 18%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Luu, Mylan
0
Reputation points
Used kusto queries into Azure Resource Graph's resource types for Azure ARC but couldn't find AG and its databases sync info.
- microsoft.azurearcdata/sqlserverinstances/availabilitygroups, This returns a list of AGs; No AG primary/health state info
- microsoft.azurearcdata/sqlserverinstances/databases. This returns list of databases in general but no way to identify which one(s) is/are AG databases. Question: could some one help with kusto queries into Azure Resource Graph (Azure ARC) to get on-prem SQL Availability Group and its databases. In Azure Arc portal, these info is available and shown under Azure Arc > SQL Instances > Availability group
{count} votes
-
Oury Ba-MSFT 19,426 Reputation points Microsoft Employee2024-07-15T22:46:25.1233333+00:00 @Luu, Mylan Thank you for reaching out.
For Arc SQL Server DB inventorying, you can use the properties that are collected for AG's and DB's that are part of ARM, and you can use that to create a .kql query to run in ARG to access that information. This scenario is possible, and the list of properties are in docs for AG's and DB's that you can use for this
DB properties docs article: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/view-databases?view=sql-server-ver16
AG properties docs article: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/manage-availability-group?view=sql-server-ver16
Sign in to comment
Sign in to answer