SQL Queries - CAST Knowledge Base - Queries on jobs - How to get the names of jobs which analyzes a given file

Applicable in CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x
7.3.x
7.2.x
7.0.x

To get the name(s) of job(s) which analyses any file, execute the following query on the KB:

SELECT DISTINCT Job.keynam as Job_Name, 
                obj.keynam as Object_Name 
FROM   objpro 
       JOIN keys Job 
         ON job.idkey = idpro 
       JOIN keys Obj 
         ON idobj = Obj.idkey 
            AND lower(Obj.keynam) LIKE lower('%file_name%')

Example if you want to know the name of the job which analyses the file "FRAMESPECLIST.CC", the query will be:

SELECT DISTINCT Job.keynam as Job_Name, 
                obj.keynam as Object_Name 
FROM   objpro 
       JOIN keys Job 
         ON job.idkey = idpro 
       JOIN keys Obj 
         ON idobj = Obj.idkey 
            AND lower(Obj.keynam) LIKE lower('%accessdatabaseemp.java%')