More Reports for the Masses from SCCM
In an earlier article, I went through two useful ways to receive reports from System Center 2012 R2 Configuration Manager as alternatives to using the SCCM Management Console to run reports.
Subscriptions are indeed a fine way to ensure that a report is available when and where you need it. Sometimes, however, a user might want to run a report just once instead of a regular update. For that we needn’t install the management console but rather have the user point his or her web browser to the Report Manager website.
As you probably already know, Microsoft SQL Server is already working hard behind the scenes managing the SCCM site database. The database engine is responsible for that but MS SQL Server also has other components that provide useful services, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Of course SSRS is a prerequisite for the Reporting Services Point site system role and is used to provide a robust and efficient, industry-standard report server. In so doing it also provides the alternative to console-based access to reports: the Report Manager Website.
Report Manager is a web-based report access and management tool that you use to administer a single report server instance over an HTTP connection. You can use Report Manager for operational tasks, for example, to view reports, modify report properties, and manage associated report subscriptions.
We are interested in viewing reports on demand. To run reports, you must have Read rights for the Site permission and the Run Report permission that is configured for specific objects.