Along the same vane as yesterday’s blog.
This query will help you find the Virtual PCs vs Physical PCs.
Declare @Virtual as int
Declare @Real as int
Declare @Total as int
set @Total = (select count(*) from v_GS_COMPUTER_SYSTEM)
set @Virtual = (select count(*) from v_GS_COMPUTER_SYSTEM where Manufacturer0 = ‘Microsoft Corporation’ or Manufacturer0 = ‘VMware, Inc.’)
set @Real = (select @total – @Virtual)
@Real as ‘Real PCs’,
@Virtual as ‘Virtual PCs’,
@Total as ‘Total’