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

1 comments:

Anonymous said...

This report gives hardware address width, not the OS.

For OS address-width, use [v_GS_COMPUTER_SYSTEM].[SystemType0]

Post a Comment