Tabular API Sample Queries
Please make sure to check the complete API documentation before using the sample clients and queries.
Sample clients:
Quick navigation to sample queries by dataset:
OEM Reliability
Get the list of all incidents.
{
"measures": [
"[Measures].[Total Machines]",
"[Measures].[Crashes]",
"[Measures].[Impacted Machines]",
"[Measures].[Percent Impacted]",
"[Measures].[Crashing Model Families]"
],
"dimensions": [
"[Incident].[Vertical]",
"[Incident].[Incident Id]",
"[Incident].[Device Class]",
"[Incident].[Driver Owner]",
"[Driver].[Driver Name]",
"[Report Date].[Report Date Text]"
],
"filters": [],
"rangeFilters": [],
"ordering": null
}
Incident details for single incident
{
"measures": [
"[Measures].[Hardware Total Machines]",
"[Measures].[Hardware Crashes]",
"[Measures].[Hardware Impacted Machines]",
"[Measures].[Hardware Percent Impacted]"
],
"dimensions": [
"[Incident].[Vertical]",
"[Incident].[Incident Id]",
"[Incident].[Device Class]",
"[Incident].[DriverName]",
"[Incident].[Driver Owner]",
"[Incident].[Title]",
"[Incident].[Age]",
"[Incident].[Failure Hash]",
"[Incident].[FailureBucketId]",
"[Incident].[Fix Version]",
"[Incident].[Fixed Age]",
"[Report Date].[Report Date Text]"
],
"filters": [
{
"name": "[Incident].[Incident Id]",
"values": [
"12401437"
],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}Crashes and impacted machines by model for single incident
{
"measures": [
"[Measures].[Total Machines]",
"[Measures].[Crashes]",
"[Measures].[Impacted Machines]",
"[Measures].[Percent Impacted]"
],
"dimensions": [
"[Incident].[Incident Id]",
"[DeviceModelHierarchy].[Model Family]",
"[DeviceModelHierarchy].[Model Name]",
"[DeviceModelHierarchy].[Baseboard]"
],
"filters": [
{
"name": "[Incident].[Incident Id]",
"values": [
"12401437"
],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}Crashes and impacted by driver version for single incident
{
"measures": [
"[Measures].[Hardware Total Machines]",
"[Measures].[Hardware Crashes]",
"[Measures].[Hardware Impacted Machines]",
"[Measures].[Hardware Percent Impacted]"
],
"dimensions": [
"[Incident].[Incident Id]",
"[Incident].[Driver Name]",
"[Driver].[Driver Version]"
],
"filters": [
{
"name": "[Incident].[Incident Id]",
"values": [
"12401437"
],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}OEM hardware component reliability
Print driver and device details
{
"measures": [
"[Measures].[Crashes]"
],
"dimensions": [
"[Incident].[Vertical]",
"[Incident].[Device Class]",
"[Driver].[Driver Name]",
"[Driver].[Driver Version]",
"[OsVersion].[Release Version]",
"[DeviceModelHierarchy].[OEM]",
"[DeviceModelHierarchy].[Model Name]",
"[DeviceModelHierarchy].[Baseboard]"
],
"filters": [
{
"name": "[Incident].[Device Class]",
"values": [ "Print" ],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}IHV Reliability
Get list of all incidents
{
"measures": [
"[Measures].[Total Machines]",
"[Measures].[Crashes]",
"[Measures].[Impacted Machines]",
"[Measures].[Percent Impacted]"
],
"dimensions": [
"[Incident].[Incident Id]",
"[Incident].[Driver Name]",
"[Incident].[Vertical]",
"[Incident].[Device Class]",
"[Incident].[Title]",
"[Incident].[PartnerUniversalID]",
"[Incident].[Failure Hash]",
"[Incident].[Fix Version]",
"[Incident].[State]",
"[Incident].[Vertical]",
"[Incident].[Age]",
"[Incident].[Fixed Age]"
],
"filters": [],
"rangeFilters": [],
"ordering": null
}Impacted machine by OEM for single incident.
{
"measures": [
"[Measures].[Impacted Machines]",
"[Measures].[Crashes]"
],
"dimensions": [
"[DeviceModelHierarchy].[OEM]"
],
"filters": [
{
"name": "[Incident].[Incident Id]",
"values": [ "12401437" ],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}Top crashing drivers for single incident.
{
"measures": [
"[Measures].[Impacted Machines]",
"[Measures].[Total Machines]",
"[Measures].[Percent Impacted]",
"[Measures].[Crashes]"
],
"dimensions": [
"[Driver].[Driver Name]",
"[Driver].[Driver Version]"
],
"filters": [
{
"name": "[Incident].[Incident Id]",
"values": [ "12401437" ],
"exclude": false,
"conditionalOperator": "Equal",
"logicalOperator": "None"
}
],
"rangeFilters": [],
"ordering": null
}Battery life and app energy
Replicate the battery life percentile table on the report.
{
"measures": [
"[Measures].[25th Percentile ESOBL (h)]",
"[Measures].[50th Percentile ESOBL (h)]",
"[Measures].[75th Percentile ESOBL (h)]",
"[Measures].[Average Power Draw (W)]",
"[Measures].[Full Charge Capacity (Wh)]",
"[Measures].[Battery Life Sample TMAD]",
"[Measures].[Battery Life Session Count]",
"[Measures].[Battery Life Last Refresh Date]"
],
"dimensions": [
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]"
],
"filters": [],
"rangeFilters": []
}Examine the Estimated Screen on Battery Life (ESOBL) for consumer devices by Internal Battery Capacity Design
{
"measures": [
"[Measures].[25th Percentile ESOBL (h)]",
"[Measures].[50th Percentile ESOBL (h)]",
"[Measures].[75th Percentile ESOBL (h)]",
"[Measures].[Average Power Draw (W)]",
"[Measures].[Full Charge Capacity (Wh)]",
"[Measures].[Battery Life Sample TMAD]",
"[Measures].[Battery Life Session Count]"
],
"dimensions": [
"[Device Model Hierarchy].[Model Family]",
"[Battery].[Internal Battery Capacity Design Range]",
"[Segment].[Customer Group]"
],
"filters": [
{
"name": "[Segment].[Customer Group]",
"values": [
"Consumer"
]
}
],
"rangeFilters": []
}Show the Total Energy w/ display and display energy for "Win32" applications.
{
"measures": [
"[Measures].[Total Energy w/ Display (mWh)]",
"[Measures].[Display Energy (mWh)]",
"[Measures].[Application Energy Usage Session Count]",
"[Measures].[Application Energy Usage Sample TMAD]"
],
"dimensions": [
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]",
"[Application].[Application Name]",
"[Application].[Application Type]"
],
"filters": [
{
"name": "[Application].[Application Type]",
"values": [ "Win32" ]
}
],
"rangeFilters": []
}List of device models where Software DRIPS >= 70 and DRIPS delta <= 30
{
"measures": [
"[Measures].[Average Software DRIPS]",
"[Measures].[Average Hardware DRIPS]",
"[Measures].[Average DRIPS Delta]"
],
"dimensions": [
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]"
],
"filters": [],
"rangeFilters": [
{
"name": "[Measures].[Average Software DRIPS]",
"startValue": "70",
"endValue": "100"
},
{
"name": "[Measures].[Average DRIPS Delta]",
"startValue": "0",
"endValue": "30"
}
]
}Replicate the Top Offenders by total offending time table.
{
"measures": [
"[Measures].[Total Offender Time (h)]",
"[Measures].[Modern Standby Drips Offenders Session Count]",
"[Measures].[Modern Standby Drips Offenders Sample TMAD]"
],
"dimensions": [
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]",
"[Offender].[Offender Name]",
"[Offender].[Offender Type]"
],
"filters": [],
"rangeFilters": []
}IHV modern standby
List of device models where software DRIPS >= 70 and DRIPS delta <= 30
{
"measures": [
"[Measures].[Average Software DRIPS]",
"[Measures].[Average Hardware DRIPS]",
"[Measures].[Average DRIPS Delta]",
"[Measures].[Modern Standby DRIPS Session Count]",
"[Measures].[Modern Standby Drips Sample TMAD]",
"[Measures].[Modern Standby Drips Last Refresh Date]"
],
"dimensions": [
"[CPU].[CPU Manufacturer]",
"[CPU].[CPU Code Name]",
"[CPU].[CPU Family Name]",
"[CPU].[CPU Name]",
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]"
],
"filters": [],
"rangeFilters": [
{
"name": "[Measures].[Average Software DRIPS]",
"startValue": "70",
"endValue": "100"
},
{
"name": "[Measures].[Average DRIPS Delta]",
"startValue": "0",
"endValue": "30"
}
]
}Replicate the Top Offenders by total offending time table.
{
"measures": [
"[Measures].[Total Offender Time (h)]",
"[Measures].[Modern Standby Drips Offenders Session Count]",
"[Measures].[Modern Standby Drips Offenders Sample TMAD]"
],
"dimensions": [
"[CPU].[CPU Manufacturer]",
"[CPU].[CPU Code Name]",
"[CPU].[CPU Family Name]",
"[CPU].[CPU Name]",
"[Device Model Hierarchy].[Model Family]",
"[Device Model Hierarchy].[Model Name]",
"[Offender].[Offender Name]",
"[Offender].[Offender Type]"
],
"filters": [],
"rangeFilters": []
}