Queries for the UCDOAggregatedStatus table

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