Archive for August, 2012

SCCM 2012 – Software Center Options

The original information came from this source, I’m just adding a few more screenshots for my benefit.

The following script will allow you to change a particular setting found in SCCM 2012’s Software Center.

In Software Center, under the Options tab, and under the Computer maintenance heading, there is a setting – Automatically install or uninstall required software and restart the computer only outside of the specified business hours – that can be set to True (checked) or False (unchecked) by using this script.
Use the following code to obtain the current status of the option. This code you’ll use as the Discovery script.
$getStatus = Invoke-WmiMethod -Namespace "Root\ccm\ClientSDK" -Class CCM_ClientUXSettings -Name GetAutoInstallRequiredSoftwaretoNonBusinessHours -ComputerName $env:ComputerName -ErrorAction STOP

If ($getStatus.AutomaticallyInstallSoftware -eq "True")
Write-Host "Compliant"
Write-Host "Non-Compliant"
Here’s how you’ll add this code to a Configuration Items object.
Next, we’ll need to add the code to make the change or Remediation script
Invoke-WmiMethod -Namespace “Root\ccm\ClientSDK” -Class CCM_ClientUXSettings -Name SetAutoInstallRequiredSoftwaretoNonBusinessHours -ArgumentList @($TRUE) -ComputerName $env:ComputerName -ErrorAction STOP
Here’s how you’ll add this code to a Configuration Items object.
Next, we need to configure a Compliance Rule for the Configuration Item.
Now, as the final portion, we need to create a Configuration Baseline based on the Configuration Item created here and then deploy the Configuration Baseline.


Wake-on-Lan (WoL) with DELL Optiplex

We wanted to get Wake-on-Lan (WoL) to work on our DELL Optiplex 990 desktops with Windows 7.

Here’s how we got this work in our environment. (Make sure your DELL computers are running the latest BIOS version.)

Enable BIOS settings:
  1. Under Power Management
    1. Enable – Wake on Lan ( LAN Only )
      1. This one is needed for Windows 7 and to allow the machine to be woken up from a sleep state
    2. Disable – Deep Sleep Control
      1. This one is needed to allow to boot up the machine when the machine has been shutdown

Enable Windows 7 settings:
  1. Go to Window’s Device Manager
  2. Go to the properties for your primary network card
  3. Go to the Power Management tab
  4. Click to enable Allow this device to wake the computer
Note: Make sure you create an incoming rule in Windows 7 firewall to allow some of the WoL testing tools to run properly.

Network settings:

  1. If you’re working on a large network, then make sure your network team adds ip directed-broadcast on the router/switch interface where you’ll be sending WoL packets.
We now have all the settings necessary to get WoL working.

To test these settings, you can use the following tools:

Wake-on-LAN monitor/sniffer – great tool! (See Windows 7 settings note)

Wake-on-LAN magic packet sender tool


Deploy Pervasive SQL v10 SP3 Using SCCM 2012

Here are the steps to deploy Pervasive SQL v10 SP3 client to your Windows 7 machines using Microsoft’s SCCM 2012.

  1. Create an application package, and you’re going to use SetupWorkgroup_x86.exe
  2. Use the following installation parameters: SetupWorkgroup_x86 /s /v/qn
    1. Type it as shown above. There is no space in /v/qn
  3. For the Uninstall program, look at the screenshot below. You can leave it blank for now, but go back and the proper information once the wizard is complete.
  4. In the Detection Method section, you’re going to look for the MSI file PervasivePSQLv10WGE_x86.msi; this file is also located in the same folder as the setup file in step 1.
These steps worked in my environment.

Leave a comment

Add a link to Favorites side bar (Windows 7/2008)

The Favorites side bar in Explorer is found (in Windows 7/2008) under C:\Users\%username%\Links folder. By default, this folder contains three link (.lnk) files: Desktop.lnk, Downloads.lnk and RecentPlaces.lnk.

I wrote a VB script that you can append to your network login script to create new entries in this section.

Option Explicit

‘ Create link for J drive
‘ Passing the following information to CreateLinkFile Subroutine:
‘ First: Dfs link or URL destination path
‘ Second: Link description
‘ Third: Name of link (.lnk) file
CreateLinkFile “\\Dfs\link\OrSharePath\”, “A Description”, “NameOfLnkFile.lnk”

‘ =============================
‘ Create link files for J drive
‘ =============================
Sub CreateLinkFile ( LinkTargetPath, LinkDescription, LinkFileName )

‘ Variable declarations
Dim wshShell, oShellLink, fso, strLinkFilenameAndPath

‘ Set workspace environments
Set fso = CreateObject( “Scripting.FileSystemObject” )
Set wshShell = CreateObject( “WScript.Shell” )

‘ strLinkFilenameAndPath variable holds full path where .lnk file will be saved
‘ Path is based on environment variable %USERNAME%
strLinkFilenameAndPath = “C:\Users\” & wshShell.ExpandEnvironmentStrings ( “%USERNAME%” ) & “\Links\” & LinkFileName

‘ Llink will be created only if it doesn’t already exist
If Not fso.FileExists ( strLinkFilenameAndPath ) Then

‘ .LNK file to be created in C:\Users\%USERNAME%\Links folder
Set oShellLink = wshShell.CreateShortcut( strLinkFilenameAndPath )
oShellLink.TargetPath = LinkTargetPath ‘ Absolute path to the executable, file, folder, or URL
oShellLink.Description = LinkDescription ‘ Short description, optional
oShellLink.WindowStyle = “1”             ‘ 1 = Default, 3 = Maximized, 7 = Minimized
End If

End Sub

Leave a comment

MS SQL Server 2008 R2 Native Client – Deployment

In order to deploy Microsft SQL Server 2008 Native Client, follow these steps.

  1. Download it from here
  2. Once you get the MSI, create an application in SCCM 2012
  3. In the Programs tab, you’re going to use the following syntax to execute the MSI: msiexec /i “sqlncli_x64.msi” /q IACCEPTSQLNCLILICENSETERMS=YES
  4. Done
Note: Any time you use the /q parameter you must include IACCEPTSQLNCLILICENSETERMS=YES to accept the terms. This parameter only works for the client, as the title of this document reads.

1 Comment

MS Office 2010 – Disable welcome screen

Since we’re getting ready to deploy Microsoft Office 2010 Professional Plus in our company, I was asked to disable the Welcome Screen from Office 2010.

First, make sure you run Setup.exe /admin (this allows you to run MS customization tool).

Then, follow the screenshot below.

Leave a comment