Book Image

Microsoft System Center Reporting Cookbook

By : Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail
Book Image

Microsoft System Center Reporting Cookbook

By: Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Overview of this book

<p>Microsoft System Center 2012 is an integrated management platform that helps you to easily and efficiently manage your data centers, client devices, and hybrid cloud IT environments.</p> <p>This hands-on cookbook will guide you through how to create ready-to-use reports for all the components of System Center. The book starts by showing you how to plan business valued reports, while also discussing the building blocks of your reporting framework. Moving on from the basics, the later recipes demonstrate how you can create System Center Configuration Manager reports using the report builder tool and System Center Operations and Virtual Machine Manager reports with data available from the Operations Manager databases.</p> <p>The book will then teach you how to build on and enhance the reports previously created by delving into advanced reporting techniques such as creating database reports, based on combined data sources. Finally, you will use Power BI to analyze and visualize System Center data, while also looking into the seamless integration between cloud services and System Center.</p>

Related Content you might be interested in

Current Title:

Small book image
Microsoft System Center Reporting Cookbook
Samuel Erskine | Dieter Gasser | Kurt Van Hoecke | Nasira Ismail
Mar, 2015 | 358 pages
No titles found
Table of Contents (18 chapters)
Microsoft System Center Reporting Cookbook
Microsoft System Center Reporting Cookbook
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Understanding the Goals of Reporting
Understanding the Goals of Reporting
Introduction
Understanding the goals of reporting
Planning and optimizing dependent data inputs
Planning report outputs
Understanding dashboards and their dependencies
Targeting reports at decision stakeholders
Documenting report designs
2
Planning System Center Report Design
Planning System Center Report Design
Introduction
Understanding the reporting schemas of System Center components
Understanding how SQL Reporting Services interfaces with System Center
Building SQL queries the easy way
3
Unpacking System Center Report Building Tools
Unpacking System Center Report Building Tools
Introduction
Planning the Report Builder installation
Installing Report Builder
Navigating through the Report Builder interface
Organizing the reporting environment and delegating access to reports
Creating data sources
Creating datasets and a basic report in Report Builder
Preparing for report subscriptions
4
Creating Reports for System Center Configuration Manager
Creating Reports for System Center Configuration Manager
Introduction
Exploring the Configuration Manager database schema
Delegating access to out-of-the-box Configuration Manager reports
Preparing the SCCM reporting environment for reporting
Creating Configuration Manager custom reports
Applying role-based security to custom reports
5
Creating Reports for SCOM and SCVMM
Creating Reports for SCOM and SCVMM
Introduction
Using out-of-the-box Operations Manager reports
Understanding the OperationsManagerDW schema
Preparing your environment to author reports
Creating alert reports
Creating event reports
Creating performance reports
Creating availability reports
Using Virtual Machine Manager reports
6
Creating Reports for System Center Data Protection Manager
Creating Reports for System Center Data Protection Manager
Introduction
Preparing the DPM reporting environment
Preparing a dataset query for a DPM agent status report
Creating a DPM agent version and a disk space report
Creating a backup status report with a community template
7
Creating Reports for System Center Service Manager and Orchestrator
Creating Reports for System Center Service Manager and Orchestrator
Introduction
Using out-of-the-box Service Manager reports and cubes
Understanding the Service Manager Data Warehouse data mart
Creating Work Item and Configuration Item reports
Creating reports using OLAP cubes
Creating reports using the operational database
Accessing data using Microsoft Excel
Extending the Service Manager Data Warehouse
Creating Orchestrator runbook reports
8
Creating System Center Advanced Reports
Creating System Center Advanced Reports
Introduction
Creating dashboards from basic reports
Working with drillthrough reports
Working with shared datasets and parameters
Analyzing Chargeback reports using System Center 2012 R2 data
9
Using Power BI to Analyze and Visualize System Center Data
Using Power BI to Analyze and Visualize System Center Data
Introduction
Configuring Microsoft Excel for System Center data analysis
Connecting to System Center data sources with Power Query
Creating the data model with PowerPivot
Visualizing the analysis with Power View and Power Maps
Using Microsoft Cloud services to share and visualize System Center data
Useful Websites, Chapter Code, and Community Resources
Useful Websites, Chapter Code, and Community Resources
Authors' community blogs
Useful community blogs
Websites for SQL and reporting
Online wikis and curations
Index
Index

Preparing the DPM reporting environment

Shortcuts lead to long delays! There is no shortcut for preparation. This recipe is focused on preparing your environment for your DPM custom reports.

Getting ready

You must plan to review Chapter 3, Unpacking System Center Report Building Tools, as a primer to this recipe.

How to do it...

The tasks discussed in this recipe are as follows:

  • Creating and delegating read access to an Active Directory user account to access the DPM database

  • Creating DPM Report Manager folders and performing delegation

  • Creating a shared data source for DPM reports

Creating and delegating read access to an Active Directory account user

Perform the following steps:

  1. Create a user called, for example, DPMRPT in Active Directory.

  2. Connect to the DPM SQL Server instance using SQL Server Management Studio.

  3. Create a new Windows login. Expand Security. Right-click on Logins and select New Login…, as shown in this screenshot:

  4. Ensure that Windows authentication is selected. Go to the AD account...

Previous Section
End of Section 3
Next Section