You are previewing Microsoft System Center Reporting Cookbook.
O'Reilly logo
Microsoft System Center Reporting Cookbook

Book Description

Over 40 practical recipes to help you plan, create, and manage reports efficiently for all components of Microsoft System Center

In Detail

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.

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.

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.

What You Will Learn

  • Understand the goals of reporting

  • Plan and organize the reporting environment for sharing report parts and role-based security

  • Plan and design System Center reports

  • About the System Center report building tools available to you

  • Create powerful reports using System Center reporting databases

  • Create System Center advanced reports

  • Use Power BI to analyze and visualize System Center data

  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

    Table of Contents

    1. Microsoft System Center Reporting Cookbook
      1. Table of Contents
      2. Microsoft System Center Reporting Cookbook
      3. Credits
      4. Foreword
      5. About the Authors
      6. About the Reviewers
      7. www.PacktPub.com
        1. Support files, eBooks, discount offers, and more
          1. Why subscribe?
          2. Free access for Packt account holders
          3. Instant updates on new Packt books
      8. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      9. 1. Understanding the Goals of Reporting
        1. Introduction
        2. Understanding the goals of reporting
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Planning and optimizing dependent data inputs
          1. Getting ready
          2. How to do it...
            1. Optimizing Report Inputs
          3. How it works...
          4. See also
        4. Planning report outputs
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Mock up using Excel
          5. See also
        5. Understanding dashboards and their dependencies
          1. Getting ready
          2. How to do it...
            1. Static dashboards
          3. How it works...
          4. See also
        6. Targeting reports at decision stakeholders
          1. Getting ready
          2. How to do it...
            1. Proactive reporting
            2. Reactive reporting
            3. Highlight reporting
          3. How it works...
        7. Documenting report designs
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      10. 2. Planning System Center Report Design
        1. Introduction
        2. Understanding the reporting schemas of System Center components
          1. Getting ready
          2. How to do it...
            1. Configuration Manager
            2. Data Protection Manager
            3. Orchestrator
            4. Operations Manager
            5. Service Manager
            6. Virtual Machine Manager
          3. How it works...
          4. There's more...
            1. Components with multiple databases
          5. See also
        3. Understanding how SQL Reporting Services interfaces with System Center
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Building SQL queries the easy way
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      11. 3. Unpacking System Center Report Building Tools
        1. Introduction
        2. Planning the Report Builder installation
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. ClickOnce additional requirements
          5. See also
        3. Installing Report Builder
          1. Getting ready
          2. How to do it...
            1. Report Builder Standalone installation
            2. Report Builder ClickOnce installation
          3. How it works...
          4. See also
        4. Navigating through the Report Builder interface
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Organizing the reporting environment and delegating access to reports
          1. Getting ready
          2. How to do it...
            1. Planning the organization of the reporting environment
              1. Plan report manager folders
              2. Planning report delegation roles
            2. Creating the reporting organization folders
            3. Delegating access to the organization folders
          3. How it works...
          4. See also
        6. Creating data sources
          1. Getting ready
          2. How to do it...
            1. Creating an embedded data source
            2. Creating a shared data source
          3. How it works...
        7. Creating datasets and a basic report in Report Builder
          1. Getting ready
          2. How to do it...
            1. Creating a dataset
            2. Creating a basic report
          3. How it works...
        8. Preparing for report subscriptions
          1. Getting ready
          2. How to do it...
          3. How it works...
      12. 4. Creating Reports for System Center Configuration Manager
        1. Introduction
        2. Exploring the Configuration Manager database schema
          1. Getting ready
          2. How to do it...
            1. System Center Configuration Manager (2012 and above) primer
            2. Exploring the reporting schema using MSSMS
            3. Exploring the reporting schema using the System Center Configuration Manager console
          3. How it works...
          4. See also
        3. Delegating access to out-of-the-box Configuration Manager reports
          1. Getting ready
          2. How to do it...
            1. Active Directory group for reporting role
            2. Creating the Report Only security scope
            3. Adding Active Directory user group and configuring the reporting scope
          3. How it works...
          4. There's more...
            1. Verifying the delegation in the Report Manager website
          5. See also
        4. Preparing the SCCM reporting environment for reporting
          1. Getting ready
          2. How to do it...
            1. Creating SCCM Report Manager folders and performing delegation
            2. Creating a shared data source for the SCCM reports
          3. How it works...
          4. See also
        5. Creating Configuration Manager custom reports
          1. Getting ready
          2. How to do it...
            1. Creating the data source and datasets
            2. Creating the report
          3. How it works...
          4. There's more...
            1. Adding a description using a text box
            2. Inserting a company logo
        6. Applying role-based security to custom reports
          1. Getting ready
          2. How to do it...
            1. Getting the report user SID as a parameter
            2. Creating the Configuration Manager administrative users dataset
            3. Creating the parameter used by the admin dataset
            4. Changing the datasets to role-based
          3. How it works...
          4. See also
      13. 5. Creating Reports for SCOM and SCVMM
        1. Introduction
          1. System Center Operations Manager
          2. System Center Virtual Machine Manager
        2. Using out-of-the-box Operations Manager reports
          1. Getting ready
            1. Creating a folder for custom reports
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Creating favorite reports and publishing reports
            2. Scheduling reports
        3. Understanding the OperationsManagerDW schema
          1. Getting ready
          2. How to do it...
            1. Managed entities
              1. vManagedEntity
              2. vManagedEntityType
              3. vManagementPack
              4. vRelationship
              5. vManagementGroup
          3. How it works...
          4. There's more...
            1. Rules and monitors
        4. Preparing your environment to author reports
          1. Getting ready
          2. How to do it...
            1. Creating a shared data source
          3. How it works...
        5. Creating alert reports
          1. Getting ready
            1. Report Builder
            2. Alert dataset
              1. Alert.vAlert
              2. Alert.vAlertDetail
              3. Alert.vAlertParameter
              4. Alert.vAlertResolutionState
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Creating event reports
          1. Getting ready
            1. Event dataset
              1. Event.vEvent
              2. Event.vEventDetail
              3. Event.vEventParameter
              4. Event.vEventRule
          2. How to do it...
          3. How it works...
        7. Creating performance reports
          1. Getting ready
            1. Performance dataset
              1. Perf.vPerfDaily and Perf.vPerfHourly
              2. Perf.vPerfRaw
          2. How to do it...
          3. How it works...
          4. See also
        8. Creating availability reports
          1. Getting ready
            1. State dataset
              1. State.vStateHourly and State.vStateDaily
              2. State.vStateRaw
          2. How to do it...
          3. How it works...
        9. Using Virtual Machine Manager reports
          1. Getting ready
          2. How to do it...
          3. How it works...
      14. 6. Creating Reports for System Center Data Protection Manager
        1. Introduction
        2. Preparing the DPM reporting environment
          1. Getting ready
          2. How to do it...
            1. Creating and delegating read access to an Active Directory account user
            2. Creating DPM Report Manager folders and performing delegation
            3. Creating a shared data source for DPM reports
          3. How it works...
          4. See also
        3. Preparing a dataset query for a DPM agent status report
          1. Getting ready
          2. How to do it...
            1. Creating a dataset
          3. How it works...
          4. There's more...
            1. Converting byte values into MB or GB values
          5. See also
        4. Creating a DPM agent version and a disk space report
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Changing the color and font of the title
            2. Changing the background color of the headers
            3. Adding a size indicator bar to the used space column
        5. Creating a backup status report with a community template
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      15. 7. Creating Reports for System Center Service Manager and Orchestrator
        1. Introduction
          1. System Center Service Manager
          2. System Center Orchestrator
        2. Using out-of-the-box Service Manager reports and cubes
          1. Getting ready
          2. How to do it...
            1. Using out-of-the-box Service Manager reports
            2. Using out-of-the-box Service Manager OLAP cubes
          3. How it works...
          4. There's more...
            1. Accessing reports from a browser
            2. Creating favorite and linked reports
        3. Understanding the Service Manager Data Warehouse data mart
          1. Getting ready
          2. How to do it...
            1. Understanding dimensions
            2. Understanding facts
            3. Understanding outriggers
          3. How it works...
          4. There's more...
            1. Creating custom database objects for reporting
            2. Database permissions required for reporting
        4. Creating Work Item and Configuration Item reports
          1. Getting ready
          2. How to do it...
            1. Creating a Work Item report
            2. Creating a Configuration Item report
          3. How it works...
          4. There's more...
            1. Creating Service Level reports
          5. See also
        5. Creating reports using OLAP cubes
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Creating reports using the operational database
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Integrating the dashboard in the Service Manager console
        7. Accessing data using Microsoft Excel
          1. Getting ready
          2. How to do it...
          3. How it works...
        8. Extending the Service Manager Data Warehouse
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        9. Creating Orchestrator runbook reports
          1. Getting ready
          2. How to do it...
          3. How it works...
      16. 8. Creating System Center Advanced Reports
        1. Introduction
        2. Creating dashboards from basic reports
          1. Getting ready
          2. How to do it...
            1. Creating the Open Incidents report
            2. Creating the Active Alerts report
            3. Creating the combined dashboard
          3. How it works...
        3. Working with drillthrough reports
          1. Getting ready
          2. How to do it...
            1. Creating the Incident Details drillthrough report
            2. Linking the Open Incidents report to the Incident Details report
          3. How it works...
          4. There's more...
            1. Using drillthrough reports in charts
        4. Working with shared datasets and parameters
          1. Getting ready
          2. How to do it...
            1. Creating the Event Levels shared dataset
            2. Creating the Events Last 30 Days report
          3. How it works...
          4. There's more...
            1. Allow multiple values to be selected for a parameter
        5. Analyzing Chargeback reports using System Center 2012 R2 data
          1. Getting ready
            1. Virtual Machine Manager
              1. Creating clouds in VMM
              2. Provisioning virtual machines to clouds
            2. Operations Manager
            3. Service Manager
              1. Importing the Chargeback management pack
              2. Configuring the SCOM Connector
          2. How to do it...
            1. Creating price sheets
            2. Analyzing Chargeback data
          3. How it works...
      17. 9. Using Power BI to Analyze and Visualize System Center Data
        1. Introduction
        2. Configuring Microsoft Excel for System Center data analysis
          1. Getting ready
          2. How to do it...
            1. Installing the Power Query add-in
            2. Installing the Power Map add-in
            3. Enabling PowerPivot and Power View in Microsoft Excel
          3. How it works...
          4. See also
        3. Connecting to System Center data sources with Power Query
          1. Getting ready
          2. How to do it...
            1. Connecting to System Center data sources
            2. Explore the data and overview of the interface
            3. Extending the query with data from other queries
            4. Adding functions in your query
          3. How it works...
          4. There's more...
          5. See also
        4. Creating the data model with PowerPivot
          1. Getting ready
          2. How to do it...
            1. Data model design
            2. Visualization with PowerPivot
          3. How it works...
          4. There's more...
          5. See also
        5. Visualizing the analysis with Power View and Power Maps
          1. Getting ready
          2. How to do it...
            1. Creating Power View visualization
            2. Creating Power Map visualization
          3. How it works...
        6. Using Microsoft Cloud services to share and visualize System Center data
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      18. A. Useful Websites, Chapter Code, and Community Resources
        1. Authors' community blogs
        2. Useful community blogs
        3. Websites for SQL and reporting
          1. Cost-effective vendor reporting visualization and analytical options
        4. Online wikis and curations
          1. Social network resources
          2. Chapter code
          3. Custom.IncidentDashboard.View.xml code
          4. Accessing data using Microsoft Excel query code
          5. Extending the Service Manager Data Warehouse code
      19. Index