Script for creating Maintenance Windows in SCCM2012 with an offset to patch Tuesday

Since there is no built in way to create a Maintenance Window with an offset to patch Tuesday I have created a script that will do if for you. Patch Tuesday is always the second Tuesday in the month but what if you want to patch on Wednesday after Tuesday? Look at April 2015 for example, the month starts with...

Read More»

Designing dynamic OSD environments and task sequences

What is the issue? Something I see fairly often is poor design of task sequences in an OSD environment. Do you need multiple task sequences for different driver sets? No. Do you need multiple task sequences for different application installs? No. Do you need different task sequences for different OS images? No. This is not to say all problems can...

Read More»

SQL Server Inventory Using ConfigMgr

Here’s a script to gather complete SQL Server inventory information using ConfigMgr. I’ve tested and used it to gather information on SQL Server 2005, 2008, 2008 R2, and 2012. I haven’t tested it on 2014 explicitly, but it should work fine. Note that Sherry already has a series of mof edits posted at Installed SQL05, SQL08, SQL12, SQL14 […]

The post SQL Server Inventory Using ConfigMgr appeared first on ConfigMgrFTW!.

Read More»

ConfigMgr 2012 WSUS Synchronization Errors

One particularly hot topic at the Midwest Management Summit 2014 conference last month was a relatively recent but increasingly frequent issue that was called out by Kent Agerlund in his blog post “House of Cards – The ConfigMgr Software Update Point and WSUS” (referred to all week as “the house of cards post”). This issue seemed to be popping up...

Read More»

Update SQL Always On Cluster with ConfigMgr and Powershell

How to update a cluster with a cluster-ignorant tool I’ve recently been tasked to create a process to patch SQL Always On Availability Groups (I guess calling it a cluster is not really accurate?!) with just the tools I had available, no new implementation of stuff. This meant to do a proper patching cycle (Operating System AND SQL) with graceful failovers of SQL roles from one node to the other, no data loss. So, quick inventory; what did I have? ConfigMgr 2012 R2 PowerShell Phew, PowerShell, you can do a lot with PowerShell. ConfigMgr, mhhh, ConfigMgr can do Software Updates and execute stuff on machines when it is told to … Continue reading

Read More»

DCR – A quick glimpse of how many Updates are in multiple Software Update Groups

Have you ever needed to quickly see how many ConfigMgr Software Updates are in a large number of Software Update Groups? You can use PowerShell easily enough, but you are in the ConfigMgr console every day, shouldn’t this information be available in the console? If you want to see it, please vote up this DCR request on Connect. DCR –...

Read More»

Implementing System Center Configuration Manager 2012 R2 in the Real World

Join expert trainer Johan Arwidmark for a comprehensive guide to Microsoft System Center 2012 R2 Configuration Manager. Johan will show you how to design and setup ConfigMgr 2012 R2 for a real world production environment. You will also learn to migrate from ConfigMgr 2007 SP2 to ConfigMgr 2012 R2, as well as upgrade existing ConfigMgr 2012 SP1 environments to ConfigMgr...

Read More»

How to use Collection Variables outside of Task-Sequences

Out of the box, Collection and Device Variables are only usable from within Task-Sequences. To get the Variables outside of Task-Sequences, you can install an additional WMI Provider (https://gallery.technet.microsoft.com/ConfigMgr-Collection-1650d5bc) that provides the Variables and Values in a separate WMI Class (root\ccm\clientsdk:EXT_CollectionVariables ) Example to get all Variables assigned to the local device: Get-WMIObject -Namespace ‘root\ccm\clientsdk’ -Class ‘EXT_CollectionVariables’ Example to get...

Read More»