Book Image

Microsoft System Center 2012 Service Manager Cookbook

Book Image

Microsoft System Center 2012 Service Manager Cookbook

Overview of this book

Microsoft System Center Service Manager (SCSM) offers enterprises a complete, integrated platform for automating and adapting IT Service Management best practices to your organization's requirements. "Microsoft System Center Service Manager Cookbook" provides you with real-world, immediately usable recipes which will show you how to configure and administer System Center Service Manager 2012 and understand how to solve particular problems and scenarios to take this tool further. In Microsoft System Center Service Manager Cookbook, you will get to grips with practical recipes which will show you how to configure and administer System Center Service Manager 2012. This cookbook features distinct recipes on the practical implementation of ITSM Frameworks and Processes, Microsoft System Center 2012 Service Manager Administration, how to configure Service Level Agreements (SLAs). It will also cover incident and problem management, the design of change and release management as well as implementing and editing security roles.
Table of Contents (20 chapters)
Microsoft System Center 2012 Service Manager Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 that 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 that does the required reformatting 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 to:

  • Offload data...