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
Next
Labels:
Compliance,
DCM,
enterprise,
microsoft,
SCCM,
SJUNAME,
SQL,
WMI
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
http://search.dell.com/results.aspx?s=gen&c=us&l=en&cs=&k=331-9318&cat=all&x=11&y=4
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-9318http://search.dell.com/results.aspx?s=gen&c=us&l=en&cs=&k=331-9318&cat=all&x=11&y=4
Wednesday, February 13, 2013
Google Earth Pro Repackaged for SCCM with license key
Tags: install google earth pro with license key
(Please be careful when modifying the registry, i accept no responsibility)
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”.
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:
[HKEY_LOCAL_MACHINE\SOFTWARE\Google\Google Earth Pro]
"AData"=hex:
"HideUserData"=dword:00000001
"Passport"="Insert Password"
"Username"="Insert Username"
"DisableDeactivation"=dword:00000001
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
Subscribe to:
Posts (Atom)