With ARM Devices coming, and you can manage them with CM, it would be nice to have collections for them, so with this simple Query, you can do that. Also means you might want to make an x64 collection as well, if you don’t already have one from the days you were keeping track of your x86 vs your x64 devices.
x64 Devices
select * 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.SystemType = "x64-based PC"
ARM64 Devices (note, you’ll never have ARM 32bit devices)
select * 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.SystemType = "ARM64-based PC"
SQL Data
The Data is in v_GS_COMPUTER_SYSTEM
SELECT [ResourceID]
,[Description0]
,[Domain0]
,[Model0]
,[Name0]
,[SystemType0]
,[TotalPhysicalMemory0]
FROM [CM_MCM].[dbo].[v_GS_COMPUTER_SYSTEM]
GARYTOWN.COM