The Amazing KQL

The Amazing KQL
💠KQL Quick Guide
💻Microsoft Endpoint Manager
- Device Inventory
  - Device OS version
  - Same AAD Device ID and Intune Device ID

Powered by GitBook

On this page

Was this helpful?

💠KQL Quick Guide

Need to practice more 🎯

pack

Previousset_differenc Nextsummarize

Last updated 2 years ago

IntuneDevices
| where TimeGenerated > ago (30d)
        and isnotempty(OS)
| distinct  OS, JoinType
| extend p = pack(OS, JoinType)