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 Follwing 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

About Lei

I am an IT specialist with over 10 year experience - years on Automation, on-Premise or Azure.

I am happy to develop however never want be a full time developer. Only do what I have to do. If it has to be PowerShell,HTML, PHP, CSS, C#, VBS or JS, front end or backend, so be it, doesn't matter!

Spent years with Windows, SCCM, SharePoint, SQL and Exchange servers. For last several years, I have been actively working under On Premise > Azure environment.

THERE IS NO WAY BACK!!!

Current Certificates:
    Microsoft® Certified-
  • -Enterprise Administrator
  • -Database Administrator
  • -SharePoint Administrator
  • -Administering and Deploying SCCM 2012
Red Hat Certified Technician
ITIL V3 Foundation - Practitioner

Working on Azure Certificates now and hopefully they can stop upgrading their questions one day! GIVE ME A BREAK!

Contact Lei

Name *
Email *
Comments *

Traffic since 10/08/2016

Today13
Yesterday83
This week637
This month1933
Total416293

Visitor Info

  • IP: 54.221.73.186
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

1
Online

2017-12-17

Login