tsunami78

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