SCCM Report to show Operating system version/architecture separated by AD boundary RRS feed

  • Question

  • Hi,

    I was trying to create a SCCM report that shows my Operating system version (IE-Windows 7 Enterprise, x64, etc.) separated/grouped by boundary.  I have this query that Sherry Kissenger posted in her blog that is pretty helpful, but would like to add the Boundary/OS version to this query:

    NOTE:  This query shows OS architecture on hardware architecture:

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

    Any help is truly appreciated.

    Don D.

    • Edited by DonD1976 Wednesday, September 12, 2012 6:13 PM
    Wednesday, September 12, 2012 6:12 PM


All replies