12.01.2015, 00:01:24, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B300C4',1421017284,1421017284,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 00:01:24, UPDATE alarm_data SET msg='W 120',dispmsg1='NORMAL W 120',dispmsg2='NORMAL W 120',tstamp=1421017284 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4'
12.01.2015, 00:01:25, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421017284 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4'
12.01.2015, 00:01:25, UPDATE alarm_status SET reference='54B300C4',tstamp=1421017284,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 00:01:25, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B300C4',0,1,1421017285,0,0,8000,12,'54B300C4',1421017285,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
12.01.2015, 00:01:27, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B300C4',1,1,1421017287,0,0,8000,12,'54B300C4',1421017287,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
12.01.2015, 00:01:35, UPDATE execute_data SET tstamp=1421017295,exectime=1421017285,answertime=1421017295,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 00:01:35, UPDATE execute_data SET tstamp=1421017295,exectime=1421017287,answertime=1421017295,endcalltime=1421017295,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 00:01:37, UPDATE execute_data SET tstamp=1421017296,exectime=1421017285,answertime=1421017295,endcalltime=1421017296,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 00:01:49, UPDATE alarm_data SET tstamp=1421017309,alrstatus=2,endtime=1421017309,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B300C4'
12.01.2015, 00:01:50, UPDATE alarm_status SET reference='54B300C4',tstamp='1421017309',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 00:02:24, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B30100',1421017344,1421017344,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 00:02:24, UPDATE alarm_data SET msg='W 120',dispmsg1='NORMAL W 120',dispmsg2='NORMAL W 120',tstamp=1421017344 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100'
12.01.2015, 00:02:25, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421017344 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100'
12.01.2015, 00:02:25, UPDATE alarm_status SET reference='54B30100',tstamp=1421017344,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 00:02:25, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B30100',0,1,1421017345,0,0,8000,12,'54B30100',1421017345,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
12.01.2015, 00:02:27, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B30100',1,1,1421017346,0,0,8000,12,'54B30100',1421017346,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
12.01.2015, 00:02:27, UPDATE execute_data SET tstamp=1421017347,exectime=1421017345,answertime=1421017347,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 00:02:27, UPDATE execute_data SET tstamp=1421017347,exectime=1421017345,answertime=1421017347,endcalltime=1421017347,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 00:02:27, UPDATE execute_data SET tstamp=1421017347,exectime=1421017346,answertime=1421017347,endcalltime=1421017347,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 00:02:45, UPDATE alarm_data SET tstamp=1421017365,alrstatus=2,endtime=1421017365,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B30100'
12.01.2015, 00:02:45, UPDATE alarm_status SET reference='54B30100',tstamp='1421017365',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
12.01.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1360116000  Code:0
12.01.2015, 03:00:01, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1360116000  Code:0
12.01.2015, 03:00:01, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1360116001  Code:0
12.01.2015, 03:00:35, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1360116001  Code:0
12.01.2015, 03:00:35, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1360116035  Code:0
12.01.2015, 03:00:35, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1360116035  Code:0
12.01.2015, 03:00:36, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1415952035  Code:0
12.01.2015, 03:00:36, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1415952036  Code:0
12.01.2015, 03:00:36, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1415952036  Code:0
12.01.2015, 03:00:36, Delete records from event database nv_event which are older then 720 days
12.01.2015, 07:47:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B36DE7',1421045223,1421045223,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 07:47:03, UPDATE alarm_data SET msg='W 132',dispmsg1='NORMAL W 132',dispmsg2='NORMAL W 132',tstamp=1421045223 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7'
12.01.2015, 07:47:04, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421045223 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7'
12.01.2015, 07:47:04, UPDATE alarm_status SET reference='54B36DE7',tstamp=1421045223,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 07:47:05, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B36DE7',0,1,1421045225,0,0,8000,10,'54B36DE7',1421045225,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
12.01.2015, 07:47:06, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B36DE7',1,1,1421045226,0,0,8000,10,'54B36DE7',1421045226,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
12.01.2015, 07:47:07, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B36DE7',2,1,1421045227,0,0,8000,10,'54B36DE7',1421045227,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
12.01.2015, 07:47:08, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B36DE7',3,1,1421045227,0,0,8000,10,'54B36DE7',1421045227,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
12.01.2015, 07:47:12, UPDATE execute_data SET tstamp=1421045232,exectime=1421045225,answertime=1421045232,endcalltime=1421045232,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 07:47:12, UPDATE execute_data SET tstamp=1421045232,exectime=1421045227,answertime=1421045232,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 07:47:13, UPDATE execute_data SET tstamp=1421045232,exectime=1421045227,answertime=1421045232,endcalltime=1421045232,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7' AND dbfentry=3 AND dbfentrypos=1
12.01.2015, 07:47:13, UPDATE execute_data SET tstamp=1421045232,exectime=1421045226,answertime=1421045232,endcalltime=1421045232,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 07:47:14, UPDATE execute_data SET tstamp=1421045233,exectime=1421045227,answertime=1421045232,endcalltime=1421045233,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 07:47:29, UPDATE alarm_data SET tstamp=1421045249,alrstatus=2,endtime=1421045249,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B36DE7'
12.01.2015, 07:47:29, UPDATE alarm_status SET reference='54B36DE7',tstamp='1421045249',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
12.01.2015, 08:16:25, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',1421046985,1421046985,03,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 08:16:25, UPDATE alarm_data SET msg='ZLT:RZK_S05____AN_SM_SSM_;Summenst”rung Badewasserbereitung;',dispmsg1='ZLT:RZK_S05____A',dispmsg2='_SSM_;Summenst”r',tstamp=1421046985 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9'
12.01.2015, 08:16:25, UPDATE alarm_status SET reference='54B374C9',tstamp=1421046985,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
12.01.2015, 08:16:27, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',4,1,1421046986,0,0,8010,50,'54B374C9',1421046986,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
12.01.2015, 08:16:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',0,1,1421046987,0,0,8010,50,'54B374C9',1421046987,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
12.01.2015, 08:16:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',1,1,1421046987,0,0,8010,50,'54B374C9',1421046987,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
12.01.2015, 08:16:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',2,1,1421046987,0,0,8010,50,'54B374C9',1421046987,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
12.01.2015, 08:16:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',3,1,1421046987,0,0,8010,50,'54B374C9',1421046987,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
12.01.2015, 08:16:28, UPDATE execute_data SET tstamp=1421046988,exectime=1421046987,answertime=1421046988,endcalltime=1421046988,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 08:16:29, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B374C9',0,2,1421046989,0,0,8010,50,'54B374C9',1421046989,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
12.01.2015, 08:16:29, UPDATE execute_data SET tstamp=1421046988,exectime=1421046987,answertime=1421046988,endcalltime=1421046988,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 08:16:31, UPDATE execute_data SET tstamp=1421046990,exectime=1421046989,answertime=1421046990,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=0 AND dbfentrypos=2
12.01.2015, 08:16:31, UPDATE execute_data SET tstamp=1421046991,exectime=1421046989,answertime=1421046990,endcalltime=1421046991,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=0 AND dbfentrypos=2
12.01.2015, 08:16:36, UPDATE execute_data SET tstamp=1421046996,execstatus=8,exectime=1421046992, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=4 AND dbfentrypos=1
12.01.2015, 08:17:11, UPDATE execute_data SET tstamp=1421047031,exectime=1421046987,answertime=1421047031,endcalltime=1421047031,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 08:17:14, UPDATE execute_data SET tstamp=1421047034,exectime=1421046987,answertime=1421047034,endcalltime=1421047034,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9' AND dbfentry=3 AND dbfentrypos=1
12.01.2015, 08:17:15, UPDATE alarm_data SET tstamp=1421047035,alrstatus=2,endtime=1421047035,duration=50, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B374C9'
12.01.2015, 08:17:15, UPDATE alarm_status SET reference='54B374C9',tstamp='1421047035',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
12.01.2015, 10:05:04, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',1421053504,1421053504,03,8021,'Storung',50,'Technik',0,1,5,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 10:05:04, UPDATE alarm_data SET msg='BMA:2/1 E0 ZWD 037 Erschlies',dispmsg1='BMA:2/1 E0 ZWD 0',dispmsg2='BMA:2/1 E0 ZWD 0',tstamp=1421053504 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F'
12.01.2015, 10:05:04, UPDATE alarm_status SET reference='54B38E3F',tstamp=1421053504,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
12.01.2015, 10:05:06, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',4,1,1421053505,0,0,8021,50,'54B38E3F',1421053505,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
12.01.2015, 10:05:08, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',0,1,1421053508,0,0,8021,50,'54B38E3F',1421053508,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
12.01.2015, 10:05:08, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',1,1,1421053508,0,0,8021,50,'54B38E3F',1421053508,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
12.01.2015, 10:05:09, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',2,1,1421053509,0,0,8021,50,'54B38E3F',1421053509,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
12.01.2015, 10:05:10, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E3F',3,1,1421053509,0,0,8021,50,'54B38E3F',1421053509,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
12.01.2015, 10:05:14, UPDATE execute_data SET tstamp=1421053514,exectime=1421053508,answertime=1421053514,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:05:15, UPDATE execute_data SET tstamp=1421053515,execstatus=8,exectime=1421053510, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=4 AND dbfentrypos=1
12.01.2015, 10:05:19, UPDATE execute_data SET tstamp=1421053518,exectime=1421053508,answertime=1421053514,endcalltime=1421053518,confirmtime=0,callduration=4,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:05:20, UPDATE execute_data SET tstamp=1421053520,exectime=1421053509,answertime=1421053520,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:05:31, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',1421053531,1421053531,03,8021,'Storung',50,'Technik',0,1,5,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 10:05:31, UPDATE alarm_data SET msg='BMA:Netzsp. allg./ Netzgerat BMA',dispmsg1='BMA:Netzsp. allg',dispmsg2='BMA:Netzsp. allg',tstamp=1421053531 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A'
12.01.2015, 10:05:31, UPDATE alarm_status SET reference='54B38E5A',tstamp=1421053531,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
12.01.2015, 10:05:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',0,1,1421053532,0,0,8021,50,'54B38E5A',1421053532,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
12.01.2015, 10:05:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',1,1,1421053532,0,0,8021,50,'54B38E5A',1421053532,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
12.01.2015, 10:05:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',4,1,1421053532,0,0,8021,50,'54B38E5A',1421053532,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
12.01.2015, 10:05:33, UPDATE execute_data SET tstamp=1421053533,exectime=1421053509,answertime=1421053520,endcalltime=1421053533,confirmtime=0,callduration=13,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:05:34, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',2,1,1421053533,0,0,8021,50,'54B38E5A',1421053533,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
12.01.2015, 10:05:34, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E5A',3,1,1421053533,0,0,8021,50,'54B38E5A',1421053533,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
12.01.2015, 10:05:35, UPDATE execute_data SET tstamp=1421053535,exectime=1421053532,answertime=1421053535,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:05:37, UPDATE execute_data SET tstamp=1421053536,exectime=1421053532,answertime=1421053535,endcalltime=1421053536,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:05:37, UPDATE execute_data SET tstamp=1421053537,exectime=1421053533,answertime=1421053537,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:05:39, UPDATE execute_data SET tstamp=1421053539,exectime=1421053533,answertime=1421053537,endcalltime=1421053539,confirmtime=0,callduration=2,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:05:41, UPDATE execute_data SET tstamp=1421053541,execstatus=8,exectime=1421053538, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=4 AND dbfentrypos=1
12.01.2015, 10:05:52, UPDATE execute_data SET tstamp=1421053551,exectime=1421053508,answertime=1421053551,endcalltime=1421053551,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 10:05:56, UPDATE execute_data SET tstamp=1421053556,exectime=1421053509,answertime=1421053556,endcalltime=1421053556,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F' AND dbfentry=3 AND dbfentrypos=1
12.01.2015, 10:05:58, UPDATE alarm_data SET tstamp=1421053558,alrstatus=2,endtime=1421053558,duration=54, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E3F'
12.01.2015, 10:05:58, UPDATE alarm_status SET reference='54B38E3F',tstamp='1421053558',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
12.01.2015, 10:06:05, UPDATE execute_data SET tstamp=1421053565,exectime=1421053533,answertime=1421053564,endcalltime=1421053564,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=3 AND dbfentrypos=1
12.01.2015, 10:06:07, UPDATE execute_data SET tstamp=1421053567,exectime=1421053532,answertime=1421053567,endcalltime=1421053567,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 10:06:09, UPDATE alarm_data SET tstamp=1421053569,alrstatus=2,endtime=1421053569,duration=38, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E5A'
12.01.2015, 10:06:09, UPDATE alarm_status SET reference='54B38E5A',tstamp='1421053569',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
12.01.2015, 10:06:24, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',1421053583,1421053583,03,8021,'Storung',50,'Technik',0,1,5,0,0,0,'ESPA',0,0,0,1)
12.01.2015, 10:06:24, UPDATE alarm_data SET msg='BMA:2/1 E0 ZWD 037 Erschlies',dispmsg1='BMA:2/1 E0 ZWD 0',dispmsg2='BMA:2/1 E0 ZWD 0',tstamp=1421053583 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F'
12.01.2015, 10:06:24, UPDATE alarm_status SET reference='54B38E8F',tstamp=1421053583,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
12.01.2015, 10:06:25, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',0,1,1421053585,0,0,8021,50,'54B38E8F',1421053585,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
12.01.2015, 10:06:25, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',4,1,1421053585,0,0,8021,50,'54B38E8F',1421053585,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
12.01.2015, 10:06:26, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',1,1,1421053586,0,0,8021,50,'54B38E8F',1421053586,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
12.01.2015, 10:06:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',2,1,1421053587,0,0,8021,50,'54B38E8F',1421053587,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
12.01.2015, 10:06:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54B38E8F',3,1,1421053587,0,0,8021,50,'54B38E8F',1421053587,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
12.01.2015, 10:06:29, UPDATE execute_data SET tstamp=1421053588,exectime=1421053585,answertime=1421053588,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:06:29, UPDATE execute_data SET tstamp=1421053589,exectime=1421053585,answertime=1421053588,endcalltime=1421053589,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=0 AND dbfentrypos=1
12.01.2015, 10:06:32, UPDATE execute_data SET tstamp=1421053592,exectime=1421053587,answertime=1421053592,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:06:34, UPDATE execute_data SET tstamp=1421053593,exectime=1421053587,answertime=1421053592,endcalltime=1421053593,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=2 AND dbfentrypos=1
12.01.2015, 10:06:34, UPDATE execute_data SET tstamp=1421053594,execstatus=8,exectime=1421053590, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=4 AND dbfentrypos=1
12.01.2015, 10:07:10, UPDATE execute_data SET tstamp=1421053629,exectime=1421053586,answertime=1421053629,endcalltime=1421053629,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=1 AND dbfentrypos=1
12.01.2015, 10:07:15, UPDATE execute_data SET tstamp=1421053635,exectime=1421053587,answertime=1421053635,endcalltime=1421053635,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F' AND dbfentry=3 AND dbfentrypos=1
12.01.2015, 10:07:18, UPDATE alarm_data SET tstamp=1421053637,alrstatus=2,endtime=1421053637,duration=54, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B38E8F'
12.01.2015, 10:07:18, UPDATE alarm_status SET reference='54B38E8F',tstamp='1421053637',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8021
