Microsoft SQL Reporting Services has a security delegation model that you can apply to all the reports that you create. System Center 2012 R2 Configuration Manager introduced role-based security on the default reports. This role-based security model ensures that when running reports, the user can only see objects that they have been granted access to view.
The delegation does not, however, extend to custom reports you create. You must secure these reports using the standard SSRS model. This recipe shows you how you can modify your custom reports to comply with and use the new security model introduced with the 2012 R2 version on the Configuration Manager.
You must plan to review Chapter 3, Unpacking System Center Report Building Tools, as a primer to this recipe. You must have access to a configured System Center 2012 R2 Configuration Manager environment that has the Reporting Service Point role successfully enabled. Additionally...