System Center Configuration Manager Reporting Unleashed

System Center Configuration Manager Reporting Unleashed
by Garth Jones and Dan Toll
Print Length 页数: 416 pages
Publisher finelybook 出版社:‏ Sams; 01 edition (26 April 2016)
Language 语言: English
ISBN-10: 0672337789
ISBN-13: 9780672337789
B01EJXNJXS
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.
Contents
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
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
Appendix C Available Online
Microsoft System Center配置管理器的SQL Server数据库包含有关您的用户，计算机，硬件，操作系统，应用程序，合规性状态等等的有价值的信息。 Microsoft已经提供了非常有用的工具，用于以有意义的方式提取此信息，包括SQL Server Reporting Services（SSRS）和SQL Server数据工具商业智能（SSDT-BI）。系统中心配置管理器报告释放显示如何充分利用这些工具。
世界知名的系统中心报告大师Garth Jones及其专家合着者指导您使用System Center进行自定义报告的所有方面。您将通过安装和配置SSRS，使用SQL视图查找所需数据，编写SQL查询，创建基本和高级报告，以及使用基于角色的管理，将这些报告安全地传递给正确的人员。
琼斯汇集了可靠，全面和最新的系统中心报告技术，您将在其他书籍或网站中找到。使用本指南，您可以始终检索正确的信息以解决即时问题，并快速响应管理问题。
关于如何…的详细信息
安装和配置SQL SSRS以获得最佳的系统中心报告和更容易的故障排除
了解存储在ConfigMgr站点数据库中的数据
通过在SQL Server Management Studio中编写SQL查询来有效地检索ConfigMgr数据
了解开发和设计System Center报告的最佳做法
创建报告模板，使用报告参数自定义内容并嵌入图表
为您自己的组织定制徽标，调色板和其他报告元素
构建先进的钻探，提供更深入的了解
通过将ConfigMgr基于角色的管理集成到SQL查询中来加强报告安全性
利用报告来衡量KPI并更好地了解您的环境
根据最终用户或管理层的需求量身定做报告
Cireson首席项目经理Wally Mead先生
唯一完全专用于配置管理器报告的书，本指南补充了Meyler的“System Center 2012 Configuration Manager发行版”，提供了比该书中单篇章节更深入的报道报道。这个新指南中的大部分内容在系统中心2016和2012环境中同样有价值。
目录
第一部分安装和配置SSRS for Configuration Manager
第1章安装Sql Server Reporting Services
第2章安装和配置配置管理器报告
第二部分关于数据和检索
第3章了解配置管理器数据
第4章Transact-Sql入门
第三部分使用SSRS进行配置管理器报告
第五章基本报告设计
第六章建立基本报告
第七章中级报告概念
第8章Ssrs报告功能
第9章基于角色的管理和报告
第四部分附录
附录A术语表
附录B示范成果
附录C在线可用
Sams Publishing System Center Configuration Manager Reporting Unleashed B01EJXNJXS.azw3
Sams Publishing System Center Configuration Manager Reporting Unleashed B01EJXNJXS.pdf