Schema Application - Failed File Names

[Thriller]

We need to create analytics that displays the file name with a status as failure for Schema applications in Saviynt when we run the SchemaAccountJob. How do we get the data? 

[rushikeshvartak · Accepted solution]

SELECT jobname,
       jobstartdate,
       jobenddate,
       savresponse,
       i.filename
FROM   ecmimportjob e,
       importlog i
WHERE  jobname = 'SchemaAccountJob'
       AND i.jobid = e.jobid 

[Thriller]

Thank you, @rushikeshvartak 
Actually, we have a SFTP Download job (file transfer job) that pulls 50 files from SFTP location. The job is erroring out now with "file not found" error without specifying which file was not found. Is there a way to query which files were not found on SFTP location?

[rushikeshvartak]

Its data issue. if its printing in saviynt logs then you can capture.