How to pull a hardware report with SCCM 2012

I have sccm 2012 in my environment and I have the cm client deployed to about 6500 systems.

How can I pull a report on the system, like make, model, specs, software?

thanks
rdefinoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LeoCommented:
Save this code as a .mof and import it into reports.

// *********************************************************************************
//
//  Created by SMS Export object wizard
//
//  
//  File Name: all-in-one.mof
//
// Comments :
//
//
// *********************************************************************************


// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
 Category = "Department Reports";
 Comment = "";
 GraphCaption = "";
 GraphXCol = 1;
 GraphYCol = 2;
 MachineDetail = FALSE;
 MachineSource = FALSE;
 Name = "All-In-One Machine Details";
 NumPrompts = 1;
 RefreshInterval = 0;
 ReportGUID = "{435A5365-5EE2-4C85-BC2F-6A894E7A682B}";
 
 ReportParams = {
instance of SMS_ReportParameter
{
 AllowEmpty = FALSE;
 DefaultValue = "";
 PromptText = "Enter Machine Name";
 SampleValueSQL = "select Name0 from v_R_System order by Name0";
 VariableName = "MachineName";
}};
 SecurityKey = "";
 SQLQuery = "select v_R_System.Name0, v_R_System.Resource_Domain_OR_Workgr0, v_R_System.User_Name0 as Username, v_R_User.Full_User_Name0, v_R_System.AD_Site_Name0 from v_R_System, v_R_User where v_R_System.Name0 like @MachineName and v_R_System.User_Name0 = v_R_User.User_Name0 and v_R_System.User_Domain0 = v_R_User.Windows_NT_Domain0
\n
\nselect v_GS_COMPUTER_SYSTEM.Manufacturer0, v_GS_COMPUTER_SYSTEM.Model0, v_GS_SYSTEM_ENCLOSURE.SerialNumber0 from v_R_System, v_GS_SYSTEM_ENCLOSURE, v_GS_COMPUTER_SYSTEM where v_R_System.Name0 like @MachineName and  v_R_System.ResourceID = v_GS_SYSTEM_ENCLOSURE.ResourceID and v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
\n
\nselect v_R_System.Operating_System_Name_and0 as OperatingSystem, v_GS_OPERATING_SYSTEM.CSDVersion0 as ServicePack, v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as Memory from v_R_System, v_GS_X86_PC_MEMORY, v_GS_OPERATING_SYSTEM where v_R_System.Name0 like @MachineName and  v_R_System.ResourceID = v_GS_X86_PC_MEMORY.ResourceID and  v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID
\n
\nselect v_GS_LOGICAL_DISK.Name0 as Drive, v_GS_LOGICAL_DISK.Size0 as Size, v_GS_LOGICAL_DISK.FreeSpace0 as FreeSpace from v_R_System, v_GS_LOGICAL_DISK where v_R_System.Name0 like @MachineName and v_GS_LOGICAL_DISK.DriveType0 = 3 and  v_R_System.ResourceID = v_GS_LOGICAL_DISK.ResourceID order by v_GS_LOGICAL_DISK.Name0
\n
\nSelect v_GS_PROCESSOR.MaxClockSpeed0, v_GS_PROCESSOR.Name0,v_GS_PROCESSOR.Manufacturer0 from v_r_system, V_gs_processor where v_R_System.Name0 like @MachineName and v_R_System.ResourceID = v_GS_processor.ResourceID
\n
\nselect v_GS_ADD_REMOVE_PROGRAMS.Publisher0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS.Version0 from v_R_System, v_GS_ADD_REMOVE_PROGRAMS where v_R_System.Name0 like @MachineName and  v_R_System.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID order by v_GS_ADD_REMOVE_PROGRAMS.DisplayName0";
 StatusMessageDetailSource = FALSE;
 UnicodeData = FALSE;
 XColLabel = "";
 YColLabel = "";
};
// ***** End *****
0
rdefinoAuthor Commented:
How do I access the report on sccm?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

rdefinoAuthor Commented:
I found the reports, and the dummies for reports. :)

But, how do I import the file?
0
rdefinoAuthor Commented:
I saved the code to a mof using notepad+ but the import tells me "it could not be compiled".

Did I save it correctly?
0
LeoCommented:
try to run some small reports before running this, so you get an idea on how reports are run......
0
rdefinoAuthor Commented:
I;m able to run reports, but I cannot import this report. Invalid code error.

thanks for the help
0
LeoCommented:
whats the error?can you attach a screenshot.....
0
rdefinoAuthor Commented:
Here it is.
Capture.PNG
0
LeoCommented:
please go through this link.....there are solutions for .mof import errors........
http://blogs.technet.com/b/configurationmgr/archive/2010/01/05/the-configuration-manager-service-pack-install-guide.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rdefinoAuthor Commented:
Still working on it. Thanks for the link
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.