Metrics
| where EventType == "_MobileDeviceOperation" and MetricName == "ExitCode"
| join kind=inner Jobs on JobId
| where Finished > now()-1d
| extend Dimensions = parse_json(Dimensions)
| project 
    Finished,
    JobName,
    QueueName,
    WorkItemFriendlyName,
    Platform = tostring(Dimensions.platform),
    Command = tostring(Dimensions.command),
    ExitCode = MetricValue,
    Target = tostring(Dimensions.target),
    IsDevice = tobool(Dimensions.isDevice)
| where Platform == "apple"
| summarize SuccessRate=countif(ExitCode < 6)*100/count(), Count=count() by Platform, Command, QueueName
| where SuccessRate != 100
| order by Platform, SuccessRate, Command