What's the fastest method to list Physical servers from Virtual servers?

Question

We have nearly 300 servers, what's the fastest method to list or report on the Physical servers vs. Virtual servers?

Can I use a SQL variable in Custom NODE Properties also? If so, how?

byrona · Accepted Answer

I would use a SQL query.  The following one works for me but it also excludes any vCenter nodes since they are associated with our virtual infrastructure.  You may need to modify it for your use.

Hope this helps!

SELECT N.NodeID, N.Caption, N.Vendor, N.VendorIcon, N.CPULoad, N.TotalMemory, N.MemoryUsed
FROM Nodes N
LEFT JOIN VIM_VirtualMachines VM ON N.NodeID = VM.NodeID
LEFT JOIN VIM_Hosts VH ON N.NodeID = VH.NodeID
LEFT JOIN VIM_VCenters VC ON N.NodeID = VC.NodeID
WHERE VM.NodeID is NULL AND VH.NodeID is NULL AND VC.NodeID is NULL