Edit

Delivery Optimization data in Windows Update for Business reports

Delivery Optimization (DO) is a Windows feature that can be used to reduce bandwidth consumption by sharing the work of downloading updates among multiple devices in your environment. You can use DO with many other deployment methods, but it's a cloud-managed solution, and access to the DO cloud services is a requirement.

Windows Update for Business reports provides Delivery Optimization information in the following places:

Windows Update for Business reports doesn't include Delivery Optimization data for Windows Insider devices.

Delivery Optimization terms

Windows Update for Business reports uses the following Delivery Optimization terms:

  • Peer: A device in the solution

  • Peering 'ON' - Devices where DO peer-to-peer is enabled in one of the following modes:

    • LAN (1)
    • Group (2)
    • Internet (3)

  • Peering 'OFF': Devices where DO peer-to-peer is disabled, set to one of the following modes:

    • HTTP Only (0)
    • Simple Mode (99)
    • Bypass (100), deprecated in Windows 11

  • Bandwidth savings: The percentage of bandwidth that was downloaded from alternate sources (Peers or Microsoft Connected Cache (MCC) out of the total amount of data downloaded.

  • If bandwidth savings are <= 60%, a Warning icon is displayed

  • When bandwidth savings are <10%, an Error icon is displayed.

  • Configurations: Based on the DownloadMode configuration set via MDM, Group Policy, or end-user via the user interface.

  • P2P Device Count: The device count is the number of devices configured to use peering.

  • Microsoft Connected Cache (MCC): Microsoft Connected Cache is a software-only caching solution that delivers Microsoft content. For more information, see Microsoft Connected Cache overview.

  • MCC Device Count: The device count is the number of devices that have received bytes from the cache server, for supported content types.

  • Total # of Devices: The total number of devices with activity in last 28 days.

  • LAN Bytes: Bytes delivered from LAN peers.

  • Group Bytes: Bytes from Group peers. If a device is using Group DownloadMode, Delivery Optimization first looks for peers on the LAN and then in the Group. Therefore, if bytes are delivered from LAN peers, they are calculated in 'LAN Bytes'.

  • CDN Bytes: Bytes delivered from Content Delivery Network (CDN).

  • City: City is determined based on the location of the device where the maximum amount of data is downloaded.

  • Country: Country is determined based on the location of the device where the maximum amount of data is downloaded.

  • ISP: ISP is determined based on the ISP delivering the maximum bytes to the device.

Calculations for Delivery Optimization

Each calculated values used in the Delivery Optimization report are listed below.

Efficiency (%) Calculations:

  • Bandwidth Savings (BW SAV%) = 100 * (BytesFromPeers + BytesFromGroupPeers + BytesFromCache) / (BytesFromPeers + BytesFromGroupPeers+BytesFromCDN + BytesFromCache)
  • % P2P Efficiency = 100 * (BytesFromPeers + BytesFromGroupPeers) / (BytesFromPeers + BytesFromGroupPeers+BytesFromCDN+BytesFromCache)
  • % MCC Efficiency = 100 * BytesFromCache / (BytesFromPeers + BytesFromGroupPeers+BytesFromCDN+BytesFromCache)

Bytes Calculations:

Volume Calculations:

  • Volume by P2P = BytesFromPeers + BytesFromGroupPeers
  • Volume by MCC = BytesFromCache
  • Volume by CDN = BytesFrom CDN

Mapping GroupID

In the Efficiency By Group subsection, the GroupID is displayed as an encoded SHA256 hash and is case sensitive. You can create a mapping of original to encoded GroupIDs using the following PowerShell example:

$text = "<myOriginalGroupID>`0" ; # The `0 null terminator is required

$hashObj = [System.Security.Cryptography.HashAlgorithm]::Create('sha256') ; $dig = $hashObj.ComputeHash([System.Text.Encoding]::Unicode.GetBytes($text)) ; $digB64 = [System.Convert]::ToBase64String($dig) ; Write-Host "$text ==> $digB64"

In addition, you can see both the encoded and decoded GroupIDs in the Delivery Optimization logs.

Get-DeliveryOptimizationLog -Flush | Set-Content C:\dosvc.log

The below two lines are together in verbose logs:

2023-02-15T12:33:11.3811337Z 1514  1F4          {CGlobalConfigManager::GetGroupId} Using groupID = **<myOriginalGroupId>**
2023-02-15T12:33:11.3811432Z 1514  1F4          {CGlobalConfigManager::GetGroupId} Hashed groupID = **<myEncodedGroupId>**

Sample queries

You can use the data in UCDOAggregatedStatus and UCDOStatus to create your own queries. Create your custom queries using Kusto Query Language (KQL), but note that Windows Update for Business reports uses Azure Monitor, so some operators aren't supported. The KQL documentation specifies which operators aren't supported by Azure Monitor or if they have different functionality. For more information about KQL in Azure Monitor, see Log queries in Azure Monitor. The following queries are examples of how you can use the data:

Example UCDOAggregatedStatus table query

The following query is used to display the total bandwidth savings % value:

UCDOAggregatedStatus| where TimeGenerated == _SnapshotTime
| extend LocalSourceBytes = BytesFromCache + BytesFromGroupPeers + BytesFromPeers
| summarize LocalSources_BWSAV = round((sum(0.0 + LocalSourceBytes)/ sum(LocalSourceBytes+BytesFromCDN)) * 100.0 ,2)
| extend Title = "BW SAV%" , SubTitle = "Local Sources"

Example UCDOStatus table query

The following query is used to display the Top 10 GroupIDs:

UCDOStatus  | where TimeGenerated == _SnapshotTime
| summarize sum(BytesFromCDN) ,  sum(BytesFromGroupPeers) , sum(BytesFromPeers) , sum(BytesFromCache) ,
DeviceCount = count_distinct(GlobalDeviceId) by GroupID | top 10 by DeviceCount desc 
| extend TotalBytes = (sum_BytesFromPeers + sum_BytesFromGroupPeers+sum_BytesFromCDN+sum_BytesFromCache)
| extend P2PPercentage = ((0.0 + sum_BytesFromPeers + sum_BytesFromGroupPeers)/TotalBytes ) * 100.0  
| extend  MCCPercentage = ((0.0 + sum_BytesFromCache)/ TotalBytes) * 100.0  , 
 VolumeBytesFromPeers = sum_BytesFromPeers + sum_BytesFromGroupPeers
| extend VolumeBytesFromMCC = sum_BytesFromCache , VolumeByCDN = sum_BytesFromCDN
| project  GroupID , P2PPercentage , MCCPercentage ,  VolumeBytesFromPeers , VolumeBytesFromMCC ,VolumeByCDN , DeviceCount

Delivery Optimization Supported Content Types

There are many Microsoft content types that are supported by Delivery Optimization. All of these content types show up in the 'Content Distribution' section in the Delivery Optimization report. See the complete table for P2P/MCC support types.

Content Category Content Types Included
Apps Windows 10 Store apps, Windows 10 Store for Business apps, Windows 11 UWP Store apps
Driver Updates Windows Update Driver updates
Feature Updates Windows Update Feature updates
Office Microsoft 365 Apps and updates
Other Windows Language Packs, Windows Defender definition updates, Intune Win32 apps, Edge Browser updates, Configuration Manager Express updates, Dynamic updates, MDM Agent, Xbox Game Pass (PC), Windows Package Manager, MSIX Installer (includes Windows 11 Store Win32 apps, Windows 11 Teams updates)
Quality Updates Windows Updates Quality updates)

