I’m looking to generate a report that displays the version of Java on each device. I found this information in “Installed Applications - Windows”. When I pull the information in Web Reports, it puts all the installed apps in one field. I can expand it to look at it but I can’t figure out how to split the data so I can report on just Java.
and it indicates that you can do it using Explore Data in web reports 8.1. I’m running 8.2.1093 and for the life of me I can’t figure out how to do this using Explore Data. Is there any documentation on this?
Once you’ve added the “Installed Applications - Windows” column in Explore Computers, you’ll see a “+” next to the column in the “current columns” box. Clicking on that puts every returned installed application on a new row. You can then use the filter to restrict “Installed Applications - Windows” results to ones that contain “Java”. This should give you the version of Java on every computer (that actually has Java installed).
Thanks for the response, I tried that, However it did not give me quite what I was looking for. The filter gave me not just the line identifying the Java application in the “Installed Applications - Windows” property but ALL the applications for devices that match the filter (see attached).
Exporting the data to csv puts all the applications in a single field which makes it difficult to report on just a single application.
Maybe I’m missing something. Is this what you see?
Sorry for the delayed response. I can’t seem to figure out subscribing to threads. I have no doubt Lee Wei’s report solves your problems (they tend to do that), but I think you may be able to use the native capabilities if I just explain them better. I can get web reports me to only show one application per row. The key here is using the “Edit Columns” pulldown to “split” the data in “Installed Applications-Windows”. That is what the “+” symbol is there for. If you split the row, each value reported back through that property gets its own row. Then the Java filter you showed would do what I believe you want it to do. I’ve attached 1 screenshots that has a crude highlight of the +/- button I’m talking about. Frustratingly, I can only attach one image, so I’ll attach the result in a subsequent post instead of doing the smart thing and zipping up the images.
Yes, this is precisely what I was looking for. I don’t know why I’ve never seen that [+] mark before, but I appreciate you taking the time to point it out to me.
This report provides the information I was looking for. However I was hoping to have it in the context of the web reports so that I could easily incorporate other date if necessary and use the export to csv function. This should suffice, if I need additional fields, we will need to enrich the data afterwards or modify the relevance accordingly.