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  

Read More