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 MoreWednesday, October 28, 2020
