Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By : Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten
Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By: Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten

Overview of this book

Keep your organization up to speed with the Microsoft System Center 2016 Service Manager Cookbook. Over 100 practical recipes for SCSM 2016 give you all the tools to master IT service management.
Table of Contents (23 chapters)
Microsoft System Center 2016 Service Manager Cookbook - Second Edition
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

Creating reports with Report Builder


This recipe will walk you through the steps of using Report Builder 3.0 to create new reports for Service Manager. We will also show you how to create a custom folder structure in SQL Server Reporting Services to store your reports in.

Getting ready

Although Report Builder offers a visual wizard for creating the queries that will be used for retrieving data from the Service Manager Data Warehouse database, it is hardly possible to work with reporting effectively without at least knowing the basics of the SQL used for querying relational databases.

Furthermore, you will need to get familiar with the database model of the DWDataMart database. Please refer to the Understanding the Service Manager Data Warehouse data mart recipe earlier in this chapter.

Also, you must install Microsoft .NET Framework 3.5 on all computers you intend to run Report Builder from.

How to do it...

First, we will create a custom folder structure in SQL Server Reporting Services to store...