1Aug/070
VMware / MS VM / Real / Total Count
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'
Enjoy this article?
About Tom Lasswell
about myself.Tags
blog
cacti
camera
cluster
ConfigMgr
Datacenter
datadomain
dfs
finances
fun
gx
home
iphone
isy
netapp
network
opsmgr
phone
photos
reporting
san
SCOM
script
sms2003
sql
srm
toy
uptimedevices
vmware
work
xbmc
Twitter Feed
- @kix1979 link? What's the free connector?
- @vStorage finally! been looking forward to this feature. glad it's finally there. nice writeup btw.
- @3parfarley been using that for about a year now. :) when i first used it finally got a correct pizza order. hah
Personal
Vendor
Recent Posts
- ISY Python Script for controlling media lights via xbmc
- Schedule a URL into Maintenance Mode
- First iphone 4 post
- Designing Disaster Recovery … on a budget
- OpsMgr 2007 – No graphs in emailed reports