imperial07 Posted August 14, 2014 Report post Posted August 14, 2014 Looking for some help on this. I have written reports before in SCCM 2007, but the process is now completely different in 2012. So I am looking to generate a report that shows me both the number of physical processors and number of cores for those processors for all of the servers in a specific collection. Any help on how I could get this information would be great. I have already seen this post (http://www.windows-noob.com/forums/index.php?/topic/11000-report-or-query-to-show-number-of-physical-processors/), which gets me some of the info, but I dont have all that I need. Plus I'm having a problem with this Report Builder method for doing this. Quote Share this post Link to post Share on other sites More sharing options...
Eswar Koneti Posted August 15, 2014 Report post Posted August 15, 2014 I would always recommend to use BIDS or Visual Studio to create SSRS reports as they give so many options and flexible to write quires. reg your query,both cores and processors information available from v_gs_processor. try to use the SQL query given below to get number of cores and number of logical processors. select fcm.Name,p.NumberOfCores0,p.NumberOfLogicalProcessors0 from v_GS_PROCESSOR P,v_FullCollectionMembership fcm where fcm.ResourceID=p.ResourceID and fcm.CollectionID='P0100772' Quote Share this post Link to post Share on other sites More sharing options...
