View ESEC.ESECDBA.EVENTS_RPT_V2 | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 04 17:09 EDT 2010 |
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 , EVENTS.CUST_ID as Cust_id , EVENTS.SRC_ASSET_ID as Source_Asset_id , EVENTS.DEST_ASSET_ID as Destination_Asset_id , EVENTS.AGENT_ID as Agent_id , EVENTS.PRTCL_ID as Protocol_id , EVENTS.ARCH_ID as Archive_id , EVENTS.SIP as Source_IP , esec_utl.to_ip_char(EVENTS.SIP) as Source_IP_dotted , EVENTS.SHN as Source_Host_Name , EVENTS.SP as Source_Port , EVENTS.DIP as Destination_IP , esec_utl.to_ip_char(EVENTS.DIP) as Destination_IP_dotted , 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 , 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 , 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, 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 , EVENTS.TXNMY_ID as Taxonomy_id , EVENTS.RID01 as Reference_id_01 , EVENTS.RID02 as Reference_id_02 , EVENTS.RID03 as Reference_id_03 , EVENTS.RID04 as Reference_id_04 , EVENTS.RID05 as Reference_id_05 , EVENTS.RID06 as Reference_id_06 , EVENTS.RID07 as Reference_id_07 , EVENTS.RID08 as Reference_id_08 , EVENTS.RID09 as Reference_id_09 , EVENTS.RID10 as Reference_id_10 , EVENTS.RID11 as Reference_id_11 , EVENTS.RID12 as Reference_id_12 , EVENTS.RID13 as Reference_id_13 , EVENTS.RID14 as Reference_id_14 , EVENTS.RID15 as Reference_id_15 , EVENTS.RID16 as Reference_id_16 , EVENTS.RID17 as Reference_id_17 , EVENTS.RID18 as Reference_id_18 , EVENTS.RID19 as Reference_id_19 , EVENTS.RID20 as Reference_id_20 , 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 |
|