PROC to list installed software per machine

Hello, 

I'm relatively new to sql queries, so I don't know if this is possible.

Is there a query that will look at the local machines' installed programs and list the Install version of a program?

I am trying to create one that will look for a specific installed application  , and return the Version number. I have found this (https://sccmtips.co.uk/sql-query-all-systems-with-specific-exe-version) but this is for System centre and not Management studio,.

I need a way of doing it in management studio so I can do a compare on the value returned, and perform a task accordingly.

Thank you in advance