Merge 2 queries - for output x86 bit or x64 bit machine

Hi Guys,

I need to write 2 different query to find whether a machine is x86 based machine or x64 bit based machine.

How can i put the below query as single query for out x86 or x64.

Output values:    System Resource. Name      Computer System. System Type

select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.SystemType from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "x86-based PC"

select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.SystemType from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC"

February 26th, 2015 11:27am

Untested:

select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.SystemType from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType in ( "x86-based PC", "x64-based PC")

Free Windows Admin Tool Kit Click here and download it now
February 26th, 2015 11:33am
Thank you, it worked.
February 26th, 2015 11:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics