take_any.md

take_any

take_any will return a random row from the dataset

Return only one random row

IntuneDevices
| summarize take_any(*)

Return only one random row with specific columns

IntuneDevices
| summarize take_any(DeviceName, TimeGenerated, DeviceId)

Use with by, returns a random row for each distinct value from that column

IntuneDevices
| summarize take_any(DeviceId, OS, CompliantState) by DeviceName