Skip to main content

SCCM Collection for computes with Java version 7

We needed to uninstall Java 7 from Machines.For that we created a collection based on product ID instead of Display Name in Add Remove programs.

This collection query will include all machines that have 32-bit or 64-bit Java Installed

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductCode like "{26a24ae4-039d-4ca4-87b4-2f832170%" or SMS_G_System_INSTALLED_SOFTWARE.ProductCode like "{26A24AE4-039D-4CA4-87B4-2F864170%"


We can then uninstall the products using a SCCM

create a package to run this script:

You may need to add more products depending on other versions that you have installed for Java for me we only had java 7  update 3 , 4 7, 9 ,10


strComputer = "."
Set objShell = CreateObject("WScript.Shell")
Set objProducts = CreateObject("Scripting.Dictionary")
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_Product",,48)

For Each objItem in colItems
objProducts.Add objItem.IdentifyingNumber, objItem.Caption
Next

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F83217003FF}") Then
' Uninstall java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F83217003FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F86417003FF}") Then
' Uninstall Java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F86417003FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F83217004FF}") Then
' Uninstall java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F83217004FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F86417004FF}") Then
' Uninstall Java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F86417004FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F83217007FF}") Then
' Uninstall java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F83217007FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F86417007FF}") Then
' Uninstall Java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F86417007FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F83217009FF}") Then
' Uninstall java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F83217009FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F86417009FF}") Then
' Uninstall Java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F86417009FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F83217010FF}") Then
' Uninstall java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F83217103FF} /norestart /qn",1,True
End If

If objProducts.Exists("{26A24AE4-039D-4CA4-87B4-2F86417010FF}") Then
' Uninstall Java
objShell.Run "msiexec /x {26A24AE4-039D-4CA4-87B4-2F86417010FF} /norestart /qn",1,True
End If



If someone wants to uninstall all versions of Java from machines , Please try

http://ivan.dretvic.com/2011/02/who-hates-java-how-to-remove-all-java-installations-on-your-network/

this has a script that can do that.  We only tested this script for 32-bit Java and not 64-bit java. It works well.

Hope this helps

Comments

Popular posts from this blog

Group Policy Object did not apply because it failed with error code '0x80070534 No mapping between account names and security IDs was done

One of our servers was losing the Local Admin settings as we control them using GPO (restricted Groups) We were receiving the following event on this particular server : Event ID 4098 Application Event Log The computer 'Administrators (built-in)' preference item in the 'Servers Local Admins {odjd9DBD-22AF-48EA-ADF5-F42ADE4182hst}' Group Policy Object did not apply because it failed with error code '0x80070534 No mapping between account names and security IDs was done.' This error was suppressed. To fix the issue we deleted all the folders from the following location and rebooted the server C:\ProgramData\Microsoft\Group Policy\History Hope this helps.

iDRAC 7 Shows no Signal in Virtual Console Preview

Recently i logged on to iDRAC for one of our Dell R720 servers,however somehow the console redirection did not work at all. I kept on seeing No Signal on the Virtual console Preview. I tried Rebooting the server but that did not help. Finally i clicked on Reset iDRAC and this did the trick. It may take around 2 -5 minutes before you can access iDRAC page again. I had to power on the server through iDRAC before anything showed up on console. Hope this Helps.

Citrix XenApp 6.5 Discovery fails Event 3989

Citrix XenApp 6.5 Service account password change caused console discovery to fail and we saw event ID 3989 in System Event logs "Citrix XenApp failed to connect to the Data Store. ODBC error while connecting to the database: 28000 -> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." After changing the service account password needed to run the following command on the delivery controllers. DSMAINT CONFIG /user:abc\ABCSVCCitrix /pwd:nP@ssword /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn" Restart IMA service You should now be able to run the discovery successfully Hope this helps