David,
I think you're looking for the SUM() SQL built-in function. It looks like you truly do have 64 logical CPUs. Remember, "logical" CPUs includes hyper-threading cores and real cores. If you only want the number of real cores, then use NumerOfCores0. http://www.w3schools.com/sql/sql_func_sum.asp select SUM(NumberOfLogicalProcessors0) from <view> where <view>.ResourceID = 123456 Hope this helps. Cheers, Trevor Sullivan From: [email protected] [mailto:[email protected]] On Behalf Of HELMS, DAVID C Sent: Monday, March 24, 2014 9:14 AM To: [email protected] Subject: [mssms] Report to show all processors (physical and logical) I am trying to produce a report that shows all the logical processors for a server. There doesn't seem to be a canned report in SSRS that will show this information. Wanted to reach out to see if someone else might have a sql query that will be able to provide me a total number without me breaking out the calculator? For this particular server it is showing me 64 for logical processors. Query in Database shows this. SSRS report shows this. Server actually shows this.
<<image001.png>>
<<image002.png>>
<<image003.png>>
