/build/static/layout/Breadcrumb_cap_w.png

disecting Java's version naming convention

I had a link that provided me with a naming convention to java products. Doing a search/query via sccm it returned file VERSIONs with 5.090.3, 6.0.10.6, 10.17.2.02. etc.  I am trying to leval set my environment to 7u17 and have hit 90+ % but I know I missed a few. we are uninstalling ALL versions regardless and putting a patch in place process.

What I really need and its another question, is a report that will tell me which units do not have 7U17 :-)


0 Comments   [ + ] Show comments

Answers (3)

Posted by: rileyz 11 years ago
Red Belt
0

Gahh, that kinda is a complicated report, you need to two reports/views (whatever you call em) and join them effectively, I know what needs to be done, sadly my SQL sucks now.

An easier way would be to use the below report (this is a mod of "Computers with specific software registered in Add Remove Programs" to resolve it freaking out about weird chars. Dont forget to make the prompts, and upload it to your SRSS server.


Or you could just change @SoftwareTitle to %JAVA% and @CollID to your win7 collection ID. Might need quotes around the %Java% bit if using direct text and not the prompt.

This will list all PC's with %JAVA% in the Add/Remove programs with version, % being a wild card.
Export the list to CSV, list by version in excel, taadaaa - theres your list.

Select sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0 , Version0, InstallDate0
FROM v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 LIKE @SoftwareTitle and fcm.CollectionID=@CollID

 

Not pretty I know, but better than spending 2/3 of a day trying to work how to do the report.

Posted by: J.M. 11 years ago
Orange Belt
0

That might work... I am now looking into how it is you import a .rdl file or as you suggest upload yours to me SRSS server.  Totally new to SCCM jm


Comments:
  • Whoa, you dont need to import. Have a look in the Reporting/Reports node in the SCCM console. There will be a canned report called "Computers with specific software registered in Add Remove Programs", clone that report and make the changes as mentioned above. Once that is done, right click on the Reporting Services, right hand pane, select the SRSS server, right click and "copy reports.. .." to SRSS server.
    This is on SCCM 2007. - rileyz 11 years ago
Posted by: SMal.tmcc 11 years ago
Red Belt
0

You can do a wmic query batch file on your machines and return the results to a file also

WMIC /node:computername product where "name like 'Java 5%%' or name like 'Java 6%%' or name like 'Java 7%%' and name != 'Java 7 Update 17'" get name, version

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