Solution:
TSQL #1:
SELECT SERVERPROPERTY('computernamephysicalnetbios') AS ServerName ,t1.virtual_machine_type_desc ,Server_type = CASE WHEN t1.virtual_machine_type = 1 THEN 'Virtual' ELSE 'Physical' END FROM sys.dm_os_sys_info t1
Results Set: [ServerName] [virtual_machine_type_desc] [Server_type] NYC-DB-01 HYPERVISOR Virtual
Results Set: [ServerName] [virtual_machine_type_desc] [Server_type] PRD-SRV-01 NONE Physical
TSQL #2:
DECLARE @result int EXEC @result = xp_cmdshell 'SYSTEMINFO'
Results Set: System Manufacturer: VMware, Inc. System Model: VMware Virtual Platform
Results Set: System Manufacturer: HP System Model: ProLiant DL580 G5
TSQL #3:
select @@version
Results Set: (see end of string - Hypervisor) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
CMD Prompt: MSINFO32
System Manufacturer: VMware, Inc. System Model: VMware Virtual Platform
Powershell:
get-wmiobject win32_computersystem | fl model
Output:
model : VMware Virtual Platform
(fl = format list)
|
|
|
|
|