I have previously blogged about creating a User Defined Metric (UDM) before (7 years ago!) but the method I am using today demonstrates how you can test out the alert using specific data.
The aim was to see if integration data is flowing through a table. If there is a backlog we want to know about it.
Simon Ryan, a colleague did all the preparatory work and created all the 18 !! screen shots which I had to copy and paste into this entry
select * from sm7.EVENTOUTM1; -- Transient table so data not usually present.
The data is processed quickly but occasionally you can see a handful of rows for a few seconds.
select DESCRIPTOR ,
EVTYPE ,
TO_CHAR(EVTIME, 'DD-MON-YYYY HH24:MI:SS') ,
EVSYSSEQ ,
EVUSRSEQ from sm7.EVENTOUTM1;
DESCRIPTOR EVTYPE EVTIME EVSYSSEQ EVUSRSEQ
(BLOB) email 08-NOV-2017 11:40:01 0000000005254328
A typical query for the ME would be very simple:
select count(*) from sm7.EVENTOUTM1;
However, we are going to plugin a ‘control’ table in order for us to test the alert by artificially adjusting the results. Read the rest of this entry »