OS Info Report.

er.vansh17091

OS Info.

Find more posts tagged with

Accepted answers

All comments

m-milligan

This query will pull the information you need for your report only information about nodes that are not ESX hosts:

select N.Caption as [Node],
Count(N.AssetInventory.Processor.Name) as [Total CPU Sockets],
Sum(N.AssetInventory.Processor.NumberOfCores) as [Total CPU Cores],
Max(N.AssetInventory.Processor.Manufacturer) as [CPU Vendor],
Sum(N.AssetInventory.Processor.NumberOfCores)/Count(N.AssetInventory.Processor.Name) as [CPU Cores Per Socket]
from Orion.Nodes N
WHERE N.VirtualMachine.VirtualMachineID is NULL
Group By N.Caption
HAVING Count(N.AssetInventory.Processor.Name) > 0
ORDER BY N.Caption

er.vansh17091

Hi M-Milligan,

Really fantastic. Thank you so much for your valuable answers. Its working.

er.vansh17091

Hi M-Milligan,

ESXi (VMware) devices details are not showing/missing. can you please have a look and do the needful.

Report Description:

Please create a report that includes the number of CPU sockets, CPU Cores per Socket, CPU Vendor, Total CPU Cores. This should target all physical servers (Windows, Linux, Solaris, ESXi, Nutanix, Xen).

m-milligan

Ah, I forgot that CPU, etc for ESX hosts is in Orion.VIM.Hosts, not Orion.Nodes. Try this:

SELECT [Node], [Total CPU Sockets], [Total CPU Cores], [CPU Vendor], [CPU Cores Per Socket]
FROM
(select N.Caption as [Node], 
Count(N.AssetInventory.Processor.Name) as [Total CPU Sockets], 
Sum(N.AssetInventory.Processor.NumberOfCores) as [Total CPU Cores], 
Max(N.AssetInventory.Processor.Manufacturer) as [CPU Vendor], 
Sum(N.AssetInventory.Processor.NumberOfCores)/Count(N.AssetInventory.Processor.Name) as [CPU Cores Per Socket] 
from Orion.Nodes N 
WHERE N.VirtualMachine.VirtualMachineID is NULL 
Group By N.Caption 
HAVING Count(N.AssetInventory.Processor.Name) > 0 
UNION
(
SELECT H.HostName as [Node],
H.CpuPkgCount as [Total CPU Sockets],
H.CpuCoreCount  as [Total CPU Cores],
H.ProcessorType  as [CPU Vendor],
H.CpuCoreCount/CpuPkgCount as [CPU Cores Per Socket] 
FROM Orion.VIM.Hosts H
)
) AS Physical
ORDER BY Physical.Node

This will select any ESX hosts and any nodes that do not have a counterpart in Orion.VIM.VirtualMachines.