Collection Query: Computers by Model HP 3400 Pro MT 8GB

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 inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "HP Pro 3400 Series MT" and SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory in (8024304,8024368,8027504,8040752,8078252,8090728,8171976,8171980,8189536,8189908,8190016,8201632,8205512,8205516,8206112,8206124,8206616,8208868,8208876,8215920,8233552,8248200,8248208,8257960,8259612,8267656,8268140,8271052,8271336,8272736,8273448,8279796,8281904,8283444,8290672,8291140,8298032,8302412,8302448,8303036,8317616,8321120,8322232,8325808,8331744,8342992,8344472,8346028,8363760,8367744,8367748,8367748,8368448,8368460,8368964,8368980,8369392,8369456,8378068,8379448,8379852) and SMS_G_System_PROCESSOR.Name in ("Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz","Intel(R) Core(TM) i5-2500S CPU @ 2.70GHz")