ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime,

Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Failed' End As Status

From RepIntegrationLog

Where DBName = 'SAP_Blank_Rups' And Flag = 0

Not include failed record:

And isNull(Status, 0) <> 1

And run on CXSINTEGRATION database