Install SCCM Reporting Point

SCCM Reporting allows administrators to analyze the data collected by SCCM clients, while ConfigMgr comes with a lot of predefined reports that while usually satisfy most requirements and companies can be customized to suit specific needs.

SCMM Reporting Point Requirements and Placement

SCCM Reporting Point can be installed on any SCCM Primary site where the SQL SSRS Native mode component is installed,  if you have follows my SCCM installation guide all necessary components are already in place on the Site Database Server.

In a multisite environment the placement of the SCCM Reporting Point can happen anywhere in the hierarchy anyhow if deployed on a CAS (Central Administration Site) global replicated data replication can be enabled.

SSRS can be either installed on the same machine where the Site Database is running which is is the simplest approach or can be installed a dedicates server even if by experience I can tell you all but biggest deployment will work perfectly with a cohosted SSRS and Site Database deployment.

SCCM Reporting Point Installation

Once the Reporting Point location has been decided to install the role open the ConfigMgr Administrator Console and navigate to [Administration] –> [Site Configuration] –> [Servers and Site System Roles] right-click on an available server and select Add Site System Roles

SCCM Reporting Point Add Role

In the General and Proxy pages just accept all default settings and click Next

SCCM Reporting Point General Page

SCCM Reporting Point Proxy Page

In Specify roles for this server select the checkbox next to Reporting Point

SCCM Reporting Point Role Selection

In the Specify Reporting Services settings most fields will be pre-populated, hit the Verify button to let ConfigMgr verify correctness of the various data by default the Report Folder Name is the ConfigMgr_<Site_Code> in the Username field you can either specify an existing user already defined in SCCM or specify a new account and let ConfigMgr delegate necessary permissions to access the database

SCCM Reporting Point Role Account Configuration

In the Summary page review information and when ready to deploy the Reporting Point Role click on Next, you can follow installation and make sure it is successful checking the  srspsetup.log log file or in the admin console navigate to [Monitoring] –> [System Status] –> [Component Status] and check the status of the SMS_SRS_REPORTING_POINT

SCCM Reporting Point Monitor Role

SCCM Reporting Point in Action

Once you have verified the Reporting Point has been correctly installed you can start running reports against collected data to access the reporting facility browse to http://<server_name>/Reports which will bring up the page where you can select the SCCM Site (in case the Reporting Point is installed on the CAS you will see all the sites composing the hierarchy) and the various built-in reports

SCCM Reporting Point Web Portal Site

SCCM Reporting Point Reports View

As you can great a wide number of ready reports are installed on the system to run a report simply click on a folder name the on the report and click Run here’s Disk information for a specific computer – Logical disks report for a computer in my lab

SCCM Reporting Point Run Report

As previously mentioned built-in reports cover all data gathered by SCCM clients so that you can visualize what actually is going on in your infrastructure but of course you can even customize reports to suit your needs directly from the web interface

SCCM Reporting Point Edit Report

[su_note note_color=”#ffff96″ text_color=”#000000″ radius=”5″]Note: The first time you will use the Edit in Report Builder link Report Builder 3.0 will be downloaded and installed on the computer. [/su_note]

Last but not least you can configure Reports Subscription which is used to automatically run and store reports in the desired format on a given schedule

SCCM Reporting Point Run Subscribe

SCCM Reporting Point Save Subscribed Report

In the above example I have shown you how to edit and subscribe to reports using the Reporting Point web portal but of course the same goal can be achieved directly from the ConfigMgr console.

I will not cover custom reporting in this post as this argument could fill a entire book but will touch it on future ports, if you are interested in going deep and master SCCM Reporting I suggest you to purchase of a copy of System Center 2012 Configuration Manager: A practical Handbook for Reporting written by MVP Steve Thompson which will cover everything you need to know and more about the fascinating SCCM Reporting.


One thought on “Install SCCM Reporting Point

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s