Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft System Center Configuration Manager Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
Microsoft System Center Configuration Manager Cookbook

Microsoft System Center Configuration Manager Cookbook

By : Samir Hammoudi, Hudson, Mason, Ramsey, Chuluunsuren Damdinsuren
3.5 (2)
close
close
Microsoft System Center Configuration Manager Cookbook

Microsoft System Center Configuration Manager Cookbook

3.5 (2)
By: Samir Hammoudi, Hudson, Mason, Ramsey, 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 (10 chapters)
close
close

Building queries

Seasoned CM admins should already understand the difference between SQL and WMI queries and how to write a subselect query. If you do, you should be able to skip ahead with just this one reminder-with CM's ability to use exclude or include in a collection query, you won't have to make subselect queries as often.

Now for all of the rest of you, we're going to show you how to make a query to show all machines which have Office installed. Then we'll show how to find all machines which don't have Office 2010 installed (and for that we need a subselect). We'll do this first in SQL and then again in WMI. SQL is for reports where WMI is more commonly used for CM console queries and collections.

Getting ready

You will need access to any machine with Microsoft SQL Server Management Studio (SSMS) installed. You will need SQL access to your primary site or CAS.

We're going to make a query to find all machines with Office 2010 installed.

How to do it....

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY