Get OS type(x32 or x64) information from SCCM report

select sys.netbios_name0,
case when PROCESSOR.addresswidth0 = 64 then '64bit OS'
when PROCESSOR.addresswidth0=32 then '32bit OS'
end as [Operating System Type],
case when PROCESSOR.addresswidth0=32 and PROCESSOR.DataWidth0=64 then '*'
end as [32-bit OS on x64 processor]
from v_r_system sys
join v_gs_processor PROCESSOR on sys.resourceid=PROCESSOR.resourceid

All credits to Sherry Kissinger's. Read the original article at - http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx