Virtual PCs vs Physical PCs

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)

Select

            @Real as ‘Real PCs’,

            @Virtual as ‘Virtual PCs’,

            @Total as ‘Total’