SCCM 移动设备集合查询

在这篇短文中，我将列出 SCCM 移动设备集合查询。如果您遇到一些有关移动设备的新查询，请在评论部分中提及。

我还发表了另一篇关于为 Windows 10 计算机创建设备集合的文章。您可以在此处阅读有关该帖子的更多信息。

SCCM 中的查询 - 在 SCCM 中，您可以创建并运行查询来查找与查询条件匹配的对象。查询可以返回大多数类型的配置管理器对象，其中包括站点、集合、应用程序和清单数据。

安装配置管理器时，它附带一组内置查询。打开 Configuration Manager 控制台并转到监控 > 概述 > 查询。

下面列出了内置查询。

All Systems with Specified Software Product Name and Version	
All Active Directory Security Groups	
All Client Systems
All Company Owned Devices
All jailbroken or rooted devices
All Mobile Devices
All Non-Client Systems
All Personal Devices
All Systems
All Systems with Hardware Inventory Collected
All Systems with Specified Software File Name and File Size
All Unknown Computers
All User Groups
All Users
ConfigMgr clients not upgraded to Configuration Manager 2012 R2 or later
Systems by Last Logged On User
This Site and its Subsites

当您创建查询时，它们将存储在 SCCM 站点数据库中。安装配置管理器时，您会收到一些内置查询。但是，如果您的要求是特定的，则必须创建一个新查询。

运行查询时，配置管理器会在站点数据库中搜索与查询条件匹配的对象。查询结果显示在 Configuration Manager 控制台的结果窗格中。

SCCM 移动设备集合查询

您可以在创建 SCCM 集合时使用以下查询。

Android 设备的集合查询

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_DEVICE_COMPUTERSYSTEM on SMS_G_System_DEVICE_COMPUTERSYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_DEVICE_COMPUTERSYSTEM.DeviceModel like "Android%"

iPhone 的设备集合查询

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_DEVICE_COMPUTERSYSTEM on SMS_G_System_DEVICE_COMPUTERSYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_DEVICE_COMPUTERSYSTEM.DeviceModel like "%iphone%"

iPad 的设备集合查询

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_DEVICE_COMPUTERSYSTEM on SMS_G_System_DEVICE_COMPUTERSYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_DEVICE_COMPUTERSYSTEM.DeviceModel like "%ipad%"

查询 Windows Phone 8 设备

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_DEVICE_OSINFORMATION on SMS_G_System_DEVICE_OSINFORMATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DEVICE_OSINFORMATION.Platform like "Windows Phone" and SMS_G_System_DEVICE_OSINFORMATION.Version like "8.0%"

Windows Phone 8.1 设备查询

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_DEVICE_OSINFORMATION on SMS_G_System_DEVICE_OSINFORMATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DEVICE_OSINFORMATION.Platform like "Windows Phone" and SMS_G_System_DEVICE_OSINFORMATION.Version like "8.1%"

Windows Phone RT 设备查询

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "Surface%"