Node Details - Hardware - Virtual Host by xx.xxx.xxxx , Virtual Unknown & Physical

chiranjeevi

I have been searching all over thwack & db tables.. But I could not find how we get Virtual Unknown & Physical for Node Hardware details. I found details about Virtual Host by xx.xxx.xxxx 

SELECT TOP 10 n.NodeID, n.Caption, n.IP_Address, n.MachineType, h.HostName, h.VMwareProductName AS Host_Type, h.VMwareProductVersion AS Host_Version
FROM Orion.VIM.VirtualMachines v
INNER JOIN Orion.VIM.Hosts h on v.HostID = h.HostID
INNER JOIN Orion.Nodes n ON v.NodeID = n.NodeID

So Please help to find details about Virtual Unknown & Physical

Thanks in Advance