Skip to main content

Posts

Showing posts from February, 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&

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 = 'SKU

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 http://search.dell.com/results.aspx?s=gen&c=us&l=en&cs=&k=331-9318&cat=all&x=11&y=4

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 http://search.dell.com/results.aspx?s=gen&c=us&l=en&cs=&k=331-9318&cat=all&x=11&y=4

Google Earth Pro Repackaged for SCCM with license key

Tags: install google earth pro with license key Google Earth Pro can be downloaded here http://www.google.com/earth/download/gep/agree.html 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 wh

Google Earth Pro Repackaged for SCCM with license key

Tags: install google earth pro with license key Google Earth Pro can be downloaded here http://www.google.com/earth/download/gep/agree.html 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 cli