In this Post we are going to install the role “Reporting Services Point”. By installing this role, we can run hundreds of in-build reports to check various status of deployments, inventory, client status etc.
Launch SCCM Console and navigate to Administration \ Overview \ Site Configuration \ Servers and Site System Roles
On Right Pane, you will be able to see Site Servers. Select the Server, right click and select “Add Site System Roles” to open the Site System Roles Wizard. Select next to continue.
Under Proxy Page, select next to continue.
Under “Site Role Selection“, you will see list of roles available to install on server. Check the box “Reporting services point” and click next.
This is the most important page for reporting Service point installation. Make sure current Database name is mentioned. Click on verify to confirm.
Under “Reporting Services Server instance”, it should show SSRS as we previously installed SQL Server Reporting Services with instance name SSRS.
Select existing or new username which will be used to connect SQL Reporting Services to SCCM Database.
Click next, confirm the settings to complete the installation.
Verify following logs for successful installation of role:
srsspsetup.log : To verify exit code 0 is returned.
srsspMSI.log : msi installation of reporting point installation to verify exit code returning 0.
Verify another log file as well (srsrp.log) which will show list of all reports getting installed.
Once installation is completed, launch SCCM console, navigate to Monitoring \ Reporting. On Right Pane, you will be able to see following links
Report Manager : http://sccm01/Report Report Server : http://sccm01/ReportServer.
Click on Report Manager link to launch the reports.
This will launch the web URL for reporting services where you can browse all kinds of reports specified under various categories.