I want to search for the installed apps and their versions for OSX platform. Want to display results in table form showing AppName, AppVersion, and count of systems with that AppVersion. From this result table, when I click on the count of systems with that AppVersion, I want it to display in table form the list of systems that has this version removing all system name duplicates. Also need to do the same search criteria for the Windows platform as well.
Do you know which logs contains this information ?
The method could be, create a search to find those events and extract the field: app, version
then format the result with | stats latest(version) AS version by app host