Find all single CPU PCs with a processor speed of less than 1800 by Collection.

SELECT  Distinct
CS.Name0,
CPU.CurrentClockSpeed0,
CPU.MaxClockSpeed0
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_PROCESSOR CPU,
v_FullCollectionMembership FCM
WHERE
CS.ResourceID = CPU.ResourceID
AND CS.ResourceID = FCM.ResourceID
AND CPU.REsourceID not IN (select ResourceID from v_GS_PROCESSOR CPU group by ResourceID having count(CPU.ResourceID) > 1)
AND CPU.MaxClockSpeed0 < ‘1800’
AND FCM.CollectionID = ‘SMS00001’

Leave a Reply

Your email address will not be published. Required fields are marked *