Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SCCM 2012 Hardware Inventory Report

Posted on 2014-11-19
7
Medium Priority
?
3,724 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
6 Comments
 
LVL 5

Accepted Solution

by:
Dilip Patidar earned 1500 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 24

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Getting a solution on Experts Exchange is pretty easy--if you are asking the right questions in the right way.  While you won't get answers like RTFM or STFW from EE, experts will shy away from questions that are not focused, are badly explained, o…
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…
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

580 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