Add 32/64 bit Column to Query?

[bostonrake]

Hello all,

I have a query to show me what computers do not have a certain software installed. It returns the computer name and the last logged in user. I would like to add if the machine is 32 or 64 bit. The reason why is because I want to sort by 32/64 bit so I can easily select all the 32 bit machines for example and throw them into the proper collection to get the software.

 

Here is the query I have...

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Traps") and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Traps") order by SMS_R_System.NetbiosName

 

Again, I just want to add a column that shows if the computer is 32 or 64 bit.

 

Thanks,

Doug