I did created the report and it is not giving anything output. am I supposed to create report right? I asked my packaging team guys to create and they are asking me for the product codes for the versions I have to uninstall. But when I tried to run a report for all the java verisons available, there are many "java" available ...what to run.
________________________________ Bhasker, Chittanoori Plymouth Meetings PA On Wednesday, January 29, 2014 6:17:30 PM, "Miller, Todd" <todd-mil...@uiowa.edu> wrote: Sorry, I thought you were asking for how to find the uninstall string. Here is my report for installed Java versions. SELECT Name0,soft.ProductName0 , soft.ProductVersion0 FROM v_R_System sys JOIN v_GS_INSTALLED_SOFTWARE soft ON sys.ResourceID = soft.ResourceID WHERE (soft.ProductName0 LIKE '%Java(TM)%' OR soft.ProductName0 LIKE 'J2SE%' OR soft.ProductName0 LIKE 'Java 2 Runtime%' OR soft.ProductName0 LIKE 'IBM 32-bit Runtime%') AND sys.Client0 = '1' ORDER BY Name0 From:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Miller, Todd Sent: Wednesday, January 29, 2014 5:10 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2007 Query/Collection for Unnstall java version for below 6.18 I have been successfully using this script to remove Java versions for a couple of years. http://www.mockbox.net/bits-and-pieces/vbs-scripts/282-uninstall-java-using-vbs-script There are a few versions of Java that cannot be removed in a scripted way, but those are discussed in the script. Also, have a look at this resource. It is tremendous. http://wpkg.org/Java From:listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Bhasker Chittanoori Sent: Wednesday, January 29, 2014 1:54 PM To: MSSMS SMS Subject: [mssms] SCCM 2007 Query/Collection for Unnstall java version for below 6.18 I am trying to look for a product code for uninstalling java below 6.18 versions. Does any one know where and how do I get it. I know that from SCCM console -> start -> explore -> installed applications will show the product ID and Product code, but is there any query or collections where I can create with the particular version? management wants to uninstall all the lower versions below 6.18, any help would be appreciated., Bhasker, Chittanoori ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________ ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________