Book Image

Microsoft System Center 2012 Configuration Manager: Administration Cookbook

Book Image

Microsoft System Center 2012 Configuration Manager: Administration Cookbook

Overview of this book

Microsoft System Center 2012 Configuration Manager (CM12) is a systems management application for managing large groups of Windows-based computer systems. System Center 2012 Configuration Manager provides remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory. This practical cookbook shows you how to administer System Center 2012 Configuration Manager and understand how to solve particular problems/scenarios Packed with over 50 task-based and immediately reusable recipes, this book starts by showing you how to design a System Center 2012 Configuration Manager Infrastructure. The book then dives into topics such as recommended SQL configuration for System Center 2012 Configuration Manager, deploying Windows 7 with Operating System Deployment (OSD), deploying Applications and Software Updates, managing Compliance Settings, managing Sites and managing Inventory amongst others.
Table of Contents (15 chapters)
Microsoft System Center 2012 Configuration Manager: Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Introduction


CM12 gathers vast amount of data from your clients, but in order to use that data to make useful asset reports, you will need to install SQL Server Reporting Services (SSRS) so that you can install a Reporting Services Point (RSP).

In order to edit the default reports that come with an RSP or to help locate and target certain systems or users with a deployment, you need to know how to create and edit queries (both SQL and WQL queries).

Tip

SQL versus WQL – what's the difference?

Structured Query Language (SQL) is used to query SQL database, such as the Microsoft SQL database used with CM. WMI Query Language (WQL) is used to query Windows Management Instrumentation (WMI). CM relies heavily on WMI. You can watch smsprov.log on any primary or CAS and learn a lot about WQL and SQL, including how to convert between the two. In CM, we use SQL to build reports, and WQL to create collections and queries.