Report or Query to show number of physical processors

[nhottinger]

I've looked around a bit but have yet to come up with a good query or report to show the number of physical processors on our servers. Can anyone help?

[Peter33]

SELECT        v_R_System.Netbios_Name0, v_GS_COMPUTER_SYSTEM.NumberOfProcessors0, 
                         v_GS_PROCESSOR.NumberOfCores0, v_GS_PROCESSOR.NumberOfLogicalProcessors0, v_GS_OPERATING_SYSTEM.Caption0 AS Expr1
FROM            v_R_System INNER JOIN
                         v_GS_PROCESSOR ON v_R_System.ResourceID = v_GS_PROCESSOR.ResourceID INNER JOIN
                         v_GS_OPERATING_SYSTEM ON v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN
                         v_GS_COMPUTER_SYSTEM ON v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
WHERE        (v_R_System.Is_Virtual_Machine0 = 0) AND (v_GS_OPERATING_SYSTEM.Caption0 LIKE N'%server%')
GROUP BY v_R_System.Netbios_Name0, v_GS_COMPUTER_SYSTEM.NumberOfProcessors0, v_GS_PROCESSOR.NumberOfCores0, 
                         v_GS_PROCESSOR.NumberOfLogicalProcessors0, v_GS_OPERATING_SYSTEM.Caption0

This should work.

[nhottinger]

Sorry for my ignorance, but how do I use this? I attempted to paste this into a query rule but got errors.

[Peter33]

That's a SQL query. You can run it from SQL Management Studio.