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

Understanding the Service Manager Data Warehouse data mart


The purpose of this recipe is to describe the database schema of the Service Manager Data Warehouse data mart. Knowing the anatomy and the design of the data mart is key to successfully creating custom reports for System Center Service Manager.

Getting ready

The central repository that stores all data available for Service Manager reporting is the DWDataMart database. This database is located on the SQL Server, hosting the Service Manager Data Warehouse databases, and is also referred to as the Service Manager data mart.

Although SQL Server Report Builder and other tools used for authoring reports offer visual wizards for creating the queries that will be used for retrieving data from the Service Manager Data Warehouse data mart, it is hardly possible to work with reporting effectively without at least knowing the basics of the SQL used for querying relational databases.

The Service Manager Data Warehouse data mart is documented and...