top of page
Search
  • ABS

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


1 view0 comments

Recent Posts

See All

iVend Cloud Hosted - MC SSO login

Enable Cloud Hosting: C:\Program Files (x86)\CitiXsys\iVend Retail\ManagementConsole\CXSManagementConsole.xml >> <CloudHosting>True</CloudHosting> Add new windows user to SQL authentication (sysadmin)

Post: Blog2_Post
bottom of page