Live Discover Query to see the versions of any software installed on macOS

Hi Jairo,

You can run the below query and get the desired details of the installed app in macOS.

SELECT 
   name,
   path,
   bundle_executable,
   bundle_identifier,
   bundle_name,
   bundle_short_version,
   bundle_version,
   display_name
FROM
   apps
   

SELECT
   friendly_name,
   interface,
   address,
   mask,
   broadcast,
   point_to_point,
   type
FROM 
    interface_addresses
WHERE 
    address LIKE '%.%.%.%' 
AND address <> '127.0.0.1'

Hi RaviSoni,

Thank you very much for the quick answer.

Query and if I wanted to validate the specific version of some software, how could the query be structured?

I tried it this way with the Google Chrome example:

SELECT
        name,
        path,
        bundle_executable,
        bundle_short_version
FROM
       apps
WHERE
       bundle_executable LIKE 'Google Chrome'

I don't know if it's the right way to do it.

Thanks.

Hi RaviSoni,
Thank you very much for the quick answer.

Really thank you very much for the help, this is excellent was what I was looking for.

Thanks

You can search for any program with this query.

You can search for any program with this query.

Hi RaviSoni,
Thank you very much for the quick answer.

Really thank you very much for the help, this is excellent was what I was looking for.

Thanks