Powershell - Enable incremental updates on collections

I am busy at the moment migrating a customer from SCCM 2007 to 2012, as part of the migration I disabled incremental updates on all collections so as not to hurt performance. The customer has a folder of collections that they use to deploy software via active directory groups, all collections are prefixed "AD Deploy". They wanted to enable scheduled & incremental updates on these collections only so I set to do this with powershell, disappointed that there was no cmdlet for this I turned to WMI.

Using the SMS_Collection class from the SMS namespace I was able to filter on collections begining with "AD Deploy" and set the property (RefreshType in this case) to a value of 6, which would enable incremental and scheduled updates. Below is the script I came up with.


#======Start Script==============
$Collections = (Get-WmiObject -Class SMS_Collection -Namespace "root\SMS\site_007" -ComputerName . -Filter "Name Like 'AD Deploy%'")

$Count = 0
foreach ($Col in $Collections){
$Col.RefreshType = 6
$Col.put() | Out-Null
Write-Host $Col
write-host $Col.Name
$Count ++
}
write-host $Count "collections in total"

#=========End Script===========

Here is a link to the script

You can change the filter for collections in your environment if you wish to use it, I would also recommend commenting out the "$Col.put() | Out-Null" line for the first run and do a manual check/count of the collections that this might actually affect ;)

Hope it helps someone out there :)

Wayne

Tuning your ConfigMgr 2012 Reporting Point For Speed

I have been doing some testing around this as the speed I see on the reporting node is often disappointing, and I have made some (not so shocking) discoveries. To speed up your reporting point do the following:

1. Set the initial Size of the ReportServer$ database, by default it is 6mb! once you install a RP it jumps to around 90 and then starts to increase for every report you run. Set its initial size to 1024mb that should help.
2. Set the autogrow on the database to 1024, it shouldn't ever grow beyond the initial 1024 anyway.
3. Set the initial size of the ReportServer$ transaction logs to 1024mb
4. Set the autogrow on the transaction logs, again 1024mb is fine,as long as you take a backup you should be fine, providing you....
5. Set the recovery mode to SIMPLE. If you don't do this then be prepared to hit disk space issues down the line. Setting to simple commits the logs and starts afresh after a backup
6. Set the ReportServer$TempDB inital size to 1024mb with autogrow at 1024mb again
7. Split the ReportServer$TempDB into X number of files where X= as many cores as you have (e.g4 vCpus = 4 files) up to a maximum of 8 files (and I do recommend 8 if you can)
8. Set the sizes of these files to 1024mb and their autogrowth to 1024mb

Restart the SQL services or the whole box and check out how fast it is, I can barely keep up :)

NB. This was all tested quick and dirty in a lab environment, so please size accordingly and monitor in your environment to ensure all is well.

Wayne

SCCM 2007 Migration failure due to site system named LOCALHOST

This post covers an issue I encountered during a migration and how to fix it.

If you are performing a Configuration Manager 2007 to 2012 Migration and have a site system in the console with the name LOCALHOST that holds the ConfigMgr site server database role as shown:

You will see the following error in the Migmctrl.log file when attempting to gather data from the source hierarchy in your 2012 environment:

To fix this you must run ConfigMgr setup from the 2007 Site server:

When the wizard launches be sure to select Perform Site Maintenance or reset the Site

On the desired action page select Modify SQL Server Configuration

On the SQL Server Configuration page change LOCALHOST to the name of the ConfigMgr 2007 server.

Allow the wizard to complete and review the log file when given the opportunity. You should now see in the console that the ConfigMgr site server database role is now held by the correct site system and not LOCALHOST.

Back in the 2012 environment, retry the data gather and you should have a little more success :)

Wayne

Windows Intune user sync issues

Following on from Steve Beaumont's post around Windows Intune, it is possible to use the .onmicrosoft address you chose to sync users into the cloud.

My testlab is called testlab.local and my chosen Intune domain name is testlab2013.onmicrosoft.com

To get my users syncing I had to create a UPN suffix in AD of "testlab2013.onmicrosoft.com", alter the users logon name to the new suffix, delete the users from SCCM and force a user discovery and hey presto the users began to sync upto Windows Intune no problems.

This is obviously great for a lab as you don't need to own a domain and don't need to verify any domains to do any testing

Cheers
Wayne

Software Asset Management (SAM) With SCCM 2012

In this post I want to explore managing licensing within using only SCCM 2012 SP1.

Neil Peterson created a fantastic 3 part blog post that shows how to remove unused software from machines using Orchestrator here: http://bit.ly/1162RqF

In this however he does not cover the very basics of importing 3rd party licenses into configuration manager so that is what I will cover here.

Firstly you must manually create a CSV file that holds the licensing information you wish to import.

In an ideal world the procurement department would create this file, upload it to an internal webpage along with a few basic details and orchestrator would take it from there, but here I am focusing on SCCM and SCCM alone, lets assume we have neither the luxury of time nor orchestrator :)

The CSV File

The csv file must be structured in a certain manner, below is a basic example:

However there are a few caveats with this, these are:

• Name, Publisher, Version and EffectiveQuantity columns must contain information the rest are optional
• Any dates entered must be in the format mm/dd/yyyy
• Name and Version must also match what is in the site database for that piece of software.

To obtain the vales for 7-Zip that you see in my example above I logged onto the SQL server that held the SCCM database, right clicked on the database and selected New Query and then entered the following

SELECT * FROM V_GS_INSTALLED_SOFTWARE WHERE ProductName0 LIKE %Zip%

This returned all of the database rows containing ZIP (1 in total) shown below

Now the information the query returned I was able to build my license file.

Once the file was ready I saved it as a .CSV file and opened with notepad to check the formatting, then went ahead and imported into SCCM.

Importing A Custom CSV file into SCCM

Open the console and navigate to Assets And Compliance -> Asset Intelligence. Right click on Asset Intelligence and select Import Software Licenses, run through the wizard ensuring you select General License statement when given the choice. Once complete navigate to Monitoring -> Reporting and run the report named License 15A - General License Reconciliation Report
This will show you a basic license count and usage and most importantly the difference between the two.

That's all for this post, obviously this can be expanded upon greatly, this is merely the foundations for anyone just starting out with SAM via SCCM.

Cheers
Wayne