PROC to list installed software per machine

[G-Oker]

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 (SQL Query : All Systems with specific .exe / version – System Center Configuration Manager (sccmtips...) 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 

[#2 · Accepted solution]

@G-Oker , with plain T-SQL? Impossible.

Use PowerShell script or existing inventory tools like Microsoft MAP

Download Microsoft Assessment and Planning Toolkit from Official Microsoft Download Center

[#3]

That's great. thank you for your help and advise :)