SCCM 2012 Report - All Workstation Computers Hardware Inventory

[Edgy41]

Hi all,

 

Need some assistance......

 

I am currently writing a 'Hardware and Lifecycle Manegement and Assessment Plan' for one of my company's customers in relation to thier fleet of Desktop Computer Systems. We have put in SCCM 2012 as the solution for Systems management and as part of the plan I an writing I would like to include a section that describes where / how to extract a full hardware inventory of all Workstation computers in SCCM. The inventory should include such things as:

 

• Name of Computer
• Serial Number / Service Tag (Dell systems)
• RAM
• Make and Model
• CPU
• HDD
• Video Card
• Spund Card
• Any other relevany info for Hardware inventory

So given all of the above, is there a default report in SCCM that will list this info in one single report? Or do I have to create a custom report for this? If so can someone recommend how I go about doing this exactly?

 

I should mention that I am very much the novice when it comes to SCCM reporting so any assistance here would be appreciated.

 

Thanks

[GarthMJ]

This report will get you started.

http://smsug.ca/blogs/garth_jones/archive/2008/02/04/basic-all-in-one.aspx

 

As an aside I would love to see you plan that you come up with. Feel free to ping me offline, my email address is easy to find.

[Ralegre7201]

GarthMJ,

 

Thank you for your code ! It helped me understand how to write report queries and where to find where the rows and columns were coming from.

 

I would like to modify one thing though:

 

CPU.CurrentClockSpeed0 --> CPU.NormSpeed0

[GarthMJ]

Are you ask or telling me?

[nhottinger]

Is there a way to write this so I can select the device collection to take the inventory from first? I'm asked for this info a lot of times from specific departments and I'm tired of manually going through the full inventory list and weeding them out.

[Peter van der Woude]

You mean you want to trigger a hardware inventory for a specific device? In that case have a look at third-party right-click tools.

[nhottinger]

I want to trigger a hardware inventory on a device collection.

[GarthMJ]

This will help you.

http://www.enhansoft.com/blog/how-to-perform-a-full-hardware-inventory-for-a-pc-collection-the-easy-way

[nhottinger]

That's not exactly what I'm looking to do. I was able to setup a custom report that will show all pc's, their model, amount of RAM, cpu speed, etc. Now I want that same report, but only on a specific collection. Running the full hardware inventory doesn't actually display anything for me, just runs the inventory.

[GarthMJ]

So what you try to use the report above to do what you want then? There are lots of examples on my blog of queries with collections.

[Tof006]

Hi GarthMJ

Thanks for this...

Is there a way to convert memory and harddrive sizes to Go ?

Thanks again