O'Reilly logo

Microsoft System Center 2016 Service Manager Cookbook - Second Edition by Dieter Casser, Steve Buchanan, Steve Beaumont, Andreas Baumgarten, Anders Asp

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required