Workflow Name, Session Name, Mapping Name, Start Time, End Time, First Fatal Error Message

Informatica Repo: SQL Sever

select wflow.WORKFLOW_NAME, trun.INSTANCE_NAME, task.MAPPING_NAME, trun.START_TIME, trun.END_TIME, trun.RUN_ERR_MSG
from dbo.OPB_TASK_INST_RUN trun, dbo.OPB_SESS_TASK_LOG task, dbo.OPB_WFLOW_RUN wflow
where trun.RUN_ERR_CODE <> 0
and trun.START_TIME > DATEADD(mi, -60, getdate())
and trun.WORKFLOW_ID = task.WORKFLOW_ID
and trun.WORKFLOW_RUN_ID = task.WORKFLOW_RUN_ID
and trun.INSTANCE_ID = task.INSTANCE_ID
and trun.WORKFLOW_ID = wflow.WORKFLOW_ID
and trun.WORKFLOW_RUN_ID = wflow.WORKFLOW_RUN_ID
order by trun.START_TIME desc