SCCM Query for identifying Software based on Executables
This SQL query can be used to search for installed software based on their executables
SELECT VRS.Name0 as 'Computer Name',
VRS.User_Name0 as 'User Name',
SF.FileName as 'File Name',
SF.FileDescription as 'File Description',
SF.FilePath as 'File Path',
SF.ModifiedDate as 'Modified Date'
FROM v_R_System VRS,v_GS_SoftwareFile SF
WHERE SF.ResourceID = VRS.ResourceId
AND SF.FileDescription = 'Google Talk'
ORDER BY VRS.Name0
