View ESEC.ESECDBA.EVENTS_ALL_V | Generated by SchemaSpy |
View SQL:
SELECT EVENTS.EVT_ID, EVENTS.EVT_TIME, CUST.CUST_NAME as RV39, EVENTS.RES, EVENTS.SRES, EVENTS.SEV, EVENTS.ARCH_ID, EVENTS.DEVICE_EVT_TIME, EVENTS.SENTINEL_PROCESS_TIME, EVENTS.BEGIN_TIME, EVENTS.END_TIME, EVENTS.REPEAT_CNT, EVENTS.DP_INT, EVENTS.SP_INT, EVENTS.MSG, EVENTS.EVT, EVENTS.ET, EVT_AGENT.SN, EVT_AGENT.ST, EVT_PRTCL.PRTCL_NAME as PROTOCOL, EVENTS.SIP, EVENTS.SHN, EVENTS.SP, EVENTS.DIP, EVENTS.DHN, EVENTS.DP, EVENTS.SUN, EVENTS.DUN, EVENTS.FN, EVENTS.EI, EVT_AGENT.RN, EVT_AGENT.PN, EVENTS.CT1, EVENTS.CT2, EVENTS.CT3, EVENTS.RT1, EVENTS.RT2, EVENTS.RT3, EVT_AGENT.SRC_ID, EVT_AGENT.PORT, EVT_AGENT.AGENT, EVENTS.VULN, EVENTS.CRIT, EVENTS.RV01, EVENTS.RV02, EVENTS.RV03, EVENTS.RV04, EVENTS.RV05, EVENTS.RV06, EVENTS.RV07, EVENTS.RV08, EVENTS.RV09, EVENTS.RV10, EVENTS.RV11, EVENTS.RV12, EVENTS.RV13, EVENTS.RV14, EVENTS.RV15, EVENTS.RV16, EVENTS.RV17, EVENTS.RV18, EVENTS.RV19, EVENTS.RV20, EVENTS.RV21, EVENTS.RV22, EVENTS.RV23, EVENTS.RV24, EVENTS.RV25, EVENTS.RV26, EVENTS.RV27, EVENTS.RV28, EVENTS.RV29, EVENTS.RV30, EVENTS.RV31, EVT_AGENT.DEVICE_CTGRY as RV32, EVENTS.RV33, EVENTS.RV34, EVENTS.RV35, EVENTS.RV36, EVENTS.RV37, EVENTS.RV38, EVENTS.RV40,EVENTS.RV41, EVENTS.RV42, EVENTS.RV43, EVENTS.RV44, EVENTS.RV45, EVENTS.RV46, EVENTS.RV47, EVENTS.RV48, EVENTS.RV49, EVT_TXNMY.TXNMY_LVL_1 as RV50, EVT_TXNMY.TXNMY_LVL_2 as RV51, EVT_TXNMY.TXNMY_LVL_3 as RV52, EVT_TXNMY.TXNMY_LVL_4 as RV53, EVENTS.CV01, EVENTS.CV02, EVENTS.CV03, EVENTS.CV04, EVENTS.CV05, EVENTS.CV06, EVENTS.CV07, EVENTS.CV08, EVENTS.CV09, EVENTS.CV10, EVENTS.CV11, EVENTS.CV12, EVENTS.CV13, EVENTS.CV14, EVENTS.CV15, EVENTS.CV16, EVENTS.CV17, EVENTS.CV18, EVENTS.CV19, EVENTS.CV20, EVENTS.CV21, EVENTS.CV22, EVENTS.CV23, EVENTS.CV24, EVENTS.CV25, EVENTS.CV26, EVENTS.CV27, EVENTS.CV28, EVENTS.CV29, EVENTS.CV30, EVENTS.CV31, EVENTS.CV32, EVENTS.CV33, EVENTS.CV34, EVENTS.CV35, EVENTS.CV36, EVENTS.CV37, EVENTS.CV38, EVENTS.CV39, EVENTS.CV40, EVENTS.CV41, EVENTS.CV42, EVENTS.CV43, EVENTS.CV44, EVENTS.CV45, EVENTS.CV46, EVENTS.CV47, EVENTS.CV48, EVENTS.CV49, EVENTS.CV50, EVENTS.CV51, EVENTS.CV52, EVENTS.CV53, EVENTS.CV54, EVENTS.CV55, EVENTS.CV56, EVENTS.CV57, EVENTS.CV58, EVENTS.CV59, EVENTS.CV60, EVENTS.CV61, EVENTS.CV62, EVENTS.CV63, EVENTS.CV64, EVENTS.CV65, EVENTS.CV66, EVENTS.CV67, EVENTS.CV68, EVENTS.CV69, EVENTS.CV70, EVENTS.CV71, EVENTS.CV72, EVENTS.CV73, EVENTS.CV74, EVENTS.CV75, EVENTS.CV76, EVENTS.CV77, EVENTS.CV78, EVENTS.CV79, EVENTS.CV80, EVENTS.CV81, EVENTS.CV82, EVENTS.CV83, EVENTS.CV84, EVENTS.CV85, EVENTS.CV86, EVENTS.CV87, EVENTS.CV88, EVENTS.CV89, EVENTS.CV90, EVENTS.CV91, EVENTS.CV92, EVENTS.CV93, EVENTS.CV94, EVENTS.CV95, EVENTS.CV96, EVENTS.CV97, EVENTS.CV98, EVENTS.CV99, EVENTS.CV100, EVENTS.DATE_CREATED, EVENTS.DATE_MODIFIED, EVENTS.CREATED_BY, EVENTS.MODIFIED_BY FROM EVENTS, CUST, EVT_AGENT, EVT_PRTCL, EVT_TXNMY WHERE EVENTS.CUST_ID = CUST.CUST_ID AND EVENTS.AGENT_ID = EVT_AGENT.AGENT_ID AND EVENTS.PRTCL_ID = EVT_PRTCL.PRTCL_ID AND EVENTS.TXNMY_ID = EVT_TXNMY.TXNMY_ID |