Skip to main content

Software Update Management- SCCM 2012

The below post explains the end to end process of software updates management in SCCM 2012 Pre-requisites: 1.  WSUS Server (WSUS 3.0 SP2 ) should be installed on the SCCM site server or if you want to install WSUS on another server, it is important that you install WSUS administration console as the SCCM Server uses API. This  link explains the step by step procedure to install WSUS 3.0 SP2 2. Install SUP-Software Update Point on the SCCM Server . 3. Reporting Services Point: Install reporting services point role as described in this link . 4. Client agent: The software update client agent should be enabled(will be enabled by default) and the settings have to specified as per the requirement. On SCCM console, go to Administration>Site Configuration>Client settings>Right click on Default client settings> Click on Properties. If required, we can create custom client settings and then enable client settings for that settings. Unde

Creating a Collection in SCCM 2012

The good thing about collections in SCCM 2012 is we have separate nodes for Users and Devices Collections helping us to segregate in a better way. There is a new node called “Assets and Compliance” that deals with the users, systems, metering and compliance settings.
While creating collections, we now have an option to include or exclude certain collections from the newly created collection. This is highly useful when you have to maintain an infrastructure where there are validated machines and the management doesn’t want to bring those machines under the radar.
Here, I am creating a device collection that consists of Windows 7 operating system machines.

1.Go to Assets and Compliance> Right click on Device collections> Click on Create Device collection.



2.   General tab:
Enter the collection name: here it is “All Windows 7 Systems”
Enter description, and most importantly click on browse and select a limiting collection.
Limiting collection has to be specified in CM 2012 to create a collection, it is mandatory.
Click Next.



3.  Membership rules:

Click on “Add Rule”, there are 4 options
·         Direct Rule- equivalent of “direct membership rule in SCCM 2007”
·         Query Rule- creating collection based on a “query or criteria”
·         Include collections: we can include collection using this option
·         Exclude collections: we can exclude collection using this option.

“Dynamically add resources” that was available in SCCM 2007 has been changed to “Use incremental updates for this collection”.
            Schedule a full update as desired



4. Query rule properties:

Enter the query rule name. Here it is “Windows 7 System”
Select the resource class; here I have selected “system resource”.
Click on Edit query statement to write a query or define a criterion.
Click on “Show query language” to write a query or click on “criteria” to define a criterion.



5.  Enter the query statement in query language as shown. 
     Click OK and click next
         Here, I am creating a windows 7 collection and so the below query is used.
         We can also use “criteria” method if we are not sure of the query.


Review summary and click Next to proceed. Click on Close to complete the wizard.

6. The collection is created now and available under “Device collections” node as shown.
Right click on the collection and click on “show members” to see the computers that are part of this collection.






Comments

Popular posts from this blog

Registering SPN for SQL Server for SCCM

If using a domain account to install SQL server 2008 R2 for SCCM, you have to register a SPN (Service Principal Name) in Active Directory for that domain account. Two SPNs for the account should be registered,     1. For NETBIOS name of the SQL Server     2. For the FQDN of SQL server. The procedure to do that is as follows 1. Log on to a domain controller; open a command prompt with administrative privileges. 2. Type the below commands replacing SQL server name. setspn –A MSSQLSvc/< SQL Server NETBIOS name >:1433<Domain\Account> setspn –A MSSQLSvc/< SQL Server FQDN >:1433 <Domain\Account> 3. As shown in the below screenshot, the server name here is  CM2012 for NETBIOS name and CM2012.CONTOSO.COM 4.  Verify the registration of SPN by typing the below command Setspn –L  <domain\account>

Consistency validation for SQL Server registry keys failed error -SQL for SCCM

During installation of SQL server, "Consistency validation for SQL Server registry keys failed” error pops up in the below scenarios. 1.   Previous installation of SQL exists. 2.   Inappropriate permissions on the registry keys of Microsoft SQL server. Solution that worked me is explained below. A. Identify the issue: 1. Go to %Program Files%\Microsoft SQL Server\100\SetupBootstrap\Log\”date  and time of installation” 2. Search (in Detail_GlobalRules.txt) for lines containing the following string "Could not fix registry key" 3. Run “regedit”, s et full control permissions for the appropriate registry keys mentioned in "Detail_GlobalRules.txt" file. Re-run the installation. B. Modifying the registry: 1. Locate HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server in registry. (To open registry, run “regedit”) 2. Right click and go to Permission 3. Click on Advance tab and c heck the below options.     i. Include i

Collection query to find Machines--based on GUID Criteria

You can use the below SQL query to create a new collection based on GUID. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SMBIOSGUID = " 18764D56-C91F-83A5-51FB-4AD4B6699D04 " Replace the GUID with the one that you intend to delete. This is particularly useful when performing OSD related tasks. To know how to create a collection , go through this link .