Determine machines less than a Pentium IV

Posted on by ChristineAli

Query to determine machines less than a Pentium 

SELECT distinct vrs.Name0, vps.Name0, vps.MaxClockSpeed0
  FROMv_R_System vrs
inner join[v_GS_PROCESSOR] vps on vrs.ResourceID = vps.ResourceID
  Where
vps.Name0 like '%Pentium%4%' or
vps.Name0 like '%Pentium%III%'or
vps.Name0 like '%Pentium%II%'  or
vps.Name0 like '%Pentium%M%'

Discover more from Christine Alifrangis

Subscribe to get the latest posts sent to your email.

Leave a Reply