Query to see failed mappings in Informatica BDM

failed_mappings.sql

select 
POR_OBJECTNAME as MAPPING_NAME,
POR_REQUESTTYPE as JOB_TYPE,
DATEADD(SECOND,POR_STARTTIME/1000,'19700101 00:00') AS MAPPING_START_TIME,
POR_MESSAGE as ERROR_MESSAGE,
POR_LOGFILENAME as LOG_FILE,
POR_SERVICENAME as DIS_NAME,
POR_EXECUTINGNODENAME as NODE_NAME
from PO_REQUESTSTAT 
where POR_MESSAGE IS NOT NULL
ORDER BY POR_STARTTIME DESC;