Book description
Microsoft System Center Configuration Manager’s SQL Server
database contains valuable information about your users, computers,
hardware, operating systems, applications, compliance status, and
much more. Microsoft has provided excellent tools for extracting
this information in meaningful ways, including SQL Server Reporting
Services (SSRS) and SQL Server Data Tools Business Intelligence
(SSDT-BI). System Center Configuration Manager Reporting Unleashed
shows you how to make the most of these tools.
World-renowned System Center reporting guru Garth Jones and his
expert coauthors guide you through all facets of custom reporting
with System Center. You’ll walk through installing and
configuring SSRS, using SQL views to find the data you need,
writing SQL queries, creating basic and advanced reports, and using
role-based administration to securely deliver those reports to the
correct individuals.
Jones brings together reliable, comprehensive, and up-to-date
System Center reporting techniques you’ll find in no other
book or website. Using this guide, you can consistently retrieve
the right information to solve immediate problems and quickly
respond to management concerns.
Detailed information on how to…
• Install and configure SQL SSRS for optimal System Center
reporting and easier troubleshooting
• Understand the data stored in the ConfigMgr site
database
• Efficiently retrieve ConfigMgr data by writing SQL queries
in SQL Server Management Studio
• Learn best practices for developing and designing System
Center reports
• Create report templates, customize content with report
parameters, and embed charts
• Customize logos, color palettes, and other report elements
for your own organization
• Construct advanced drillthroughs to provide deeper
understanding
• Strengthen report security by integrating ConfigMgr
role-based administration into SQL queries
• Leverage reporting to measure KPIs and gain a better
understanding of your environment
• Tailor your reports to the needs of end-users or
management
• Foreword by Wally Mead, Principal Program Manager,
Cireson
The only book entirely dedicated to Configuration Manager
reporting, this guide complements Meyler's System Center 2012
Configuration Manager Unleashed, offering far more in-depth
coverage of reporting than the single chapter in that book. Most of
the content in this new guide will be equally valuable in both
System Center 2016 and 2012 environments.
Table of contents
- About This E-Book
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Authors
- Dedication
- Acknowledgments
- Foreword
- We Want to Hear from You!
- Reader Services
- Introduction
-
Part I: Installing and Configuring SSRS for Configuration Manager
- Chapter 1. Installing SQL Server Reporting Services
- Chapter 2. Installing and Configuring Configuration Manager Reporting
-
Part II: About Data and Retrieval
- Chapter 3. Understanding Configuration Manager Data
-
Chapter 4. Transact-SQL Primer
- Understanding the Basic SQL Sections in a Query
- Using Secondary Operators
- Understanding Aggregate Functions
- Understanding Date and Time Functions
- Transforming Data Stored in the ConfigMgr Database
- Understanding the SQL JOIN Statement
- Demonstrating SQL Operators
- Demonstrating Aggregate Functions
- Demonstrating Date and Time Functions
- Demonstrating Data Transforms
- Demonstrating JOIN Statements
- Summary
-
Part III: Using SSRS for Configuration Manager Reporting
- Chapter 5. Basic Report Design
- Chapter 6. Building a Basic Report
- Chapter 7. Intermediate Reporting Concepts
- Chapter 8. SSRS Reporting Features
- Chapter 9. Role-Based Administration and Reporting
-
Part IV: Appendixes
- Appendix A. Glossary
-
Appendix B. Demonstration Outcomes
- Chapter 2 Demonstration Outcomes
- Chapter 3 Demonstration Outcomes
- Chapter 4 Demonstration Outcomes
- Chapter 6 Demonstration Outcomes
- Chapter 7 Demonstration Outcomes
-
Chapter 8 Demonstration Outcomes
- Adding a Patch Compliance Progression Drillthrough Series
- Adding a Computer Hardware Information Drillthrough Series
- Applying a Custom Color Palette to Cycle Through Color Codes
- Applying a Custom Color Palette Based on Values
- Manually Adding Reports to the SSRS Website
- Publishing Reports to SSRS
- Creating a Subscription
- Chapter 9 Demonstration Outcomes
- Appendix C. Available Online
- Index
- Code Snippets
Product information
- Title: System Center Configuration Manager Reporting Unleashed
- Author(s):
- Release date: April 2016
- Publisher(s): Sams
- ISBN: 9780134466804
You might also like
book
System Center 2012 Configuration Manager Unleashed
This is the comprehensive reference and technical guide to Microsoft System Center Configuration Manager 2012. A …
book
Microsoft System Center: Troubleshooting Configuration Manager
Part of a series of specialized guides on System Center - this book delivers a focused …
book
System Center 2012 R2 Configuration Manager Unleashed: Supplement to System Center 2012 Configuration Manager (SCCM) Unleashed
Since Microsoft introduced System Center 2012 Configuration Manager, it has released two sets of important changes …
book
Troubleshooting System Center Configuration Manager
Troubleshoot all the aspects of your Configuration Manager installation, from basic easy checks to the advanced …