You're reading from Microsoft System Center 2016 Service Manager Cookbook Discover over 100 practical recipes to help you master the art of IT service management for your organization

Product type Paperback

Published in Feb 2017

Publisher Packt

ISBN-13 9781786464897

Length 638 pages

Edition 2nd Edition

Tools

Microsoft System Center Configuration Manager

Concepts

IT Service Management

Authors (5):

Steve Buchanan

Anders Asp

Steve Beaumont

Dieter Gasser

Andreas Baumgarten

+1 more

View More author details

Table of Contents (16) Chapters

Preface

1. ITSM and ITIL Frameworks and Processes FREE CHAPTER

2. Personalizing SCSM 2016 Administration

3. Configuring Service Level Agreements (SLAs)

4. Building the Configuration Management Database (CMDB)

5. Deploying Service Request Fulfilment

6. Deploying and Configuring the HTML5 Self-Service Portal

7. Working with Incident and Problem Management

8. Designing and Configuring Change Management and Release Management

9. Implementing Security Roles

10. Working with the Data Warehouse and Reporting

11. Extending SCSM with Advanced Personalization

12. Automating Service Manager 2016

13. Whats New in SCSM 2016 and Upgrading from SCSM 2012 R2

A. Community Extensions and Third-Party Commercial SCSM Solutions

B. Useful Websites and Community Resources

Introduction

Service Manager periodically transfers data that is stored in the operational database to the Service Manager Data Warehouse databases through a process called Extract Transform and Load (ETL). The processes required for keeping the data in the Data Warehouse in sync with the operational database are controlled by the Service Manager Data Warehouse Management Server role.

The ETL process is started on a scheduled interval. The first step is the extract workflow, which reads new data from the operational database and writes it to the DWStagingAndConfig database. The raw data is then picked up by the transform workflow, which does any reformatting required for bringing the data into the final format optimized for reporting prior to storing it in the DWRepository database. The load workflow then transfers the data to the DWDataMart database where it can be used for reporting.

The reasons for transferring data to the databases of the Service Manager Data Warehouse are the following...