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

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

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