All 64 bit Systems

[anyweb]

Using the same steps as done in the Create New Collection as outlined here we will:-

 

 

Create a New Collection and call it All 64 bit Systems,

for Membership rules Click on the Yellow cylinder (to create a New Query),

Create a New Query, call it All 64 bit systems query, click on Edit Query Statement then Criteria, Show Query Language,

 

replace the text that reads:-

 

Select * from SMS_R_System

 

by pasting the following in for the query

 

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_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PROCESSOR.AddressWidth = 64

 

done !

[Sumixam]

I'm sorry, I'm getting an error after entering that query statement.

 

"The query statement that you entered is not valid. Please enter a valid query statement."

[anyweb]

are you sure you pasted all of it in the right place ?

[Sumixam]

That must have been it. In my frustration I must have kept cut-paste the same code (with what ever I missed) over and over.

 

I tried it all over again from scratch and it works fine.

 

Thanks