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 Excel file