SQL
SELECT BATCH_NO
, USER_NAME
, JOB_RUN_ID
, IS_CURRENT
, BATCH_DATE
, LAST_NAME
, FIRST_NAME
, EMAIL_ADDRESS
, PROCESSING_STATUS
, PROCESSING_MESSAGE
FROM Z_REGO_COGNITO_SYNC
WHERE IS_CURRENT = 1
AND PROCESSING_STATUS != 'SUCCESS'
SQL
SELECT BATCH_NO
, USER_NAME
, JOB_RUN_ID
, IS_CURRENT
, BATCH_DATE
, LAST_NAME
, FIRST_NAME
, EMAIL_ADDRESS
, PROCESSING_STATUS
, PROCESSING_MESSAGE
FROM Z_REGO_COGNITO_SYNC
WHERE IS_CURRENT = 1
AND PROCESSING_STATUS != 'SUCCESS'