Preserve device identity when joining Intune fleet inventory

Source facts

Intune fleet queries cover managed, corporate-owned devices; Windows inventory requires a properties catalog policy. Device is an entity, so scalar operations need a property such as its serial number. Microsoft no longer supports joins on Device.DeviceID; device joins use Device instead. Projection and aggregation can change the returned columns. Microsoft Learn.

Applicability

Use this review for device-query inventory analysis. Confirm platform prerequisites and the intended population before treating the result as a fleet-wide answer.

DSE recommendation

Write down whether the question asks for devices, components, or grouped measurements. Retain an explicit device identifier wherever the result must be traced back to an endpoint. Review each join and projection against the supported syntax rather than transplanting a general KQL query unchanged. Keep any proposed group-targeting action separate from the initial read-only query.

Verification

Choose a few known devices with different inventory characteristics and compare their source records with the query output. Check which identifiers survive the final projection and whether the reported count answers the original question. Investigate missing or unexpected rows before exporting a targeting list. Retain the query text and collection scope alongside the results so another operator can reproduce the interpretation.

Official references

Microsoft Learn: Device Query for Multiple Devices.