Introduction to SQL reporting

- [Instructor] Sequel Server Reporting services provides a full range of ready to use tools and services to help you create reports for your organization. Here are some of the different tools and features of reporting in SCCM. We can display reports by using the configuration manager report viewer or by using report manager, which is a web based connection to the report. This provides high performance, availability and scalability. We can also see reports in Sequel Server Report viewer if we choose to not install the SCCM version.

Subscriptions to reports allows users to subscribe to reports for updated timely information. For example, a manager could subscribe to automatically receive an emailed report each day that details the status of a software update rollout. Export reports, so users can select to send reports in a variety of popular formats. These can then be emailed or shared by colleagues for information on the state of software deployments and other SCCM information. The reporting services point copies the configuration manager report definitions to reporting services.

It also creates folders based on report categories and set security policy on the report folders and reports. This is based on the role based permissions for configuration manager administrative users. Configuration manager provides report definitions for over 400 reports in 50 report folders. Which are copied to the route folder in Sequel Server Reporting services during the reporting services point installation process. Reports folders in system center configuration manager provide a method to sort and filter reports that are stored in reporting services.

When you install a reporting services point, reports are copied to reporting services and organized into those 50 report folders. Configuration manager uses Microsoft Sequel Server Reporting services Report Builder as the exclusive authoring and editing tool for both model based and sequel based reports. When you initiate the action to create or edit a report in the configuration manager console, Report Builder automatically opens. Sequel Reporting services in configuration manager uses Report Models to help administrative users select items from the database to include in model based reports.

You can give database fields and views logical business names to facilitate producing reports. You can also group them logically. You can define relationships between them, and you can secure model elements so that administrative users can see only the data that they have permission to see. As you can see, reporting in configuration manager is very flexible and useful to the administrator. You can use canned reports or create your own custom views.