Determine machines less than a Pentium IV

Query to determine machines less than a Pentium 4

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%’

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s