August 18 2011

SCCM report – count Windows Server versions on physical hardware only

I had a requirement to count the different versions of Windows Server but only on physical hardware. This SCCM report does this by excluding VMWare and Hyper-V machines:

SELECT OPSYS.Caption0 as C054, COUNT(*) AS 'Count'
FROM v_GS_OPERATING_SYSTEM OPSYS
full Join v_GS_COMPUTER_SYSTEM On v_GS_COMPUTER_SYSTEM.ResourceID = OPSYS.ResourceID
inner join v_R_System sys on OPSYS.ResourceID=sys.ResourceID
where OPSYS.Caption0 LIKE '%server%'
and (v_GS_COMPUTER_SYSTEM.Manufacturer0 NOT LIKE '%Microsoft Corporation%')
and (v_GS_COMPUTER_SYSTEM.Manufacturer0 NOT LIKE '%VMware, Inc.%')
GROUP BY OPSYS.Caption0
ORDER BY OPSYS.Caption0

 
 



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------


Tags: , , , ,

Posted August 18, 2011 by danovich in category "SMS / SCCM", "Windows

Leave a Reply