Queries for the PerfInsightsImpactedResources table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

PerfInsights Impacted Resources Details

Unpacks and displays details of PerfInsights impacted resources.

PerfInsightsImpactedResources
| where isnotnull(Details)
| extend FirstConfig = Details[0]
| extend ResourceKVP = pack(
    tostring(ImpactedResourceName),
    tostring(ImpactedResourceValue)
)
| extend MergedConfig = bag_merge(ResourceKVP, FirstConfig)
| project MergedConfig
| evaluate bag_unpack(MergedConfig)