tsunami78 Posted July 29, 2014 Report post Posted July 29, 2014 Hello, I am new to SCCM, and have a 2007 R2 deployment I currently manage. We are migrating to 2012 R2 later this year, but in the meantime I have a request for an inventory report from our server team I'm trying to pull together. I've never worked with SSRS before, and have been struggling to find the right query. I'm hopful someone here could help. I'm trying to get the information below for all of our server systems: NetBios Name Domain Name OS Version/SP level Number of Processorss Number of Cores (preferrably just physical, not hyperthreaded) Physical or Virtual Physical Server Model info (e.g. HP Proliant DL368 G8) Location (If that's even possible) Does anyone have some recommendations? Thank you, J Mac Quote Share this post Link to post Share on other sites More sharing options...
rddvls1999 Posted July 30, 2014 Report post Posted July 30, 2014 Hi J Mac, I came across a powershell script that does most of what you need. You can probably tweak it to better suit your needs. You can find it at the link below. http://www.powershellpro.com/why-i-no-longer-hate-writing-documentation/614/ Hope this helps! Paul Quote Share this post Link to post Share on other sites More sharing options...
