This report displays the number of servers in the environment and gives a breakdown and percentage view of physical vs virtual: Declare @Total as int Declare @Physical as int Declare @Virtual as int set @Virtual = (Select distinct count (*) From v_R_System full Join v_GS_COMPUTER_SYSTEM On v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID where v_R_System.Operating_System_Name_and0 LIKE ‘%server%’ and v_R_System.Client0 [...]
