Queries for the UCDOAggregatedStatus table

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

Content distribution in Gigabytes

Get the content distribution in Gigabytes for all the devices.

UCDOAggregatedStatus
|extend
LanGB =  todouble(BytesFromPeers)/pow(1024,3),
GroupGB = todouble(BytesFromGroupPeers)/pow(1024,3),
NonPeerGB = todouble(BytesFromCDN)/pow(1024,3)
|project
Content = ContentType,
LanGB,
GroupGB,
NonPeerGB,
DeviceCount