Solved

SCCM 2012 Hardware Inventory Report

Posted on 2014-11-19
7
2,424 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
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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 100
Lifters 4 80
Elementary Technology Curriculum 3 28
will india ph work in usa? 21 54
Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

816 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now