View ESEC.ESECDBA.EVENTS_RPT_V | Generated by SchemaSpy |
View SQL:
SELECT EVENTS.EVT_ID as Event_id , EVENTS.RES as Resource_Name , EVENTS.SRES as Sub_Resource , EVENTS.SEV as Severity , EVENTS.EVT_TIME as Event_parse_Time , EVENTS.EVT_TIME as Event_DateTime , EVENTS.DEVICE_EVT_TIME as Event_Device_Time , EVENTS.SENTINEL_PROCESS_TIME as Sentinel_Process_Time , EVENTS.BEGIN_TIME as Begin_Time , EVENTS.END_TIME as End_Time , EVENTS.REPEAT_CNT as Repeat_Count , EVENTS.DP_INT as Destination_Port_Int , EVENTS.SP_INT as Source_Port_Int , EVENTS.MSG as Base_Message , EVENTS.EVT as Event_Name , EVENTS.ET as Event_Time , EVT_AGENT.SN as Sensor_Name , EVT_AGENT.ST as Sensor_Type , EVT_PRTCL.PRTCL_NAME as Protocol , EVENTS.SIP as Source_IP , EVENTS.SHN as Source_Host_Name , EVENTS.SP as Source_Port , EVENTS.DIP as Destination_IP , EVENTS.DHN as Destination_Host_Name , EVENTS.DP as Destination_Port , EVENTS.SUN as Source_User_Name , EVENTS.DUN as Destination_User_Name , EVENTS.FN as File_Name , EVENTS.EI as Extended_Info , EVT_AGENT.RN as Report_Name , EVT_AGENT.PN as Product_Name , EVENTS.CT1 as Custom_Tag_1 , EVENTS.CT2 as Custom_Tag_2 , EVENTS.CT3 as Custom_Tag_3 , EVENTS.RT1 as Reserved_Tag_1 , EVENTS.RT2 as Reserved_Tag_2 , EVENTS.RT3 as Reserved_Tag_3 , EVT_AGENT.SRC_ID as Source_UUID , EVT_AGENT.PORT as Port , EVT_AGENT.AGENT as Agent , EVENTS.VULN as Vulnerability_Rating , EVENTS.CRIT as Criticality_Rating , EVENTS.DATE_CREATED as Date_Created , EVENTS.DATE_MODIFIED as Date_Modified , EVENTS.CREATED_BY as Created_By , EVENTS.MODIFIED_BY as Modified_By , 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 , CUST.CUST_NAME as RV39 , 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 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 |