How to pull or get the list of cpu cores for a device or group of devices

That is a loaded question when working with SolarWinds.   If you have Virtualization Manager installed, then you just look at the summary page:

What tools do you have installed?    What hardware are you trying to scan?   If you could provide more information, myself or someone else in THWACK can point you in the right direction.

Actually you can get it even without the virtualization monitor.  SW does some rudimentary virtualization without VMan.  The field, CpuCoreCount, can be found in the table Orion.VIM.Hosts.  Here is a SWQL query I wrote for a report on VMware hosts.  CpuCoreCount is the last field on the first line.

SELECT N.Caption, H.HostName, H.IpAddress, S.StatusName, H.VMwareProductVersion AS VMware_Version, H.Model, H.Vendor, H.ProcessorType, H.CpuCoreCount,

              H.CpuPkgCount AS Sockets, H.CpuMhz, H.MemorySize / (1024*1024*1024) AS MemoryGB,

              (Select SUM(V.Size) AS DiskSpace 

               FROM Orion.Volumes V

               WHERE H.NodeID = V.NodeID AND V.Type LIKE 'Fixed Disk')/(1024*1024*1024) AS DiskSpaceGB,

              (Select SUM(V.Size) AS DiskSpace

              FROM Orion.Volumes V

              WHERE H.NodeID = V.NodeID AND V.Type LIKE 'NetworkDisk')/(1024*1024*1024) AS SanDiskGB,

              H.NicCount, H.HbaCount, H.HbaFcCount, H.HbaScsiCount, H.HbaIscsiCount, H.BuildNumber, H.NetworkUtilization, H.NetworkUsageRate, H.NetworkTransmitRate,

              H.NetworkReceiveRate, H.NetworkCapacityKbps, H.CpuLoad, H.CpuUsageMHz, H.MemUsage, H.MemUsageMB, H.VmCount, H.VmRunningCount,

              H.StatusMessage

FROM Orion.VIM.Hosts H

JOIN Orion.StatusInfo S ON H.Status = S.StatusId

JOIN Orion.VIM.DataCenters D ON H.DataCenterID = D.DataCenterID

JOIN Orion.VIM.VCenters C ON D.VCenterID = C.VCenterID

JOIN Orion.Nodes N ON C.NodeID = N.NodeID

WHERE H.VMwareProductName LIKE 'VMware ESXi'

The report looks like this

Great SWQL query!   I knew someone else would bite on this one!   Good job yellowtj   Hope the world it is treating you with dignity and respect!  

Here I am requesting to pull the cpu and memory components for the routers and switches from SolarWinds web console report and database table.

Hi Zenifer, 

First Congratulations on being an MVP!  This one was easy as I had written the report just a few months ago.  The biggest challenge was finding the right report!

You can find that in the Orion.Nodes table.  Look for the fields CPUCount, CPULoad,  MemoryAvailable and MemoryUsed.  You will need to figure out how to differentiate between networking gear and other devices.  A sample query might look like this:

SELECT IPAddress, Caption, Description, DNS, Vendor, Location, Contact, Status, CPUCount, CPULoad, MemoryAvailable, PercentMemoryUsed, PercentMemoryAvailable
FROM Orion.Nodes
WHERE Vendor LIKE 'Cisco'