Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

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

Microsoft System Center 2012 Configuration Manager: Administration Cookbook

4 (8)
Buy this Book
close
close
Microsoft System Center 2012 Configuration Manager: Administration Cookbook

Microsoft System Center 2012 Configuration Manager: Administration Cookbook

4 (8)
Buy this Book

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)
close
close
close
Microsoft System Center 2012 Configuration Manager: Administration Cookbook
Icon
Microsoft System Center 2012 Configuration Manager: Administration Cookbook
Credits
Icon
Credits
About the Authors
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Free Chapter
1
Designing a System Center 2012 Configuration Manager Infrastructure
Icon
Designing a System Center 2012 Configuration Manager Infrastructure
Icon
Introduction
Icon
Dividing up site system roles
Icon
Creating migration jobs
Icon
Installing SQL the right way
Icon
Managing Internet-facing clients
Icon
Using remote and workstation distribution points, and BranchCache
2
Deploying Windows 7 with Operating System Deployment
Icon
Deploying Windows 7 with Operating System Deployment
Icon
Introduction
Icon
Creating an OSD test environment
Icon
Leveraging the build and capture process
Icon
Migrating user state
Icon
Managing drivers
Icon
Customizing the build process with prestart hooks
Icon
Patching your reference build
Icon
Leveraging the Microsoft Deployment Toolkit with CM12 OSD
3
Deploying Applications and Software Updates
Icon
Deploying Applications and Software Updates
Icon
Introduction
Icon
Creating applications and deployment types
Icon
Managing Software Center and Application Catalog
Icon
Preparing for software updates
Icon
Creating and monitoring software updates
Icon
Leveraging Automatic Deployment Rules
Icon
Reducing collection dependencies with conditional rules and global conditions
Icon
Deploying custom updates
Icon
Converting classic packages to applications
Icon
Creating and deploying Virtual Applications (App-V)
Icon
Superseding applications
Icon
Monitoring content and deployment status
4
Managing Compliance Settings
Icon
Managing Compliance Settings
Icon
Introduction
Icon
Building Configuration Items
Icon
Creating and deploying a baseline
Icon
Leveraging Security Compliance Manager
Icon
Monitoring compliance with SSRS
5
Managing Sites
Icon
Managing Sites
Icon
Introduction
Icon
Managing collections
Icon
Configuring site maintenance
Icon
Managing site communications
Icon
Configuring discovery
Icon
Managing Boundary Groups
Icon
Managing role-based security
Icon
Configuring the Application Catalog
Icon
Managing and validating content for DPs and DP groups
6
Managing Clients
Icon
Managing Clients
Icon
Introduction
Icon
Deploying clients
Icon
Managing client health
Icon
Managing client settings
Icon
Monitoring client installation and activity
Icon
Making use of user centric improvements
Icon
Configuring power management
7
Managing Inventory
Icon
Managing Inventory
Icon
Introduction
Icon
Managing hardware inventory
Icon
Managing software inventory
Icon
Managing software metering
Icon
Monitoring inventory data flow
Icon
Integrating Asset Intelligence
8
Managing Reports and Queries
chevron up
Icon
Managing Reports and Queries
Icon
Introduction
Icon
Installing SQL Server Reporting Services (SSRS)
Icon
Configuring Reporting Services
Icon
See also
Icon
Sharing your reports with others
Icon
Building queries
Icon
Editing and creating reports
Index
Icon
Index

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 CM12'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...

  1. Open SSMS, enter the name of your...

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
Start a 7-day FREE trial
End of Section 7
Next Section

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
Order Page Read Now

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