For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Query the latest experimentscorecard metadata for a given feature.
// Latest scorecard metadata for a given feature
// set the feature flag name to query
let QueryFeature = "MyFeatureFlag";
OEWExperimentAssignmentSummary
| where FeatureName == QueryFeature
| summarize LastAssignmentTimestamp=max(LastAssignmentTimestamp), Variants=make_set(Variant, 1000) by AllocationId
| summarize arg_max(LastAssignmentTimestamp, *)
| join kind=inner OEWExperimentScorecards on AllocationId
| summarize arg_max(TimeGenerated, ScorecardId)
| project
FeatureName, AllocationId, Variants,
ScorecardId, AnalysisStartTime, AnalysisEndTime, Insights
Query the latest experiment scorecard result for a given feature.
// Latest scorecard results for a given feature
// set the feature flag name to query
let QueryFeature = "MyFeatureFlag";
OEWExperimentAssignmentSummary
| where FeatureName == QueryFeature
| summarize arg_max(LastAssignmentTimestamp, AllocationId)
| join kind=inner OEWExperimentScorecards on AllocationId
| summarize arg_max(TimeGenerated, ScorecardId)
| join kind=inner OEWExperimentScorecardMetricPairs on ScorecardId
| project
ScorecardId, MetricId, MetricDisplayName, MetricKind, MetricTags,
TreatmentVariant, TreatmentCount, TreatmentMetricValue,
ControlVariant, ControlCount, ControlMetricValue,
TreatmentEffect, RelativeDifference, PValue, Insights