{"eventType":"delete","ServerSerial":"1142691750","ServerName":"COL_P_1","deletedat":"2018-08-24 15:30:48.136"} --> ONLY DELETEDAT COLUMN HAS TO BE UPDATED ON SREVERSERIAL+SERVERNAME(COMPOSITE PRIMARY KEY)
{"eventType":"delete","ServerSerial":"0","ServerName":"","deletedat":"2018-08-24 15:30:48.136"} ---------->>>> INVALID DATA NEEDS TO DISCARDED
{"eventType":"insert","Identifier":"10.255.98.12 trapSeverityEntry: normal heartBeat 1 Open-i-MIB","Node":"10.255.98.12","NodeAlias":"GNBYWI06H00IM01","Manager":"MTTrapd Probe on ltrkarkvm129.dsys.windstream.net","Agent":"Open-i-MIB","AlertGroup":"heartBeat","AlertKey":"trapSeverityEntry: normal","Severity":"0","Summary":"heartBeat: HB Interval: 30 minutes, Net Interface: Ethernet (Primary)","StateChange":"2018-08-24 15:50:05.000","FirstOccurrence":"2018-08-24 15:48:54.000","LastOccurrence":"2018-08-24 15:48:54.000","InternalLast":"2018-08-24 15:50:05.000","Poll":"0","Type":"2","Tally":"1","ProbeSubSecondId":"101","Class":"90070","Grade":"0","Location":"","OwnerUID":"65534","OwnerGID":"0","Acknowledged":"0","Flash":"0","EventId":"","ExpireTime":"0","ProcessReq":"0","SuppressEscl":"0","Customer":"","Service":"","PhysicalSlot":"0","PhysicalPort":"0","PhysicalCard":"0","TaskList":"0","NmosSerial":"","NmosObjInst":"0","NmosCauseType":"0","NmosDomainName":"","NmosEntityId":"0","NmosManagedStatus":"0","NmosEventMap":"","LocalNodeAlias":"10.255.98.12","LocalPriObj":"","LocalSecObj":"","LocalRootObj":"","RemoteNodeAlias":"","RemotePriObj":"","RemoteSecObj":"","RemoteRootObj":"","X733EventType":"0","X733ProbableCause":"0","X733SpecificProb":"","X733CorrNotif":"","URL":"","ExtendedAttr":"","CollectionFirst":"2018-08-24 15:48:54.000","OldObjectStatus":"0","OldClass":"0","FRASM_misc":"0","AIS_OAM_Status":"","NEFWVersion":"","NEModelID":"","NetworkName":"NuVox","LNNI":"0","RNNI":"0","SVVersion":"","ClarifyFlag":"0","TicketNumber":"","Tier_Level":"2","ClarifyTicket":"0","ClarifyTicket2":"","ClarifyData1":"","ClarifyData2":"","ClarifyData3":"","ClarifyData4":"","ClarifyData5":"","ClarifyData6":"","ClarifyData7":"","ClarifyData8":"","ClarifyData9":"","ClarifyData10":"","MiscData1":".1.3.6.1.4.1.1824.1","MiscData2":"specific-trap:32","MiscData3":"","MiscData4":"","MiscData5":"","MiscData6":"","MiscData7":"","MiscData8":"","MiscData9":"ltrkarkvm129","MiscData10":"","NEName":"","Suppress":"0","MPLSType":"0","OrigAckBy":"","OrigAckTime":"1969-12-31 18:00:00.000","service_type_original":"voice","service_type":"voice","received":"2018-08-24 15:48:55.000","receivedcheck":"1","AckBy":"","exittime":"1969-12-31 18:00:00.000","cleared":"0","clearedby":"","AckTime":"1969-12-31 18:00:00.000","Region":"WI","State":"WI","AckByFullName":"","AdditionalInfo":"IMCI","AdminDomain":"","AdvCorrCauseType":"0","AdvCorrServerName":"","AdvCorrServerSerial":"0","APLastUpdated":"1969-12-31 18:00:00.000","APResponder":"","APState":"0","APTarget":"","BitMapField":"","BSM_Identity":"","CauseType":"0","CircuitData":"","Contact":"","Convert":"","CorrScore":"0","Customernumber":"","DACSAssignment":"","DACSCLLI":"","DACSMFG":"","DACSMFGPART":"","discardtag":"0","DNOC_Class":"","DNOC_Discards":"","DSAP":"","emailalm":"0","emailed":"0","EmpID":"","Enviromental":"","Equipment":"","FirstName":"","FullData":"","Impact_display":"","Impact_processed":"","Impact_server":"","ITK_Group":"","LastName":"","LECCircuitID":"","LocalObjRelate":"0","LocalTertObj":"","LSAP":"","manual_clear_required":"0","ncAction":"","NEAddress":"","NEN":"","NENMFG":"","NEType":"0","NSCCircuitID":"","nxAction":"","nxAlertKey":"","nxCount":"0","nxGate":"0","nxOper":"","nxSystem":"","ObjectStatus":"0","ObjectType":"","OldRow":"0","OrigAckByFullName":"","OVO_EventFlag":"","ovo_object":"","phonenumber":"","PSAP":"","Reference":"","Remedy_Ticket":"","RemoteDSAP":"","RemoteLSAP":"","RemoteNEName":"","RemoteObjRelate":"0","RemotePSAP":"","RemoteSlot":"","RemoteTertObj":"","ServiceIdentifier":"","ServiceType":"","Site":"","Slot":"","SubObjectType":"","SuppressEsc":"0","TDAX_Test":"","Tier_Level_Original":"1","Tierlock":"0","TrapReason":"","Vendor":"","windstreamcode":"","WS_Node":"ugev1 NodeAlias:GNBYWI06H00IM01","ws_node_conf":"0","InterfaceName":"","InterfaceDescription":"","Probe_Tag":"LTRK129P_MTTRAPD_000000","Service_Tag":"","Process_Tag":"","Management_Tag":"WIND","Resolve_Tag":"","Role_Tag":"","InterfaceIndex":"","XinY":"","NumXinY":"0","XEvents":"0","YSeconds":"0","Line_Code":"","KafkaMapSource":"AlertsStatus","DeviceRole":"","Service_Level":"","Duration":"0","ServerName":"COL_P_1","ServerSerial":"1143187261"},
{"eventType":"update","Identifier":"66.248.100.2 Slot: 7, Unit: 23, Channel: 23 CSM-PRI 13 Cisco-IOS ( CSM ) add PRI","Node":"66.248.100.2","NodeAlias":"WTR01.CHCG25-IL","Manager":"MTTrapd Probe mttrapd_oh on ltrkarkvm130.dsys.windstream.net","Agent":"Cisco-IOS ( CSM )","AlertGroup":"CSM-PRI","AlertKey":"Slot: 7, Unit: 23, Channel: 23","Severity":"2","Summary":"add PRI at slot 7, unit 23, channel 23 with index 27","StateChange":"2018-08-24 10:50:44.000","FirstOccurrence":"2018-08-24 09:52:57.000","LastOccurrence":"2018-08-24 09:52:57.000","InternalLast":"2018-08-24 10:50:44.000","Poll":"0","Type":"13","Tally":"1","ProbeSubSecondId":"12","Class":"95400","Grade":"0","Location":"","OwnerUID":"65534","OwnerGID":"0","Acknowledged":"0","Flash":"0","EventId":"SYSLOG-cisco-ios-CSM-PRI","ExpireTime":"0","ProcessReq":"0","SuppressEscl":"0","Customer":"","Service":"","PhysicalSlot":"0","PhysicalPort":"0","PhysicalCard":"0","TaskList":"0","NmosSerial":"","NmosObjInst":"0","NmosCauseType":"0","NmosDomainName":"","NmosEntityId":"0","NmosManagedStatus":"0","NmosEventMap":"","LocalNodeAlias":"66.248.100.2","LocalPriObj":"Slot: 7","LocalSecObj":"","LocalRootObj":"Slot: 7","RemoteNodeAlias":"","RemotePriObj":"","RemoteSecObj":"","RemoteRootObj":"","X733EventType":"0","X733ProbableCause":"0","X733SpecificProb":"","X733CorrNotif":"","URL":"","ExtendedAttr":"discardReason=\"\"","CollectionFirst":"2018-08-24 09:53:15.000","OldObjectStatus":"0","OldClass":"0","FRASM_misc":"0","AIS_OAM_Status":"","NEFWVersion":"","NEModelID":"","NetworkName":"Starnet","LNNI":"0","RNNI":"0","SVVersion":"","ClarifyFlag":"0","TicketNumber":"","Tier_Level":"2","ClarifyTicket":"0","ClarifyTicket2":"","ClarifyData1":"","ClarifyData2":"","ClarifyData3":"","ClarifyData4":"","ClarifyData5":"","ClarifyData6":"","ClarifyData7":"","ClarifyData8":"","ClarifyData9":"","ClarifyData10":"","MiscData1":".1.3.6.1.4.1.9.9.41.2","MiscData2":"specific-trap:1","MiscData3":"","MiscData4":"","MiscData5":"","MiscData6":"","MiscData7":"","MiscData8":"","MiscData9":"ltrkarkvm130","MiscData10":"","NEName":"","Suppress":"0","MPLSType":"0","OrigAckBy":"","OrigAckTime":"1969-12-31 18:00:00.000","service_type_original":"data","service_type":"data","received":"2018-08-24 09:53:15.000","receivedcheck":"1","AckBy":"","exittime":"1969-12-31 18:00:00.000","cleared":"0","clearedby":"","AckTime":"1969-12-31 18:00:00.000","Region":"IL","State":"IL","AckByFullName":"","AdditionalInfo":"Cisco AS5400XM","AdminDomain":"","AdvCorrCauseType":"0","AdvCorrServerName":"","AdvCorrServerSerial":"0","APLastUpdated":"1969-12-31 18:00:00.000","APResponder":"","APState":"0","APTarget":"","BitMapField":"","BSM_Identity":"","CauseType":"0","CircuitData":"","Contact":"","Convert":"","CorrScore":"0","Customernumber":"","DACSAssignment":"","DACSCLLI":"","DACSMFG":"","DACSMFGPART":"","discardtag":"0","DNOC_Class":"","DNOC_Discards":"","DSAP":"","emailalm":"0","emailed":"0","EmpID":"","Enviromental":"","Equipment":"","FirstName":"","FullData":"","Impact_display":"","Impact_processed":"","Impact_server":"","ITK_Group":"","LastName":"","LECCircuitID":"","LocalObjRelate":"1","LocalTertObj":"","LSAP":"","manual_clear_required":"0","ncAction":"","NEAddress":"","NEN":"","NENMFG":"","NEType":"0","NSCCircuitID":"","nxAction":"","nxAlertKey":"","nxCount":"0","nxGate":"0","nxOper":"","nxSystem":"","ObjectStatus":"0","ObjectType":"","OldRow":"0","OrigAckByFullName":"","OVO_EventFlag":"","ovo_object":"","phonenumber":"","PSAP":"","Reference":"","Remedy_Ticket":"","RemoteDSAP":"","RemoteLSAP":"","RemoteNEName":"","RemoteObjRelate":"0","RemotePSAP":"","RemoteSlot":"","RemoteTertObj":"","ServiceIdentifier":"","ServiceType":"","Site":"","Slot":"","SubObjectType":"","SuppressEsc":"0","TDAX_Test":"","Tier_Level_Original":"0","Tierlock":"0","TrapReason":"","Vendor":"","windstreamcode":"","WS_Node":"ux3lbh7t NodeAlias:","ws_node_conf":"0","InterfaceName":"","InterfaceDescription":"","Probe_Tag":"LTRK130P_MTTRAPD_2_OH_0","Service_Tag":"","Process_Tag":"","Management_Tag":"WIND","Resolve_Tag":"","Role_Tag":"WTR","InterfaceIndex":"","XinY":"","NumXinY":"0","XEvents":"0","YSeconds":"0","Line_Code":"","KafkaMapSource":"AlertsStatus","DeviceRole":"","Service_Level":"","Duration":"0","ServerName":"COL_P_1","ServerSerial":"1142692320"}