tom@techcolumnist:~$

~/2007/08/01/vmware-ms-vm-real-total-count.md

VMware / MS VM / Real / Total Count

---
author: 
date: 
updated: 
read: 1 min
in:   [engineering]
tags: [reporting, sms2003]
---

Garth writes some very useful SMS web reports so I copy them here sometimes:
http://smsug.ca/blogs/garth_jones/archive/2007/08/01/528.aspx

Declare @MS as int Declare @VM as int Declare @Real as int Declare @Total as int set @Total = (select count(*) from v_GS_COMPUTER_SYSTEM) set @MS = (select count(*) from v_GS_COMPUTER_SYSTEM where Manufacturer0 = 'Microsoft Corporation' ) set @VM = (select count(*) from v_GS_COMPUTER_SYSTEM where Manufacturer0 = 'VMware, Inc.') set @Real = (select @total - @MS - @VM)

Select
@Real as ‘Real PCs’,
@MS as ‘MS Virtual PCs’,
@VM as ‘VM Virtual PCs’,
@Total as ‘Total’