We noted a query using heavy database resources. In our database we could extract the SQL query. We now want to find the WebFocus query causing this. We could not find a scheduled ReportCaster job causing this, so probably it is someone doing an InfoAssist report.

Is there a possibility to search the repository for InfoAssist reports that would match this query, so maybe search for specific filter/where-statement or masterfile or join used?

This message has been edited. Last edited by: Martin vK,

Assuming that IA code reside at the same place as other fex code

SELECT
     T2.PRT_PATH AS 'Location',
     T2.OBJNAME AS 'Object Name',
     'IBFS:' + T2.PRT_PATH + '/' + T2.OBJNAME AS 'Full IBFS path'
  FROM [DBname].dbo.WF_CONTENT_REVS T1
  INNER JOIN [DBname].dbo.WF_REPOSOBJ T2
     ON T1.OBJ_HANDLE = T2.HANDLE
WHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%String To Find%'
ORDER BY 1, 2, 3

Thanks. Works fine.