seems it is included in CM12 now.
Select Distinct Netbios_Name0, Client0, Is_Virtual_Machine0, CS.Manufacturer0, Model0, OS.Caption0, OS.CSDVersion0, NumberOfProcessors0, P.NumberOfCores0, SystemType0, CPUType0, OS.OSArchitecture0, OS.OSProductSuite0, OS.OSType0, OS.ProductType0, P.Name0 From V_R_System VRS Left Join v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = VRS.ResourceID Left Join v_GS_OPERATING_SYSTEM OS on Os.ResourceID = VRS.ResourceID Left Join v_GS_PROCESSOR P on P.ResourceID = VRS.ResourceID Where Operating_System_Name_and0 Like '%Server%' On Thu, Dec 12, 2013 at 11:43 AM, Todd Hemsell <[email protected]> wrote: > Anyone have some SQL that returns how many processors and how many cores > on a device? > Needs to be very accurate as we want to use the info to pay for SQL. > > TIA, > > Todd > >
