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’

Leave a Reply

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