适用于 Azure 顾问的 Azure Resource Graph 示例查询

此页面是针对 Azure 顾问的 Azure Resource Graph 示例查询的集合。

示例查询

建议带来的潜在成本节省

此查询计算Azure 顾问建议的每月成本节省。

advisorresources
| where type =~ "microsoft.advisor/metadata"
| where tostring(properties.language)=="en"
| where tostring(properties.recommendationCategory)=="Cost"
| extend recommendationTypeId=tostring(properties.recommendationTypeId)
| project recommendationTypeId,
    metadataSolution=tostring(properties.label)
| join kind=inner (
    advisorresources
    | where type =~ "microsoft.advisor/recommendations"
    | extend recommendationTypeId=tostring(properties.recommendationTypeId)
    | extend
        resources=tostring(properties.resourceMetadata.resourceId),
        savings=todouble(properties.extendedProperties.savingsAmount),
        tracked=tobool(properties.tracked),
        recommendationSolution=tostring(properties.label),
        currency=tostring(properties.extendedProperties.savingsCurrency)
    | project recommendationTypeId,resources,savings,tracked,recommendationSolution,currency
) on recommendationTypeId
| extend solution = iff(tracked == true, recommendationSolution, metadataSolution)
| summarize
    dcount_resources=dcount(resources),
    sum_savings=bin(sum(savings),0.01)
    by solution,currency
| where sum_savings > 0
| project solution,dcount_resources,sum_savings,currency
| order by sum_savings desc

Azure CLI

az graph query -q "advisorresources | where type =~ "microsoft.advisor/metadata" | where tostring(properties.language)=="en" | where tostring(properties.recommendationCategory)=="Cost" | extend recommendationTypeId=tostring(properties.recommendationTypeId) | project recommendationTypeId,     metadataSolution=tostring(properties.label) | join kind=inner (     advisorresources | where type =~ "microsoft.advisor/recommendations" | extend recommendationTypeId=tostring(properties.recommendationTypeId) | extend         resources=tostring(properties.resourceMetadata.resourceId),         savings=todouble(properties.extendedProperties.savingsAmount),         tracked=tobool(properties.tracked),        recommendationSolution=tostring(properties.label),         currency=tostring(properties.extendedProperties.savingsCurrency) | project recommendationTypeId,resources,savings,tracked,recommendationSolution,currency ) on recommendationTypeId | extend solution = iff(tracked == true, recommendationSolution, metadataSolution) | summarize     dcount_resources=dcount(resources),     sum_savings=bin(sum(savings),0.01)     by solution,currency | where sum_savings > 0 | project solution,dcount_resources,sum_savings,currency | order by sum_savings desc"

Azure PowerShell

Search-AzGraph -Query "advisorresources | where type =~ "microsoft.advisor/metadata" | where tostring(properties.language)=="en" | where tostring(properties.recommendationCategory)=="Cost" | extend recommendationTypeId=tostring(properties.recommendationTypeId) | project recommendationTypeId,     metadataSolution=tostring(properties.label) | join kind=inner (     advisorresources | where type =~ "microsoft.advisor/recommendations" | extend recommendationTypeId=tostring(properties.recommendationTypeId) | extend         resources=tostring(properties.resourceMetadata.resourceId),         savings=todouble(properties.extendedProperties.savingsAmount),         tracked=tobool(properties.tracked),        recommendationSolution=tostring(properties.label),         currency=tostring(properties.extendedProperties.savingsCurrency) | project recommendationTypeId,resources,savings,tracked,recommendationSolution,currency ) on recommendationTypeId | extend solution = iff(tracked == true, recommendationSolution, metadataSolution) | summarize     dcount_resources=dcount(resources),     sum_savings=bin(sum(savings),0.01)     by solution,currency | where sum_savings > 0 | project solution,dcount_resources,sum_savings,currency | order by sum_savings desc"

门户

• Azure 门户：portal.azure.com
• Azure 政府门户：portal.azure.us
• 由世纪互联运营的 Microsoft Azure 门户：portal.azure.cn

后续步骤

• 详细了解查询语言。
• 详细了解如何浏览资源。