We noticed that the customer was trying to return the following on his raw sql query: select distinct vc.[name], vc.[user], fd.[Name] as 'File Name', wf.[productversion], fd.[path]
Filters only allow to return GUIDs since our code will then grab what the filters need and displayed them in the grid from the returned GUIDs. After we added the proper return column, the issue was resolved.
After we added the proper return column, the issue was resolved. This was the final query:
select distinct vc.GUID from vcomputer vc join dbo.inv_installed_file_details fd on fd._resourceguid=vc.Guid JOIN dbo.Inv_Windows_File wf ON wf.[_ResourceGuid] = FD.[FileResourceGuid] where fd.[Name] like 'iexplore.exe' and wf.[ProductVersion] like '10%' and [Path] not like 'C:\Windows%' and [Path] like 'C:\Program Files\Internet Explorer'
Subscribing will provide email updates when this Article is updated. Login is required.