Frequency Asked Questions

  • What time period does the Delivery Optimization data include? Data is generated/aggregated for the last 28 days for active devices. For Delivery Optimization data to register in the report, the device must have performed some Delivery Optimization action in the 28-day rolling window. This includes device configuration information.

  • Data is showing as 'Unknown', what does that mean? You may see data in the report listed as 'Unknown'. This status indicates that the Delivery Optimization DownloadMode setting is either invalid or empty.

  • How are the 'Top 10' groups identified? The top groups are represented by the number of devices in a particular group, for any of the four group types (GroupID, City, Country, and ISP).

  • The GroupIDs don't look familiar, why are they different? The GroupID values are encoded for data protection telemetry requirements. You can find more information in the 'Mapping GroupIDs' section above.

  • How can I see data for device in the office vs. out of the office? Today, we don't have a distinction for data that was downloaded by location.

  • What does the data in UCDOStatus table represent? A row in UCDOStatus represents data downloaded by a combination of a single device ID (AzureADDeviceId) by content type (ContentType).

  • What does the data in UCDOAggregatedStatus table represent? A row in UCDOAggregatedStatus represents data summarized at the tenant level (AzureADTenantID) for each content type (ContentType).

  • How are BytesFromCache calculated when there's a Connected Cache server used by my ISP? If there's a Connected Cache server at the ISP level, BytesFromCache filters out any bytes coming the ISP's Connected Cache.

  • How do the results from the Delivery Optimization PowerShell cmdlets compare to the results in the report? Delivery Optimization PowerShell cmdlets can be a powerful tool used to monitor Delivery Optimization data on the device. These cmdlets use the cache on the device. The data calculated in the report is taken from the Delivery Optimization telemetry events.

  • The report represents the last 28 days of data, why do some queries include >= seven days? The data in the report does represent the last 28 days of data. The query for last seven days is just to get the data for the latest snapshot from past seven days. It's possible that data is delayed for sometime and not available for current day, so we look for past 7 day snapshot in log analytics and show the latest snapshot.