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
In the General and Proxy pages just accept all default settings and click Next
In Specify roles for this server select the checkbox next to Reporting Point
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
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 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
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
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
[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
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.