Subversion Repositories XServices

Compare Revisions

Ignore whitespace Rev 202 → Rev 203

/xservices/trunk/src/main/webapp/WEB-INF/data/getEventManagerStatus.sql
0,0 → 1,10
select
(select count(*) from MEM_INBOUND) as INBOUND_Queue,
(select count(*) from MEM_OUTBOUND) as OUTBOUND_Queue ,
 
(select count(*) from mem_all_events) as IN_MEMORY_LOG,
(select count(*) from brutex.tbl_events_all) as FILE_LOG,
(select count(*) from brutex.tbl_events_errors) as ERROR_COUNT,
 
((select count(*) from brutex.tbl_events_all where btx_supersed_id is not null) + (select count(*) from mem_all_events where btx_supersed_id is not null)) as MERGED_EVENTS
FROM DUAL;