Book Image

Microsoft System Center Configuration Manager Cookbook - Second Edition

By : Samir Hammoudi, Matthew Hudson, Greg Ramsey, Brian Mason, Chuluunsuren Damdinsuren
Book Image

Microsoft System Center Configuration Manager Cookbook - Second Edition

By: Samir Hammoudi, Matthew Hudson, Greg Ramsey, Brian Mason, Chuluunsuren Damdinsuren

Overview of this book

This practical cookbook is based on the 1602 current branch of System Center Configuration Manager (SCCM). It shows you how to administer SCCM, giving you an essential toolbox of techniques to solve real-world scenarios. Packed with over 60 task-based and instantly usable recipes, you’ll discover how design a SCCM Infrastructure, and dive into topics such as the recommended SQL configuration for SCCM and how to deploy Windows 10 with Operating System Deployment (OSD). You will learn to easily manage Windows 10 devices by deploying applications, software updates, and feature upgrades, andl be able to leverage Mobile Device Management (MDM) using SCCM and Microsoft Intune. Finally, you see how to gather the inventory of all your PC park and create reports based on it. By the end of the book, you will have learned the best practices when working with SCCM and have a handy reference guide for troubleshooting.
Table of Contents (15 chapters)
Microsoft System Center Configuration Manager Cookbook - Second Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface

Introduction


CM gathers a 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 watchsmsprov.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.