{"id":30565,"date":"2025-03-20T08:07:00","date_gmt":"2025-03-20T08:07:00","guid":{"rendered":"https:\/\/endusersupports.com\/?p=30565"},"modified":"2025-04-15T19:32:01","modified_gmt":"2025-04-15T19:32:01","slug":"device-query-explanation","status":"publish","type":"post","link":"https:\/\/endusersupports.com\/index.php\/2025\/03\/20\/device-query-explanation\/","title":{"rendered":"Device Query Explanation"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"30565\" class=\"elementor elementor-30565\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a59a71b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a59a71b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1ac51e5\" data-id=\"1ac51e5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64c293d elementor-widget elementor-widget-text-editor\" data-id=\"64c293d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong><span style=\"color: #ffffff;\">Intune Device Query explanation- Multiple Devices<\/span><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ba9042c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ba9042c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a394018\" data-id=\"a394018\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d76f5b9 elementor-widget elementor-widget-text-editor\" data-id=\"d76f5b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00a0 The device query of multiple devices will provide you comprehensive information about your all devices by using the KQL query .<\/p><p><strong>Prerequisites-<\/strong><\/p><p>Microsoft Intune Advanced Analytics should be activated on Tenant You should have below license to use Device Query feature.<\/p><ul><li>Intune Advanced Analytics Add-on.<\/li><li>Microsoft Intune Suite.<\/li><li><p>Devices must be Intune managed and corporate owned.<\/p><\/li><li><p>Device query for multiple devices only works on devices that are already collecting device inventory data from an assigned\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/intune\/intune-service\/configuration\/properties-catalog\" data-linktype=\"relative-path\">Properties catalog<\/a>\u00a0profile.<\/p><\/li><\/ul><blockquote><p>To use Device query on a device, the device must be enrolled in Endpoint Analytics.\u00a0<\/p><\/blockquote><p><strong>How to start with Device Query for multiple devices.<\/strong><\/p><p>Login to Intune console and click on Devices and then click on Device Query.<\/p><p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-30617\" src=\"http:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices.png\" alt=\"\" width=\"1334\" height=\"637\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices.png 1334w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-300x143.png 300w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1024x489.png 1024w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-768x367.png 768w\" sizes=\"(max-width: 1334px) 100vw, 1334px\" \/><\/p><p>You can use Copilot in Intune to generate KQL query for device query using natural language requests.<\/p><p><img decoding=\"async\" class=\"aligncenter size-full wp-image-30618\" src=\"http:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1.png\" alt=\"\" width=\"1920\" height=\"957\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1.png 1920w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1-300x150.png 300w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1-1024x510.png 1024w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1-768x383.png 768w, https:\/\/endusersupports.com\/wp-content\/uploads\/2025\/04\/Device-Query-for-Multiple-devices-1-1536x766.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p><p>Multiple Device Query example<\/p><ol><li>\u00a0Deice with unprotected disk\u00a0<\/li><\/ol><blockquote><p><span style=\"color: #0000ff;\">EncryptableVolume| where ProtectionStatus != &#8220;PROTECTED&#8221;| join LogicalDrive<\/span><\/p><\/blockquote><p>\u00a0 \u00a0 \u00a02. List of all devices with ARM64 Processor.<\/p><blockquote><p><span style=\"color: #0000ff;\">Cpu | <span class=\"hljs-title\">where<\/span> Architecture == <span class=\"hljs-string\">&#8220;ARM64&#8221;<\/span><\/span><\/p><\/blockquote><p>\u00a0 3. Device Memory information<\/p><blockquote><p><span style=\"color: #0000ff;\">MemoryInfo| <span class=\"hljs-title\">project<\/span> Device, PhysicalMemoryGB = PhysicalMemoryTotalBytes\/(<span class=\"hljs-number\">1000<\/span>*<span class=\"hljs-number\">1000<\/span>*<span class=\"hljs-number\">1000<\/span>), VirtuaMemoryGB = VirtualMemoryTotalBytes\/(<span class=\"hljs-number\">1000<\/span>*<span class=\"hljs-number\">1000<\/span>*<span class=\"hljs-number\">1000<\/span>) | <span class=\"hljs-title\">order<\/span> <span class=\"hljs-keyword\">by<\/span> PhysicalMemoryGB <span class=\"hljs-keyword\">asc<\/span><\/span><\/p><\/blockquote><p>\u00a0 \u00a0 4.\u00a0 Device Count by Operating Version<\/p><blockquote><p><span style=\"color: #0000ff;\">OsVersion| <span class=\"hljs-title\">summarize<\/span> DevicesCount = <span class=\"hljs-keyword\">count<\/span>() <span class=\"hljs-keyword\">by<\/span> OsVersion<\/span><\/p><\/blockquote><p>Device Identity to write the KQL Query.<\/p><table width=\"726\" aria-label=\"Device entity\"><tbody><tr><td width=\"258\">Property<\/td><td width=\"69\">Type<\/td><td width=\"399\">Description<\/td><\/tr><tr><td width=\"258\">DeviceId<\/td><td width=\"69\">String<\/td><td width=\"399\">A unique ID generated by Intune as part of MDM enrollment.<\/td><\/tr><tr><td width=\"258\">EntraDeviceId<\/td><td width=\"69\">String<\/td><td width=\"399\">Unique ID generated by Microsoft Entra as part of Microsoft Entra registration or join.<\/td><\/tr><tr><td width=\"258\">ManagementName<\/td><td width=\"69\">String<\/td><td width=\"399\">An easily recognizable device name used only in the Intune admin center. Changing this name doesn&#8217;t change the device name or the name in the Company Portal.<\/td><\/tr><tr><td width=\"258\">DeviceName<\/td><td width=\"69\">String<\/td><td width=\"399\">Name of the device<\/td><\/tr><tr><td width=\"258\">SerialNumber<\/td><td width=\"69\">String<\/td><td width=\"399\">Serial number of the device<\/td><\/tr><tr><td width=\"258\">Manufacturer<\/td><td width=\"69\">String<\/td><td width=\"399\">Manufacturer of the device<\/td><\/tr><tr><td width=\"258\">Model<\/td><td width=\"69\">String<\/td><td width=\"399\">Model of the device<\/td><\/tr><tr><td width=\"258\">OSDescription<\/td><td width=\"69\">String<\/td><td width=\"399\">Full description of the operating system edition<\/td><\/tr><tr><td width=\"258\">OSVersion<\/td><td width=\"69\">String<\/td><td width=\"399\">The version of the operating system on the device<\/td><\/tr><tr><td width=\"258\">EnrollmentProfileName<\/td><td width=\"69\">String<\/td><td width=\"399\">Name of the enrollment profile assigned to the device. Default value is an empty string indicating no enrollment profile was assigned to the device.<\/td><\/tr><tr><td width=\"258\">EnrolledDateTime<\/td><td width=\"69\">Datetime<\/td><td width=\"399\">The date and time that the device was enrolled in Intune.<\/td><\/tr><tr><td width=\"258\">CertExpirationDateTime<\/td><td width=\"69\">Datetime<\/td><td width=\"399\">Reports device management certificate expiration date.<\/td><\/tr><tr><td width=\"258\">EnrolledByUserId<\/td><td width=\"69\">String<\/td><td width=\"399\">Unique identifier for the user that enrolled the device<\/td><\/tr><tr><td width=\"258\">PrimaryUserId<\/td><td width=\"69\">String<\/td><td width=\"399\">Unique identifier for the user associated with the device.<\/td><\/tr><tr><td width=\"258\">LastLoggedOnUserId<\/td><td width=\"69\">String<\/td><td width=\"399\">Unique identifier for the user who last logged on to the device.<\/td><\/tr><tr><td width=\"258\">InCompliancePeriodUntilDateTime<\/td><td width=\"69\">Datetime<\/td><td width=\"399\">The DateTime when device compliance grace period expires<\/td><\/tr><tr><td width=\"258\">DeviceCategoryId<\/td><td width=\"69\">String<\/td><td width=\"399\">Device category display name. Default is an empty string.<\/td><\/tr><tr><td width=\"258\">LastSeenDateTime<\/td><td width=\"69\">String<\/td><td width=\"399\">The date and time that the device last connected to Intune.<\/td><\/tr><tr><td width=\"258\">Ownership<\/td><td width=\"69\">String<\/td><td width=\"399\">Ownership of the device.<\/td><\/tr><\/tbody><\/table><p><strong>Supported Properties<\/strong><\/p><ul><li>Battery<\/li><li>Bios Info<\/li><li>Cpu<\/li><li>Disk Drive<\/li><li>Encryptable Volume<\/li><li>Logical Drive<\/li><li>Memory Info<\/li><li>Network Adapter<\/li><li>Os Version<\/li><li>System Enclosure<\/li><li>Time<\/li><li>Tpm<\/li><li>Video Controller<\/li><li>Windows Qfe<\/li><\/ul><p>Follow the below Microsoft link to get more details.<\/p><p><a href=\"https:\/\/learn.microsoft.com\/en-us\/intune\/analytics\/device-query-multiple-devices\">https:\/\/learn.microsoft.com\/en-us\/intune\/analytics\/device-query-multiple-devices<\/a><\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Intune Device Query explanation- Multiple Devices \u00a0 The device query of multiple devices will provide you comprehensive information about your all devices by using the KQL query . Prerequisites- Microsoft Intune Advanced Analytics should be activated on Tenant You should have below license to use Device Query feature. Intune Advanced Analytics Add-on. Microsoft Intune Suite. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":30633,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-30565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mem"],"views":311,"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/posts\/30565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/comments?post=30565"}],"version-history":[{"count":19,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/posts\/30565\/revisions"}],"predecessor-version":[{"id":30636,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/posts\/30565\/revisions\/30636"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/media\/30633"}],"wp:attachment":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/media?parent=30565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/categories?post=30565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/tags?post=30565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}