Wednesday, February 27, 2013

DCM Script Detect SQL Edition SKUNAME

The script below will check if you have a version of SQLServer insalled and Echo the Edition Skuname and process Architecture.  This is particulary useful if you deem SQL Server on workstations to be a non-compliant trigger.  Now you can validate whether the echoed line is not allowed i.e SQL Server Enterprise

On Error Resume Next
' First try SQL Server 2008/2008 R2:
Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement10")
If Err.Number <> 0 Then
    ' Next, try SQL Server 2005:
    Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement")
    If Err.Number <> 0 Then
        ' Next, try SQL Server 2012:
        Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement11")
    End If
End If

Set colItems = objWMIService.ExecQuery( _
    "select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'SKUNAME'")
For Each objItem in colItems
    Wscript.Echo  objItem.PropertyStrValue

Tuesday, February 26, 2013

Trimble Yuma2 Lan9500 PXE boot Usb to Ethernet Adapter

Trimble Yuma2 Lan9500 PXE boot Usb to Ethernet Adapter

For Latitude 10 or Trimble Yuma2 PXE booting you will need an adapter with a Lan9500 chipset.  Dell offer the following adapter but it does not work and is only Lan7500

Manufacturer Part# 49W1V
Dell Part# 331-9318

Wednesday, February 13, 2013

Google Earth Pro Repackaged for SCCM with license key

Tags: install google earth pro with license key

Google Earth Pro can be downloaded here

Select Version 7.0 and un-tick “allow Google Earth to install Recommended Updates Automatically”.  Most Enterprise software is highly controlled and making sure versions are consistent and understood is essential.


GoogleEarthProWin.exe can be installed silently with the following switch.

GoogleEarthProWin.exe /S /v/qn /V"/qn ALLUSERS=1"


Or you can extract the exe to get at the MSI using a tool like 7zip.  The switch here is: msiexec /i "Google Earth Pro.msi" /qn


The issue that most SCCM Admins face is how to deploy Google Earth Pro with the license details included in the package.


In my example I will use InstallShield to create an MST file to transform the MSI file.


Once you have installed GEP you will be prompted for the username and password credentials.  Input them, and click “Auto login”.

 (Please be careful when modifying the registry, i accept no responsibility)

Open Regedit and navigate to top level path representing your current user hive. i.e HKEY_Users\S-1-5-21-########


Right Click:  Software/Google/Google Earth Pro and export reg key ( i.e. C:\temp\gep\gep.reg)

Change the key path to HKLM and remove all entries except for, as below:





"Passport"="Insert Password"

"Username"="Insert Username"



This is all that is required to for any user to open Google Earth Pro without being prompted for credentials.

Now open Installshield and create a new MST project.

Click on System Configuration\Registry\

Right click on HKLM and select Import Reg file… Select the Reg created above.

Save the project to make the MST file (GoogleEarthPro7.0.mst)

Now using the MSI extracted earlier you can transform the MSI with the following command line.


msiexec /i "Google Earth Pro.msi" TRANSFORMS=GoogleEarthPro7.0.mst /l*v C:\temp\Logs\GoogleEarthPro7.0.log /qn