I forget the origins of this, but posting since it's extremely useful...
You can do an Advanced Computer Search on Applications to list all of the different versions of an application installed on managed Macs, but as of this writing there is no mechanism to export that report.
You can do an Advanced Computer Search on Computers with Application Title and Application Version criteria, but that just selects the computers that match the criteria and doesn't list the version numbers in the report.
Here's the ProTip...
If you create a Smart Computer Group with an Application Title criteria and Operator "is" clicking View will show you a report of all Macs with that application, but notice there is no version information displayed. However, if you click Export (it doesn't matter if you select Comma-Seperated Values or XML) the exported report includes an Application Version field.
Hey, Another way which may be beneficial is creating a custom Extension attribute (Via a script) which will specifically look for the version number of the app on a machine
(within the info.plist for example plutil -p /Applications/Keynote.app/Contents/Info.plist | grep CFBundleShortVersionString)
then when you generate a report, you can output the string from the EA.
(…) You can do an Advanced Computer Search on Applications to list all of the different versions of an application installed on managed Macs, but as of this writing there is no mechanism to export that report. (…)
Actually there is and has been since Casper days. Just change the Inventory Item to Applications when you export a csv. If you're after the entire list from your fleet, just perform an empty search or an advanced one without criteria for this. The first will get you app names, versions, computer names + whatever you have set in Inventory Display. The second will obviously let you tailor Display options to your needs.
@bartlomiejsojka The issue I have with the report generated when using Applications as the Inventory item for export is that each version number only appears once in the row for the first computer with that version installed. For the data to be useful as a sortable report you'd have to run another script to massage the data and fill in the missing version number field for each computer in the report with a blank entry. Exporting the Smart Computer Group provides the version info for every computer in the report.
I agree the format of that report is a bit problematic, but in that case I would say you'd probably have to rephrase the problem you've solved with that tip.
Still a great tip, especially since you can specify more titles with subsequent „or Application Title” criteria. Again, I would add that with Inventory Display options you can also add additional columns to such report, although it's far from perfect.
As for those empty fields in global App report, here's another „pro tip”: