Chapter 9. Managing Reports and Queries

In this chapter, we will cover the following recipes:

  • Installing SQL Server Reporting Services - SSRS
  • Configuring reporting services
  • Sharing your reports with others
  • Configuring report subscription
  • Building queries
  • Editing and creating reports

Introduction

CM gathers a vast amount of data from your clients, but in order to use that data to make useful asset reports, you will need to install SQL Server Reporting Services (SSRS) so that you can install a Reporting Services Point (RSP).

In order to edit the default reports that come with an RSP or to help locate and target certain systems or users with a deployment, you need to know how to create and edit queries (both, SQL and WQL queries).

Tip

SQL versus WQL - What's ...

Get Microsoft System Center Configuration Manager Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.