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

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 Structured Query Language (SQL) used for querying relational databases.

Furthermore, you will need to get familiar with the database model of the DWDataMart database. The database model is well-documented and is part of the SM Job Aids, which can be downloaded from the Microsoft website:

http://www.microsoft.com/en-us/download/details.aspx?id=27850

Also, you must install Microsoft .NET Framework 3.5 on all computers you intend to run Report Builder from...