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

Comments

Please log in to comment

Answers

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

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.

Answered 05/01/2013 by: rileyz
Red Belt

Please log in to comment
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

Answered 05/01/2013 by: J.M.
Orange Belt

  • 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.
Please log in to comment
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

Answered 05/01/2013 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity