I am trying to generate a report using a SQL query to get all the processor and server information from monitor windows servers in SCOM. I looked at a couple of table and views, such as dbo.MTV_ProliantServer with no luck. I can get the mode information but I need to type of processor and # of Physical CPUs. Please advise

First try to find things in scom. So you can go for the view all the way near the top of the monitoring pane (discovered inventory). Check how you can target what you are looking for. Info from the HP pack could be one. Another might be windows computer (shows number logical processors) or windows operating system (memory and logical processors). Well you can find it. If you fond it you can also run a scom report on the discovered inventory (Marnix Wolf had a post about that last year at thoughtsonopsmgr.blogspot.com ( http://thoughtsonopsmgr.blogspot.com/2010/11/scom-r2-please-show-architecture-x86-or.html ) which picks on the target you can find in discovered inventory. There are also ways to create custom reports in a slightly easier way by using data sources for scom and either visual studio or other ways to create reports. If you want to go to the datawarehouse with sql directly it is a matter of finding all these things the harder way. Check out http://systemcentercentral.com/BlogDetails/tabid/143/indexid/60805/Default.aspx and http://systemcentercentral.com/BlogDetails/tabid/143/IndexID/76257/Default.aspx . Good luck!Bob Cornelissen - BICTT (My BICTT Blog)

Hi, I think you can try to collect the processor information with WMI and generate a report based on it. Please refer to the method in the following post: Collecting and Monitoring information from WMI as performance data http://blogs.technet.com/b/kevinholman/archive/2008/07/02/collecting-and-monitoring-information-from-wmi-as-performance-data.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.