Chapter 8. Managing Reports and Queries

In this chapter, we will cover:

  • Installing SQL Server Reporting Services (SSRS)
  • Configuring Reporting Services
  • Sharing your reports with others
  • Building queries
  • Editing and creating reports

Introduction

CM12 gathers 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 the difference?

Structured Query Language (SQL) is used ...

Get Microsoft System Center 2012 Configuration Manager: Administration Cookbook 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.