Solved

SCCM 2012 Hardware Inventory Report

Posted on 2014-11-19
7
2,702 Views
Last Modified: 2015-01-17
Hi Experts
I need to generate a report using SCCM 2012 that list all the workstation in our environment, can you point me to one of the default reports in SCCM 2012 reporting that can do this?
0
Comment
Question by:craigleenz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 5

Accepted Solution

by:
Dilip Patidar earned 500 total points
ID: 40454491
Hello Craigleenz,

Here, You can create a manually hardware Inventory report..

For that you have to run some query in SQL.

For SQL Query's you can visit below post Shane Jackson:

sccmitpro.wordpress.com/2014/08/28/create-custom-reports-in-sccm-based-on-sql-queries-configmgr/

Dilip Patel
0
 
LVL 5

Expert Comment

by:A Karelin
ID: 40454697
0
 

Author Comment

by:craigleenz
ID: 40463950
I require a report that list all workstation in our environment, machine serial, hardware model etc.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:A Karelin
ID: 40480307
I dont work with SCCM for some time. A lot stuff you can make by sccm console, eg create query, custom report. Try to use this query
http://smsug.ca/blogs/garth_jones/archive/2008/02/04/basic-all-in-one.aspx
0
 
LVL 23

Expert Comment

by:Nagendra Pratap Singh
ID: 40480313
Create a collection that contains the collection of WinXP, Win 7, Win Vista etc. Copy and paste in Excel.

Or you can use a SQL query as others have already pointed out.
0
 

Author Closing Comment

by:craigleenz
ID: 40555573
Thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question