SMSUG.ca

...your virtual communITy

Welcome to SMSUG.ca Sign in | Join | Help

Garth Jones

Count of OS and Bite size (32 bit or 64 Bit)

select
    OS.Caption0,
    CS.SystemType0,
    Count(*)
from
    dbo.v_GS_COMPUTER_SYSTEM CS Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceId
Group by
    OS.Caption0,
    CS.SystemType0
Order by
    OS.Caption0,
    CS.SystemType0

Published Jan 28 2009, 05:23 PM by Garth

Filed under: SQL, SMS, Code, ConfigMGr

Comments

	SCCM Report to identify machines with 64-bit capable hardware said: Pingback from SCCM Report to identify machines with 64-bit capable hardware November 19, 2010 11:14 PM
	SCCM Report to identify machines with 64-bit capable hardware - Admins Goodies said: Pingback from SCCM Report to identify machines with 64-bit capable hardware - Admins Goodies August 18, 2011 11:27 AM
	SCCM Report to identify machines with 64-bit capable hardware \| eeYogo @ yo' service said: Pingback from SCCM Report to identify machines with 64-bit capable hardware \| eeYogo @ yo' service June 19, 2012 7:50 AM