SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

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: , , ,

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

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems