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)




            @Real as ‘Real PCs’,

            @Virtual as ‘Virtual PCs’,

            @Total as ‘Total’

Leave a Reply

Your email address will not be published. Required fields are marked *