View ESEC.ESECDBA.EVENTS_RPT_V3 | 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 Target_Service_Port , EVENTS.SP_INT as Init_Service_Port , 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 Init_Asset_id , EVENTS.DEST_ASSET_ID as Target_Asset_id , EVENTS.AGENT_ID as Agent_id , EVENTS.PRTCL_ID as Protocol_id , EVENTS.ARCH_ID as Archive_id , EVENTS.SIP as Init_IP , esec_utl.to_ip_char(EVENTS.SIP) as Init_IP_dotted , EVENTS.SHN as Init_Host_Name , EVENTS.SP as Init_Service_Port_Name , EVENTS.DIP as Target_IP , esec_utl.to_ip_char(EVENTS.DIP) as Target_IP_dotted , EVENTS.DHN as Target_Host_Name , EVENTS.DP as Target_Service_Port_Name , EVENTS.SUN as Init_User_Name , EVENTS.DUN as Target_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 as Event_Metric , EVENTS.RV03 as Data_Tag_Id , 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 as Event_Metric_Class , EVENTS.RV29 as Init_IP_Country , EVENTS.RV30 as Target_IP_Country , EVENTS.RV31, EVENTS.RV33 , EVENTS.RV34 as Init_Threat_Level , EVENTS.RV35 as Init_User_Domain , EVENTS.RV36 , EVENTS.RV37 as Init_Function , EVENTS.RV38 as Init_Operational_Context , EVENTS.RV40 , EVENTS.RV41 as Target_Host_Domain , EVENTS.RV42 as Init_Host_Domain , EVENTS.RV43 , EVENTS.RV44 as Target_Threat_Level , EVENTS.RV45 as Target_User_Domain , EVENTS.RV46 , EVENTS.RV47 as Target_Function , EVENTS.RV48 as Target_Operational_Context , EVENTS.RV49 , EVENTS.TXNMY_ID as Taxonomy_id , EVENTS.RID01 as Reference_id_01 , EVENTS.RID02 as XDAS_Taxonomy_Id , 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 , EVENTS.INIT_USR_SYS_ID as Init_User_Id , EVENTS.INIT_USR_IDENTITY_GUID as Init_User_Identity , EVENTS.TRGT_USR_SYS_ID as Target_User_Id , EVENTS.TRGT_USR_IDENTITY_GUID as Target_User_Identity , EVENTS.EFFECTIVE_USR_NAME as Effective_User_Name , EVENTS.EFFECTIVE_USR_SYS_ID as Effective_User_Id , EVENTS.EFFECTIVE_USR_DOMAIN as Effective_User_Domain , EVENTS.TRGT_TRUST_NAME as Target_Trust_Name , EVENTS.TRGT_TRUST_SYS_ID as Target_Trust_Id , EVENTS.TRGT_TRUST_DOMAIN as Target_Trust_Domain , EVENTS.OBSRVR_IP as Observer_Ip , esec_utl.to_ip_char(EVENTS.OBSRVR_IP) as Observer_Ip_dotted , EVENTS.RPTR_IP as Reporter_Ip , esec_utl.to_ip_char(EVENTS.RPTR_IP) as Reporter_Ip_dotted , EVENTS.OBSRVR_HOST_DOMAIN as Observer_Host_Domain , EVENTS.RPTR_HOST_DOMAIN as Reporter_Host_Domain , EVENTS.OBSRVR_ASSET_ID as Observer_Asset_Id , EVENTS.RPTR_ASSET_ID as Reporter_Asset_Id , EVENTS.INIT_SRVC_COMP as Init_Service_Comp , EVENTS.TARGET_SRVC_COMP as Target_Service_Comp , EVENTS.EVT_GRP_ID as Event_Group_Id , EVENTS.CV101 as Customer_Var_101 , EVENTS.CV102 as Customer_Var_102 , EVENTS.CV103 as Customer_Var_103 , EVENTS.CV104 as Customer_Var_104 , EVENTS.CV105 as Customer_Var_105 , EVENTS.CV106 as Customer_Var_106 , EVENTS.CV107 as Customer_Var_107 , EVENTS.CV108 as Customer_Var_108 , EVENTS.CV109 as Customer_Var_109 , EVENTS.CV110 as Customer_Var_110 , EVENTS.CV111 as Customer_Var_111 , EVENTS.CV112 as Customer_Var_112 , EVENTS.CV113 as Customer_Var_113 , EVENTS.CV114 as Customer_Var_114 , EVENTS.CV115 as Customer_Var_115 , EVENTS.CV116 as Customer_Var_116 , EVENTS.CV117 as Customer_Var_117 , EVENTS.CV118 as Customer_Var_118 , EVENTS.CV119 as Customer_Var_119 , EVENTS.CV120 as Customer_Var_120 , EVENTS.CV121 as Customer_Var_121 , EVENTS.CV122 as Customer_Var_122 , EVENTS.CV123 as Customer_Var_123 , EVENTS.CV124 as Customer_Var_124 , EVENTS.CV125 as Customer_Var_125 , EVENTS.CV126 as Customer_Var_126 , EVENTS.CV127 as Customer_Var_127 , EVENTS.CV128 as Customer_Var_128 , EVENTS.CV129 as Customer_Var_129 , EVENTS.CV130 as Customer_Var_130 , EVENTS.CV131 as Customer_Var_131 , esec_utl.to_ip_char(EVENTS.CV131) as Customer_Var_131_dotted , EVENTS.CV132 as Customer_Var_132 , esec_utl.to_ip_char(EVENTS.CV132) as Customer_Var_132_dotted , EVENTS.CV133 as Customer_Var_133 , esec_utl.to_ip_char(EVENTS.CV133) as Customer_Var_133_dotted , EVENTS.CV134 as Customer_Var_134 , esec_utl.to_ip_char(EVENTS.CV134) as Customer_Var_134_dotted , EVENTS.CV135 as Customer_Var_135 , esec_utl.to_ip_char(EVENTS.CV135) as Customer_Var_135_dotted , EVENTS.CV136 as Customer_Var_136 , esec_utl.to_ip_char(EVENTS.CV136) as Customer_Var_136_dotted , EVENTS.CV137 as Customer_Var_137 , esec_utl.to_ip_char(EVENTS.CV137) as Customer_Var_137_dotted , EVENTS.CV138 as Customer_Var_138 , esec_utl.to_ip_char(EVENTS.CV138) as Customer_Var_138_dotted , EVENTS.CV139 as Customer_Var_139 , esec_utl.to_ip_char(EVENTS.CV139) as Customer_Var_139_dotted , EVENTS.CV140 as Customer_Var_140 , esec_utl.to_ip_char(EVENTS.CV140) as Customer_Var_140_dotted , EVENTS.CV141 as Customer_Var_141 , EVENTS.CV142 as Customer_Var_142 , EVENTS.CV143 as Customer_Var_143 , EVENTS.CV144 as Customer_Var_144 , EVENTS.CV145 as Customer_Var_145 , EVENTS.CV146 as Customer_Var_146 , EVENTS.CV147 as Customer_Var_147 , EVENTS.CV148 as Customer_Var_148 , EVENTS.CV149 as Customer_Var_149 , EVENTS.CV150 as Customer_Var_150 FROM EVENTS |
|