ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 14: SQL Reporting

ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 14: SQL Reporting

Back to main menu

Part 14 describes the configuration of SQL reporting in Config Mgr 2012. I will also show a sample report and how to export the report to PDF and xls files.


Navigate to Administration/Site Configuration/Servers and Site System Roles
Right click server and choose Add Site System Roles




Add Site System Roles wizard starts



Verify server name


Enter Proxy details if required - not required in this deployment. 


Select Reporting Service Point


Verify database details


Click next to add the Reporting Service Point






Reports are now available in Monitoring/Reporting



See sample report



Click on the drop down arrow to choose file format 



Sample PDF


Sample Excel file

No comments:

Post a Comment