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 :-)
Answers (3)
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.
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