April 2016
Intermediate to advanced
416 pages
10h 24m
English
Overview
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.