Which Computers have Winfile.exe installed?

SELECT DISTINCT
CS.Name0,
(Case when SF.FileName=’winfile.exe’ then ‘Yes’ else ‘ ‘ end) as ‘WinFile’
FROM
dbo.v_GS_SoftwareFile SF
Right OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON SF.ResourceID = CS.ResourceID
ORDER BY CS.Name0

Leave a Reply

Your email address will not be published. Required fields are marked *