SCCM 2012 Serial Number Report

Just for my reference, I choose to write this article to give myself a quick solution for my future Reporting Configuration.
Part 0.
Enable Hardware inventory through Client settings -> Default settings.


Part 1:
Install Reporting Service Role:
1. Go to Administration->Server and Site System Roles-> Right Click on your DATABASE server, add Site System Roles->
General->Next>Proxy>Next> System Role Selection > Choose Reporting Service Point >next....

Part 2. Configure Reporting.
1. Open IE as Administrator, type in Http://<DatabaseServerName>/Reports
2. Put your mouse over The site Code, From the Dropdown list Select Security.
3. Add the report Users/Group by use New Role Assignment.
4. Once finished, Edit, and give all access to the user.
5. Dont leave this page. Since we can build a report in next step.

Part 3. Build a customized report with Comuter Serial Number
1. From the same page or click Home to the SQL server Reporting Services page,(You can do this through Console as well.) Click Report Builder.
2. New Report -> Table or Matrix Wizard ->
3. Choose a dataset -> Create a Dataset -> Next
4. Choose the default data source and test Connection, next -> Edit as Text
5. Copy Following and paste it to the Text Area

Select 
sys.Name0 Machine, CS.UserName0 'User Name',OS.Caption0 OS, OS.CSDVersion0 'Service Pack',CS.Manufacturer0 Manufacturer,CS.Model0 Model,BIOS.SerialNumber0 'Serial Number',RAM.Capacity0 Memory, cs.SystemType0
 From 
v_R_System SYS,v_GS_COMPUTER_SYSTEM CS,v_GS_PC_BIOS BIOS , v_GS_OPERATING_SYSTEM OS, v_GS_PHYSICAL_MEMORY RAM 
 where 
sys.Name0=cs.Name0 and sys.ResourceID=OS.ResourceID AND sys.ResourceID=ram.ResourceID 
and sys.ResourceID=bios.ResourceID
  --Where 
sys.Name0 = @variable 
and 
order by sys.Name0

6. Run by click F5 or Exclamation Mark, See if there are results. If there are not much, it is because you dont have too much records yet, wait couple of days there will be more.
7. Next, Drag all the fields to Vlaues -> Next
8. Next-> Select Style -> Next -> Finish
9. You can customize other area by use tools above the field, it is like word. So you can insert title or picture or background.
10. Save and Close it.
11. After save it on the root location , refresh the home page, you should see the page is there, click it you can view the report online.
Cheers.




Reference:
1. Enable Hardware Inventory.
http://technet.microsoft.com/en-us/library/hh301103.aspx
2. Installation and Configure Reporting
http://www.windows-noob.com/forums/index.php?/topic/4550-using-sccm-2012-rc-in-a-lab-part-11-adding-the-reporting-services-point-role/
3. SCCM 2012 Reporting: Get system serial number & create custom SSRS report
http://blogs.technet.com/b/infratalks/archive/2013/09/10/sccm-2012-reporting-get-system-serial-number-amp-create-custom-ssrs-report.aspx