15.01.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
15.01.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1360375200  Code:0
15.01.2015, 03:00:00, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1416211200  Code:0
15.01.2015, 03:00:00, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1416211200  Code:0
15.01.2015, 03:00:00, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1416211200  Code:0
15.01.2015, 03:00:00, Delete records from event database nv_event which are older then 720 days
15.01.2015, 11:28:13, 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','54B7963D',1421317693,1421317693,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
15.01.2015, 11:28:13, UPDATE alarm_data SET msg='3 WC-D',dispmsg1='NORMAL 3 WC-D',dispmsg2='NORMAL 3 WC-D',tstamp=1421317693 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D'
15.01.2015, 11:28:13, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421317693 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D'
15.01.2015, 11:28:14, UPDATE alarm_status SET reference='54B7963D',tstamp=1421317693,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 11:28:16, 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','54B7963D',0,1,1421317695,0,0,8000,10,'54B7963D',1421317695,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
15.01.2015, 11:28:17, 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','54B7963D',1,1,1421317696,0,0,8000,10,'54B7963D',1421317696,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
15.01.2015, 11:28:17, 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','54B7963D',2,1,1421317696,0,0,8000,10,'54B7963D',1421317696,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
15.01.2015, 11:28:17, 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','54B7963D',3,1,1421317696,0,0,8000,10,'54B7963D',1421317696,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
15.01.2015, 11:28:24, UPDATE execute_data SET tstamp=1421317704,exectime=1421317695,answertime=1421317704,endcalltime=1421317704,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 11:28:25, UPDATE execute_data SET tstamp=1421317704,exectime=1421317696,answertime=1421317704,endcalltime=1421317704,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D' AND dbfentry=1 AND dbfentrypos=1
15.01.2015, 11:28:25, UPDATE execute_data SET tstamp=1421317704,exectime=1421317696,answertime=1421317704,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='54B7963D' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 11:28:25, UPDATE execute_data SET tstamp=1421317704,exectime=1421317696,answertime=1421317704,endcalltime=1421317704,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='54B7963D' AND dbfentry=3 AND dbfentrypos=1
15.01.2015, 11:28:26, UPDATE execute_data SET tstamp=1421317705,exectime=1421317696,answertime=1421317704,endcalltime=1421317705,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 11:28:39, UPDATE alarm_data SET tstamp=1421317719,alrstatus=2,endtime=1421317719,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7963D'
15.01.2015, 11:28:39, UPDATE alarm_status SET reference='54B7963D',tstamp='1421317719',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 11:29:13, 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','54B79679',1421317753,1421317753,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
15.01.2015, 11:29:13, UPDATE alarm_data SET msg='3 WC-D',dispmsg1='NORMAL 3 WC-D',dispmsg2='NORMAL 3 WC-D',tstamp=1421317753 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B79679'
15.01.2015, 11:29:14, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421317753 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B79679'
15.01.2015, 11:29:14, UPDATE alarm_status SET reference='54B79679',tstamp=1421317753,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 11:29:14, 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','54B79679',0,1,1421317754,0,0,8000,10,'54B79679',1421317754,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
15.01.2015, 11:29:16, 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','54B79679',1,1,1421317756,0,0,8000,10,'54B79679',1421317756,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
15.01.2015, 11:29:16, 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','54B79679',2,1,1421317756,0,0,8000,10,'54B79679',1421317756,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
15.01.2015, 11:29:16, 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','54B79679',3,1,1421317756,0,0,8000,10,'54B79679',1421317756,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
15.01.2015, 11:29:18, UPDATE execute_data SET tstamp=1421317758,exectime=1421317754,answertime=1421317758,endcalltime=1421317758,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='54B79679' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 11:29:18, UPDATE execute_data SET tstamp=1421317758,exectime=1421317756,answertime=1421317758,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='54B79679' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 11:29:19, UPDATE execute_data SET tstamp=1421317758,exectime=1421317756,answertime=1421317758,endcalltime=1421317758,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='54B79679' AND dbfentry=3 AND dbfentrypos=1
15.01.2015, 11:29:19, UPDATE execute_data SET tstamp=1421317758,exectime=1421317756,answertime=1421317758,endcalltime=1421317758,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B79679' AND dbfentry=1 AND dbfentrypos=1
15.01.2015, 11:29:19, UPDATE execute_data SET tstamp=1421317759,exectime=1421317756,answertime=1421317758,endcalltime=1421317759,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B79679' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 11:29:35, UPDATE alarm_data SET tstamp=1421317775,alrstatus=2,endtime=1421317775,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B79679'
15.01.2015, 11:29:35, UPDATE alarm_status SET reference='54B79679',tstamp='1421317775',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 18:32:13, 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','54B7F99C',1421343133,1421343133,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
15.01.2015, 18:32:13, UPDATE alarm_data SET msg='W 123',dispmsg1='NORMAL W 123',dispmsg2='NORMAL W 123',tstamp=1421343133 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C'
15.01.2015, 18:32:13, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421343133 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C'
15.01.2015, 18:32:13, UPDATE alarm_status SET reference='54B7F99C',tstamp=1421343133,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 18:32:17, 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','54B7F99C',0,1,1421343137,0,0,8000,10,'54B7F99C',1421343137,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
15.01.2015, 18:32:19, 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','54B7F99C',1,1,1421343138,0,0,8000,10,'54B7F99C',1421343138,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
15.01.2015, 18:32:20, 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','54B7F99C',2,1,1421343139,0,0,8000,10,'54B7F99C',1421343139,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
15.01.2015, 18:32:20, 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','54B7F99C',3,1,1421343139,0,0,8000,10,'54B7F99C',1421343139,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
15.01.2015, 18:32:36, UPDATE execute_data SET tstamp=1421343156,exectime=1421343137,answertime=1421343156,endcalltime=1421343156,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 18:32:36, UPDATE execute_data SET tstamp=1421343156,exectime=1421343138,answertime=1421343156,endcalltime=1421343156,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C' AND dbfentry=1 AND dbfentrypos=1
15.01.2015, 18:32:37, UPDATE execute_data SET tstamp=1421343156,exectime=1421343139,answertime=1421343156,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 18:32:37, UPDATE execute_data SET tstamp=1421343156,exectime=1421343139,answertime=1421343156,endcalltime=1421343156,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='54B7F99C' AND dbfentry=3 AND dbfentrypos=1
15.01.2015, 18:32:41, UPDATE execute_data SET tstamp=1421343161,exectime=1421343139,answertime=1421343156,endcalltime=1421343161,confirmtime=0,callduration=5,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 18:32:49, UPDATE alarm_data SET tstamp=1421343169,alrstatus=2,endtime=1421343169,duration=36, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F99C'
15.01.2015, 18:32:49, UPDATE alarm_status SET reference='54B7F99C',tstamp='1421343169',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 18:33:13, 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','54B7F9D8',1421343193,1421343193,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
15.01.2015, 18:33:13, UPDATE alarm_data SET msg='W 123',dispmsg1='NORMAL W 123',dispmsg2='NORMAL W 123',tstamp=1421343193 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8'
15.01.2015, 18:33:13, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421343193 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8'
15.01.2015, 18:33:13, UPDATE alarm_status SET reference='54B7F9D8',tstamp=1421343193,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 18:33:18, 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','54B7F9D8',0,1,1421343197,0,0,8000,10,'54B7F9D8',1421343197,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
15.01.2015, 18:33:18, 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','54B7F9D8',1,1,1421343198,0,0,8000,10,'54B7F9D8',1421343198,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
15.01.2015, 18:33:18, 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','54B7F9D8',2,1,1421343198,0,0,8000,10,'54B7F9D8',1421343198,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
15.01.2015, 18:33:21, 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','54B7F9D8',3,1,1421343200,0,0,8000,10,'54B7F9D8',1421343200,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
15.01.2015, 18:33:22, UPDATE execute_data SET tstamp=1421343202,exectime=1421343198,answertime=1421343202,endcalltime=1421343202,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='54B7F9D8' AND dbfentry=1 AND dbfentrypos=1
15.01.2015, 18:33:22, UPDATE execute_data SET tstamp=1421343202,exectime=1421343198,answertime=1421343202,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 18:33:22, UPDATE execute_data SET tstamp=1421343202,exectime=1421343200,answertime=1421343202,endcalltime=1421343202,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='54B7F9D8' AND dbfentry=3 AND dbfentrypos=1
15.01.2015, 18:33:23, UPDATE execute_data SET tstamp=1421343202,exectime=1421343197,answertime=1421343202,endcalltime=1421343202,confirmtime=0,callduration=0,execstatus=10,substatus='CANCELED (dialexit)',answerdby='CANCELED (dialexit)',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 18:33:23, UPDATE execute_data SET tstamp=1421343203,exectime=1421343198,answertime=1421343202,endcalltime=1421343203,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8' AND dbfentry=2 AND dbfentrypos=1
15.01.2015, 18:33:39, UPDATE alarm_data SET tstamp=1421343218,alrstatus=2,endtime=1421343218,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B7F9D8'
15.01.2015, 18:33:39, UPDATE alarm_status SET reference='54B7F9D8',tstamp='1421343218',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 22:20:10, 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','54B82F09',1421356809,1421356809,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
15.01.2015, 22:20:10, UPDATE alarm_data SET msg='W 142',dispmsg1='NORMAL W 142',dispmsg2='NORMAL W 142',tstamp=1421356809 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B82F09'
15.01.2015, 22:20:10, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421356809 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B82F09'
15.01.2015, 22:20:10, UPDATE alarm_status SET reference='54B82F09',tstamp=1421356809,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
15.01.2015, 22:20: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','54B82F09',0,1,1421356810,0,0,8000,12,'54B82F09',1421356810,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
15.01.2015, 22:20: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','54B82F09',1,1,1421356810,0,0,8000,12,'54B82F09',1421356810,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
15.01.2015, 22:20:16, UPDATE execute_data SET tstamp=1421356815,exectime=1421356810,answertime=1421356815,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='54B82F09' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 22:20:16, UPDATE execute_data SET tstamp=1421356816,exectime=1421356810,answertime=1421356815,endcalltime=1421356815,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='54B82F09' AND dbfentry=1 AND dbfentrypos=1
15.01.2015, 22:20:16, UPDATE execute_data SET tstamp=1421356816,exectime=1421356810,answertime=1421356815,endcalltime=1421356816,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B82F09' AND dbfentry=0 AND dbfentrypos=1
15.01.2015, 22:20:31, UPDATE alarm_data SET tstamp=1421356830,alrstatus=2,endtime=1421356830,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54B82F09'
15.01.2015, 22:20:31, UPDATE alarm_status SET reference='54B82F09',tstamp='1421356830',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
