Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Dan Toll, Garth Jones, Kerrie Meyler
System Center Configuration Manager Reporting Unleashed
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
Part II: About Data and Retrieval
Part III: Using SSRS for Configuration Manager Reporting
Part IV: Appendixes
Disclaimers and Fine Print
Part I: Installing and Configuring SSRS for Configuration Manager
Chapter 1. Installing SQL Server Reporting Services
Installing the SQL SSRS Component
Configuring SSRS
Configuring the SSRS Installation
Configuring Email
Enabling Remote Errors
Installing Client Tools for SSRS Reporting
Installing Client Tools
Installing SQL Server Data Tools Business Intelligence
Summary
Chapter 2. Installing and Configuring Configuration Manager Reporting
Creating the Reporting Services Point
Using ConfigMgr Security Reporting Roles
Creating a Security Reporting Role
Restricting Access to Reports
Removing a Security Role
Exporting and Importing Security Roles
Working with Security Roles
Applying a Security Role to a Security Group
Removing Permissions
Accessing ConfigMgr Reports
Changing the ConfigMgr Report Logo
Demonstrating Creating and Assigning ConfigMgr Security Roles
Working with the Report Reader Security Role
Working with the Software Updates Report Reader Security Role
Working with the Inventory Report Reader Security Role
Summary
Part II: About Data and Retrieval
Chapter 3. Understanding Configuration Manager Data
Using Data Classes and SQL Views
Using Discovery Classes
Using Hardware Inventory Classes
Using Software Inventory Classes
Using Software Update Inventory Classes
Using Software Metering Inventory Classes
Using Status Message Classes
Using State Messages
Using Collection Data Classes
Using Tools for Creating Reports
Introducing SQL Server Management Studio
Connecting to the ConfigMgr Database Server
Executing a Query in SQL Server Management Studio
Using the Object Explorer
Demonstrating SQL Server Management Studio
Creating and Executing a Query
Looking at Views
Summary
Chapter 4. Transact-SQL Primer
Understanding the Basic SQL Sections in a Query
Using the SELECT Statement
Using the FROM Statement
Defining Criteria with the WHERE Statement
Using ORDER BY
Using Secondary Operators
Using the DISTINCT Keyword
The GROUP BY Operator
Using SQL View Aliases
Using Operators
Column Naming in Query Results
Understanding Aggregate Functions
Using the COUNT Function
Using the MIN (Minimum) Function
Using the AVG (Average) Function
Using the MAX (Maximum) Function
Using the SUM Function
Understanding Date and Time Functions
Understanding Date Parts
Using Common Date and Time Functions
Transforming Data Stored in the ConfigMgr Database
Using the CASE Function
Converting Data with the CONVERT and CAST Functions
Using the ISNULL Function
Understanding the SQL JOIN Statement
What Is a JOIN?
Using the ResourceID Column
Using the v_R_System_Valid View
Explaining the JOIN Statements
Demonstrating SQL Operators
Running the Sample SQL File
Editing the Sample Query
Creating a Query with Aliases
Demonstrating Aggregate Functions
Creating a New Query
Using the COUNT Function
Demonstrating Date and Time Functions
Demonstrating Data Transforms
Applying the CASE Function
Applying the CAST and CONVERT Functions
Applying the ISNULL Function
Demonstrating JOIN Statements
Executing an Inefficient Query
Writing an Efficient Query
Working with the Different JOIN Statements
Summary
Part III: Using SSRS for Configuration Manager Reporting
Chapter 5. Basic Report Design
Understanding the Purpose of a Report Series
Using a Summarized Data Report
Using a List Report
Using a Detailed PC Report
Understanding Report Design Considerations
Providing a Consistent Look and Feel
Printed Versus Interactive Reports
The Benefits of Using Report Templates
The Ability to Export Reports
Using Custom Report Requests
Gathering Report Information
Questioning Report Requirements
Report Verification and Delivery
Report Life Cycle and Maintenance
Summary
Chapter 6. Building a Basic Report
Creating a Project
Creating a Basic Report
Creating a Data Source
Creating a Dataset
Setting the Size of a Report
Accessing Report Items
Adding a Table to a Report
Previewing a Report
Customizing a Report
Adding Background Color to Rows
Alternating Data Row Colors
Adding Interactive Sorting
Setting the Table Header Row to Repeat on All Pages
Adding a Page Header to a Report
Adding a Page Footer to a Report
Adding an Image to a Report
Demonstrating Basic Report Creation
Creating a New Project
Creating a Patch Compliance Progression Report
Creating a Computer Hardware Information Report
Summary
Chapter 7. Intermediate Reporting Concepts
Creating Report Templates
Creating a Report Template (8.5×11in)
Creating a New Report from a Template
Exporting Reports from SSDT-BI
Modifying the Page Size of an Existing Report
Using Report Parameters
Understanding the Value and Label Fields
Using Default Values
Understanding Cascade Prompts
Using Multi-Value Parameters
Adding a Simple Prompt
Adding a Dropdown Prompt
Adding a Multi-Value Parameter
Adding a Chart Item to a Report
Using Column Charts
Using Bar Charts
Using Line Charts
Using Pie Charts
Using Doughnut Charts
Using Other Chart Types
Adding a Chart to a Report
Customizing Chart Items
Adding an Action to a Chart
Demonstrating Template Creation
Creating Template Reports
Modifying Page Sizes for Existing Reports
Demonstrating Report Parameters
Updating the Patch Compliance Progression Report
Updating the Computer Hardware Information Report
Demonstrating Adding Chart Items
Adding a Chart to the Patch Compliance Progression Report
Adding a Chart to the Computer Hardware Information Report
Summary
Chapter 8. SSRS Reporting Features
Using Report Drillthroughs
Adding an Action on a Table Cell’s Value
Adding Hyperlinks to a Report Item
Adding a Subreport Item
Creating Custom Color Palettes
Available Out-of-the-Box Color Palettes
Setting Custom Color Codes
Setting Custom Color Codes by Values
Adding Reports to SSRS
Manually Adding a Report to SSRS
Publishing Reports from SSDT-BI to the SSRS Website
Creating Report Subscriptions
Demonstrating Report Drillthroughs
Patch Compliance Progression Drillthrough Series
Computer Hardware Information Drillthrough Series
Demonstrating Custom Color Palettes
Applying a Custom Color Palette to Cycle Through Color Codes
Applying a Custom Color Palette Based on Values
Demonstrating Adding Reports to SSRS
Manually Adding Reports to the SSRS Website
Publishing Reports to SSRS
Creating a Subscription
Summary
Chapter 9. Role-Based Administration and Reporting
How Role-Based Administration and Reporting Work
Using SQL Queries with RBA
Converting a SQL Query to a ConfigMgr RBA SQL Query
Testing a ConfigMgr RBA SQL Query
Using Reports and RBA
Updating SSDT-BI for RBA
Adding the DLL to a Report
Adding an RBA Dataset
Adding RBA Prompts to a Report
RBA Tips and Troubleshooting
RBA SQL Query Performance
Troubleshooting and Errors
Demonstrating Creating an RBA Report
Converting the Patch Compliance Progression Query to an RBA Query and Testing It
Converting the Patch Compliance Progression Report to an RBA Report
Converting the Computer Hardware Information Query to an RBA Query and Testing It
Adding a Chart to the Computer Hardware Information Report
Summary
Part IV: Appendixes
Appendix A. Glossary
Glossary of Terms
Appendix B. Demonstration Outcomes
Chapter 2 Demonstration Outcomes
Working with the Report Reader Security Role
Working with the Software Updates Report Reader Security Role
Working with the Inventory Report Reader Security Role
Chapter 3 Demonstration Outcomes
Creating and Executing a Query
Looking at Views
Chapter 4 Demonstration Outcomes
Demonstrating SQL Operators
Working with Aggregate Functions
Working with Date and Time Functions
Working with Data Transforms
Executing an Inefficient Query
Writing an Efficient Query
Chapter 6 Demonstration Outcomes
Creating a New Project
Creating a Patch Compliance Progression Report
Creating a Computer Hardware Information Report
Chapter 7 Demonstration Outcomes
Creating Template Reports
Modifying Page Sizes for Existing Reports
Updating the Patch Compliance Progression Report
Updating the Computer Hardware Information Report
Adding a Chart to the Patch Compliance Progression Report
Adding a Chart to the Computer Hardware Information Report
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
Creating and Assigning ConfigMgr Security Roles
Understanding Configuration Manager Data
Transact-SQL Primer
Basic Report Design
Building a Basic Report
Intermediate Reporting Concepts
SSRS Reporting Features
Role-Based Administration and Reporting
Index
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
About the Authors
Next
Next Chapter
Acknowledgments
Dedication
To our spouses for their patience, and to the team at Enhansoft
for their assistance.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset