SQL Query : All Systems with specific .exe / version

This query returns all machines with a particular *.exe file installed.  You can also specify the particular version you are looking for.

SELECT Distinct
    v_R_System.Name0,
    v_GS_SoftwareFile.FileName,
    v_GS_SoftwareFile.FileDescription,
    v_GS_SoftwareFile.FileVersion
From v_R_System
    Join v_GS_SoftwareFile on v_R_System.ResourceID = v_GS_SoftwareFile.ResourceID
Where FileName = 'acrord32.exe' and fileversion = '11.0.17.9'

Sample Output

 

Related posts

Leave a Comment