SMS - SCCM query to ckeck if OS is x86 or x64

Let's start with something very easy: a simple query to check if an OS is x86 or x64 version.
This query works with both SMS 2003 and SCCM 07 - 2012





select SMS_R_System.NetbiosName, 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