04.02.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
04.02.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1362103200  Code:0
04.02.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1362103200  Code:0
04.02.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1362103200  Code:0
04.02.2015, 03:00:01, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1362103200  Code:0
04.02.2015, 03:00:01, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1362103201  Code:0
04.02.2015, 03:00:01, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1362103201  Code:0
04.02.2015, 03:00:01, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1417939201  Code:0
04.02.2015, 03:00:01, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1417939201  Code:0
04.02.2015, 03:00:01, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1417939201  Code:0
04.02.2015, 03:00:01, Delete records from event database nv_event which are older then 720 days
04.02.2015, 05:21:00, 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','54D19E2C',1423023660,1423023660,06,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 05:21:00, UPDATE alarm_data SET msg='W 102',dispmsg1='NORMAL W 102',dispmsg2='NORMAL W 102',tstamp=1423023660 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E2C'
04.02.2015, 05:21:00, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1423023660 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E2C'
04.02.2015, 05:21:00, UPDATE alarm_status SET reference='54D19E2C',tstamp=1423023660,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 05:21:01, 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','54D19E2C',0,1,1423023661,0,0,8000,12,'54D19E2C',1423023661,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
04.02.2015, 05:21:02, 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','54D19E2C',1,1,1423023662,0,0,8000,12,'54D19E2C',1423023662,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
04.02.2015, 05:21:08, UPDATE execute_data SET tstamp=1423023667,exectime=1423023661,answertime=1423023667,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='54D19E2C' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 05:21:08, UPDATE execute_data SET tstamp=1423023667,exectime=1423023662,answertime=1423023667,endcalltime=1423023667,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='54D19E2C' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 05:21:15, UPDATE execute_data SET tstamp=1423023674,exectime=1423023661,answertime=1423023667,endcalltime=1423023674,confirmtime=0,callduration=7,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E2C' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 05:21:21, UPDATE alarm_data SET tstamp=1423023681,alrstatus=2,endtime=1423023681,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E2C'
04.02.2015, 05:21:21, UPDATE alarm_status SET reference='54D19E2C',tstamp='1423023681',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 05:22:00, 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','54D19E68',1423023720,1423023720,06,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 05:22:00, UPDATE alarm_data SET msg='W 102',dispmsg1='NORMAL W 102',dispmsg2='NORMAL W 102',tstamp=1423023720 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E68'
04.02.2015, 05:22:01, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1423023720 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E68'
04.02.2015, 05:22:01, UPDATE alarm_status SET reference='54D19E68',tstamp=1423023720,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 05:22:01, 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','54D19E68',0,1,1423023721,0,0,8000,12,'54D19E68',1423023721,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
04.02.2015, 05:22:03, 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','54D19E68',1,1,1423023722,0,0,8000,12,'54D19E68',1423023722,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
04.02.2015, 05:22:10, UPDATE execute_data SET tstamp=1423023729,exectime=1423023721,answertime=1423023729,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E68' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 05:22:10, UPDATE execute_data SET tstamp=1423023730,exectime=1423023722,answertime=1423023729,endcalltime=1423023730,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='54D19E68' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 05:22:10, UPDATE execute_data SET tstamp=1423023730,exectime=1423023721,answertime=1423023729,endcalltime=1423023730,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E68' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 05:22:25, UPDATE alarm_data SET tstamp=1423023745,alrstatus=2,endtime=1423023745,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D19E68'
04.02.2015, 05:22:25, UPDATE alarm_status SET reference='54D19E68',tstamp='1423023745',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 09:20:27, 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','54D1D64A',1423038027,1423038027,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 09:20:27, UPDATE alarm_data SET msg='ZLT:RZK_H08____WW_SM_____;St”rung Warmwasserbereitung;',dispmsg1='ZLT:RZK_H08____W',dispmsg2='_____;St”rung Wa',tstamp=1423038027 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A'
04.02.2015, 09:20:27, UPDATE alarm_status SET reference='54D1D64A',tstamp=1423038027,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 09:20: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','54D1D64A',0,1,1423038028,0,0,8010,50,'54D1D64A',1423038028,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
04.02.2015, 09:20: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','54D1D64A',1,1,1423038028,0,0,8010,50,'54D1D64A',1423038028,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
04.02.2015, 09:20: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','54D1D64A',4,1,1423038028,0,0,8010,50,'54D1D64A',1423038028,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
04.02.2015, 09:20:30, UPDATE execute_data SET tstamp=1423038030,exectime=1423038028,answertime=1423038030,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 09:20:31, UPDATE execute_data SET tstamp=1423038031,exectime=1423038028,answertime=1423038030,endcalltime=1423038031,confirmtime=0,callduration=1,execstatus=1,substatus='8556',answerdby='8556',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 09:20:33, UPDATE execute_data SET tstamp=1423038033,exectime=1423038028,answertime=1423038033,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 09:20:33, 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','54D1D64A',2,1,1423038033,0,0,8010,50,'54D1D64A',1423038033,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
04.02.2015, 09:20:33, 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','54D1D64A',3,1,1423038033,0,0,8010,50,'54D1D64A',1423038033,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
04.02.2015, 09:20:34, UPDATE execute_data SET tstamp=1423038034,exectime=1423038028,answertime=1423038033,endcalltime=1423038034,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 09:20:38, UPDATE execute_data SET tstamp=1423038038,execstatus=8,exectime=1423038034, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=4 AND dbfentrypos=1
04.02.2015, 09:20:39, UPDATE execute_data SET tstamp=1423038039,exectime=1423038033,answertime=1423038039,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 09:20:40, UPDATE execute_data SET tstamp=1423038040,exectime=1423038033,answertime=1423038039,endcalltime=1423038040,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 09:21:12, UPDATE execute_data SET tstamp=1423038071,exectime=1423038033,answertime=1423038071,endcalltime=1423038071,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='54D1D64A' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 09:21:13, UPDATE alarm_data SET tstamp=1423038073,alrstatus=2,endtime=1423038073,duration=46, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1D64A'
04.02.2015, 09:21:13, UPDATE alarm_status SET reference='54D1D64A',tstamp='1423038073',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 09:48:27, 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','54D1DCDA',1423039706,1423039706,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 09:48:27, UPDATE alarm_data SET msg='ZLT:RZK_H00U___FW_SM_DMIN;MIN-Druckw„chter St”rung;',dispmsg1='ZLT:RZK_H00U___F',dispmsg2='_DMIN;MIN-Druckw',tstamp=1423039706 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA'
04.02.2015, 09:48:27, UPDATE alarm_status SET reference='54D1DCDA',tstamp=1423039706,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 09:48: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','54D1DCDA',0,1,1423039707,0,0,8010,50,'54D1DCDA',1423039707,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
04.02.2015, 09:48: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','54D1DCDA',4,1,1423039708,0,0,8010,50,'54D1DCDA',1423039708,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
04.02.2015, 09:48:30, 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','54D1DCDA',1,1,1423039709,0,0,8010,50,'54D1DCDA',1423039709,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
04.02.2015, 09:48:30, 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','54D1DCDA',2,1,1423039710,0,0,8010,50,'54D1DCDA',1423039710,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
04.02.2015, 09:48:33, UPDATE execute_data SET tstamp=1423039712,exectime=1423039707,answertime=1423039712,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 09:48:33, 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','54D1DCDA',3,1,1423039713,0,0,8010,50,'54D1DCDA',1423039713,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
04.02.2015, 09:48:37, UPDATE execute_data SET tstamp=1423039717,execstatus=8,exectime=1423039713, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=4 AND dbfentrypos=1
04.02.2015, 09:48:38, UPDATE execute_data SET tstamp=1423039718,exectime=1423039710,answertime=1423039718,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 09:48:41, UPDATE execute_data SET tstamp=1423039720,exectime=1423039707,answertime=1423039712,endcalltime=1423039720,confirmtime=0,callduration=8,execstatus=1,substatus='555',answerdby='555',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 09:48:43, UPDATE execute_data SET tstamp=1423039723,exectime=1423039710,answertime=1423039718,endcalltime=1423039723,confirmtime=0,callduration=5,execstatus=1,substatus='8557',answerdby='8557',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 09:49:10, UPDATE execute_data SET tstamp=1423039750,exectime=1423039713,answertime=1423039750,endcalltime=1423039750,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 09:49:13, UPDATE execute_data SET tstamp=1423039753,exectime=1423039709,answertime=1423039752,endcalltime=1423039753,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='54D1DCDA' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 09:49:15, UPDATE alarm_data SET tstamp=1423039754,alrstatus=2,endtime=1423039754,duration=48, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D1DCDA'
04.02.2015, 09:49:15, UPDATE alarm_status SET reference='54D1DCDA',tstamp='1423039754',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 14:01:44, 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','54D21838',1423054904,1423054904,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:01:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423054904 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21838'
04.02.2015, 14:01:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423054904 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21838'
04.02.2015, 14:01:44, UPDATE alarm_status SET reference='54D21838',tstamp=1423054904,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:01:46, 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','54D21838',0,1,1423054905,0,0,8000,10,'54D21838',1423054905,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:01:46, 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','54D21838',1,1,1423054905,0,0,8000,10,'54D21838',1423054905,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:01:48, 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','54D21838',2,1,1423054907,0,0,8000,10,'54D21838',1423054907,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:01:48, 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','54D21838',3,1,1423054907,0,0,8000,10,'54D21838',1423054907,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:01:51, UPDATE execute_data SET tstamp=1423054911,exectime=1423054905,answertime=1423054911,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8631',answerdby='8631',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21838' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:01:51, UPDATE execute_data SET tstamp=1423054911,exectime=1423054905,answertime=1423054911,endcalltime=1423054911,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='54D21838' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:01:52, UPDATE execute_data SET tstamp=1423054911,exectime=1423054907,answertime=1423054911,endcalltime=1423054911,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='54D21838' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:01:52, UPDATE execute_data SET tstamp=1423054911,exectime=1423054907,answertime=1423054911,endcalltime=1423054911,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='54D21838' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:01:52, UPDATE execute_data SET tstamp=1423054912,exectime=1423054905,answertime=1423054911,endcalltime=1423054912,confirmtime=0,callduration=1,execstatus=1,substatus='8631',answerdby='8631',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21838' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:02:06, UPDATE alarm_data SET tstamp=1423054926,alrstatus=2,endtime=1423054926,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21838'
04.02.2015, 14:02:06, UPDATE alarm_status SET reference='54D21838',tstamp='1423054926',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:02:44, 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','54D21874',1423054964,1423054964,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:02:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423054964 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21874'
04.02.2015, 14:02:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423054964 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21874'
04.02.2015, 14:02:45, UPDATE alarm_status SET reference='54D21874',tstamp=1423054964,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:02:45, 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','54D21874',0,1,1423054964,0,0,8000,10,'54D21874',1423054964,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:02:52, 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','54D21874',1,1,1423054971,0,0,8000,10,'54D21874',1423054971,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:02:52, 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','54D21874',2,1,1423054972,0,0,8000,10,'54D21874',1423054972,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:02:53, 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','54D21874',3,1,1423054973,0,0,8000,10,'54D21874',1423054973,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:02:56, UPDATE execute_data SET tstamp=1423054976,exectime=1423054964,answertime=1423054976,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8631',answerdby='8631',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21874' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:02:56, UPDATE execute_data SET tstamp=1423054976,exectime=1423054972,answertime=1423054976,endcalltime=1423054976,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='54D21874' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:02:57, UPDATE execute_data SET tstamp=1423054976,exectime=1423054973,answertime=1423054976,endcalltime=1423054976,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='54D21874' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:02:57, UPDATE execute_data SET tstamp=1423054976,exectime=1423054971,answertime=1423054976,endcalltime=1423054976,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='54D21874' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:02:57, UPDATE execute_data SET tstamp=1423054977,exectime=1423054964,answertime=1423054976,endcalltime=1423054977,confirmtime=0,callduration=1,execstatus=1,substatus='8631',answerdby='8631',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21874' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:03:10, UPDATE alarm_data SET tstamp=1423054990,alrstatus=2,endtime=1423054990,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21874'
04.02.2015, 14:03:10, UPDATE alarm_status SET reference='54D21874',tstamp='1423054990',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:03:44, 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','54D218B0',1423055024,1423055024,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:03:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055024 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218B0'
04.02.2015, 14:03:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055024 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218B0'
04.02.2015, 14:03:44, UPDATE alarm_status SET reference='54D218B0',tstamp=1423055024,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:03:45, 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','54D218B0',0,1,1423055025,0,0,8000,10,'54D218B0',1423055025,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:03:48, 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','54D218B0',1,1,1423055028,0,0,8000,10,'54D218B0',1423055028,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:03:48, 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','54D218B0',2,1,1423055028,0,0,8000,10,'54D218B0',1423055028,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:03:48, 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','54D218B0',3,1,1423055028,0,0,8000,10,'54D218B0',1423055028,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:03:55, UPDATE execute_data SET tstamp=1423055035,exectime=1423055028,answertime=1423055035,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='54D218B0' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:03:56, UPDATE execute_data SET tstamp=1423055035,exectime=1423055025,answertime=1423055035,endcalltime=1423055035,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='54D218B0' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:03:56, UPDATE execute_data SET tstamp=1423055035,exectime=1423055028,answertime=1423055035,endcalltime=1423055035,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='54D218B0' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:03:56, UPDATE execute_data SET tstamp=1423055035,exectime=1423055028,answertime=1423055035,endcalltime=1423055035,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='54D218B0' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:04:06, UPDATE execute_data SET tstamp=1423055046,exectime=1423055028,answertime=1423055035,endcalltime=1423055046,confirmtime=0,callduration=11,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218B0' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:04:10, UPDATE alarm_data SET tstamp=1423055050,alrstatus=2,endtime=1423055050,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218B0'
04.02.2015, 14:04:10, UPDATE alarm_status SET reference='54D218B0',tstamp='1423055050',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:04:44, 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','54D218EC',1423055084,1423055084,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:04:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055084 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218EC'
04.02.2015, 14:04:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055084 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218EC'
04.02.2015, 14:04:44, UPDATE alarm_status SET reference='54D218EC',tstamp=1423055084,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:04:45, 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','54D218EC',0,1,1423055084,0,0,8000,10,'54D218EC',1423055084,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:04:45, 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','54D218EC',1,1,1423055085,0,0,8000,10,'54D218EC',1423055085,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:04:47, 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','54D218EC',2,1,1423055087,0,0,8000,10,'54D218EC',1423055087,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:04:47, 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','54D218EC',3,1,1423055087,0,0,8000,10,'54D218EC',1423055087,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:04:51, UPDATE execute_data SET tstamp=1423055090,exectime=1423055085,answertime=1423055090,endcalltime=1423055090,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='54D218EC' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:04:51, UPDATE execute_data SET tstamp=1423055090,exectime=1423055087,answertime=1423055090,endcalltime=1423055090,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='54D218EC' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:04:51, UPDATE execute_data SET tstamp=1423055090,exectime=1423055087,answertime=1423055090,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8634',answerdby='8634',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218EC' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:04:51, UPDATE execute_data SET tstamp=1423055091,exectime=1423055084,answertime=1423055091,endcalltime=1423055091,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='54D218EC' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:04:51, UPDATE execute_data SET tstamp=1423055091,exectime=1423055087,answertime=1423055090,endcalltime=1423055091,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218EC' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:05:06, UPDATE alarm_data SET tstamp=1423055106,alrstatus=2,endtime=1423055106,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D218EC'
04.02.2015, 14:05:06, UPDATE alarm_status SET reference='54D218EC',tstamp='1423055106',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:05:44, 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','54D21928',1423055144,1423055144,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:05:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055144 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21928'
04.02.2015, 14:05:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055144 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21928'
04.02.2015, 14:05:45, UPDATE alarm_status SET reference='54D21928',tstamp=1423055144,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:05:45, 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','54D21928',0,1,1423055145,0,0,8000,10,'54D21928',1423055145,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:05:48, 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','54D21928',1,1,1423055148,0,0,8000,10,'54D21928',1423055148,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:05:49, 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','54D21928',2,1,1423055149,0,0,8000,10,'54D21928',1423055149,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:05:50, 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','54D21928',3,1,1423055150,0,0,8000,10,'54D21928',1423055150,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:05:53, UPDATE execute_data SET tstamp=1423055153,exectime=1423055150,answertime=1423055153,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8634',answerdby='8634',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21928' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:05:54, UPDATE execute_data SET tstamp=1423055153,exectime=1423055145,answertime=1423055153,endcalltime=1423055153,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='54D21928' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:05:54, UPDATE execute_data SET tstamp=1423055153,exectime=1423055148,answertime=1423055153,endcalltime=1423055153,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='54D21928' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:05:54, UPDATE execute_data SET tstamp=1423055153,exectime=1423055149,answertime=1423055153,endcalltime=1423055153,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='54D21928' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:05:54, UPDATE execute_data SET tstamp=1423055154,exectime=1423055150,answertime=1423055153,endcalltime=1423055154,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21928' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:06:10, UPDATE alarm_data SET tstamp=1423055170,alrstatus=2,endtime=1423055170,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21928'
04.02.2015, 14:06:10, UPDATE alarm_status SET reference='54D21928',tstamp='1423055170',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:06:44, 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','54D21964',1423055204,1423055204,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:06:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055204 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21964'
04.02.2015, 14:06:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055204 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21964'
04.02.2015, 14:06:44, UPDATE alarm_status SET reference='54D21964',tstamp=1423055204,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:06:45, 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','54D21964',0,1,1423055205,0,0,8000,10,'54D21964',1423055205,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:06:45, 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','54D21964',1,1,1423055205,0,0,8000,10,'54D21964',1423055205,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:06:45, 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','54D21964',2,1,1423055205,0,0,8000,10,'54D21964',1423055205,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:06:53, 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','54D21964',3,1,1423055213,0,0,8000,10,'54D21964',1423055213,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:06:53, UPDATE execute_data SET tstamp=1423055213,exectime=1423055205,answertime=1423055213,endcalltime=1423055213,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='54D21964' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:06:53, UPDATE execute_data SET tstamp=1423055213,exectime=1423055205,answertime=1423055213,endcalltime=1423055213,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='54D21964' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:06:53, UPDATE execute_data SET tstamp=1423055213,exectime=1423055205,answertime=1423055213,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21964' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:06:54, UPDATE execute_data SET tstamp=1423055213,exectime=1423055213,answertime=1423055213,endcalltime=1423055213,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='54D21964' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:07:03, UPDATE execute_data SET tstamp=1423055223,exectime=1423055205,answertime=1423055213,endcalltime=1423055223,confirmtime=0,callduration=10,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21964' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:07:10, UPDATE alarm_data SET tstamp=1423055230,alrstatus=2,endtime=1423055230,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21964'
04.02.2015, 14:07:10, UPDATE alarm_status SET reference='54D21964',tstamp='1423055230',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:07:44, 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','54D219A0',1423055264,1423055264,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:07:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055264 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219A0'
04.02.2015, 14:07:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055264 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219A0'
04.02.2015, 14:07:44, UPDATE alarm_status SET reference='54D219A0',tstamp=1423055264,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:07:45, 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','54D219A0',0,1,1423055264,0,0,8000,10,'54D219A0',1423055264,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:07:45, 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','54D219A0',1,1,1423055265,0,0,8000,10,'54D219A0',1423055265,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:07:46, 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','54D219A0',2,1,1423055266,0,0,8000,10,'54D219A0',1423055266,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:07:54, 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','54D219A0',3,1,1423055274,0,0,8000,10,'54D219A0',1423055274,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:07:55, UPDATE execute_data SET tstamp=1423055275,exectime=1423055266,answertime=1423055275,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='54D219A0' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:07:55, UPDATE execute_data SET tstamp=1423055275,exectime=1423055264,answertime=1423055275,endcalltime=1423055275,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='54D219A0' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:07:56, UPDATE execute_data SET tstamp=1423055275,exectime=1423055265,answertime=1423055275,endcalltime=1423055275,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='54D219A0' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:07:56, UPDATE execute_data SET tstamp=1423055275,exectime=1423055274,answertime=1423055275,endcalltime=1423055275,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='54D219A0' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:07:59, UPDATE execute_data SET tstamp=1423055278,exectime=1423055266,answertime=1423055275,endcalltime=1423055278,confirmtime=0,callduration=3,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219A0' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:08:10, UPDATE alarm_data SET tstamp=1423055290,alrstatus=2,endtime=1423055290,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219A0'
04.02.2015, 14:08:10, UPDATE alarm_status SET reference='54D219A0',tstamp='1423055290',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:08:44, 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','54D219DC',1423055324,1423055324,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:08:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055324 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219DC'
04.02.2015, 14:08:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055324 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219DC'
04.02.2015, 14:08:45, UPDATE alarm_status SET reference='54D219DC',tstamp=1423055324,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:08:45, 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','54D219DC',0,1,1423055325,0,0,8000,10,'54D219DC',1423055325,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:08:45, 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','54D219DC',1,1,1423055325,0,0,8000,10,'54D219DC',1423055325,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:08:46, 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','54D219DC',2,1,1423055325,0,0,8000,10,'54D219DC',1423055325,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:08:46, 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','54D219DC',3,1,1423055326,0,0,8000,10,'54D219DC',1423055326,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:08:52, UPDATE execute_data SET tstamp=1423055332,exectime=1423055325,answertime=1423055332,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219DC' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:08:53, UPDATE execute_data SET tstamp=1423055332,exectime=1423055325,answertime=1423055332,endcalltime=1423055332,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='54D219DC' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:08:53, UPDATE execute_data SET tstamp=1423055332,exectime=1423055325,answertime=1423055332,endcalltime=1423055332,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='54D219DC' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:08:53, UPDATE execute_data SET tstamp=1423055332,exectime=1423055326,answertime=1423055332,endcalltime=1423055332,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='54D219DC' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:09:06, UPDATE alarm_data SET tstamp=1423055346,alrstatus=2,endtime=1423055346,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219DC'
04.02.2015, 14:09:06, UPDATE alarm_status SET reference='54D219DC',tstamp='1423055346',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:09:06, UPDATE execute_data SET tstamp=1423055346,exectime=1423055325,answertime=1423055332,endcalltime=1423055346,confirmtime=0,callduration=14,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D219DC' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:09:44, 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','54D21A18',1423055384,1423055384,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 14:09:44, UPDATE alarm_data SET msg='1 AUF-R',dispmsg1='NORMAL 1 AUF-R',dispmsg2='NORMAL 1 AUF-R',tstamp=1423055384 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21A18'
04.02.2015, 14:09:44, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423055384 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21A18'
04.02.2015, 14:09:44, UPDATE alarm_status SET reference='54D21A18',tstamp=1423055384,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 14:09:48, 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','54D21A18',0,1,1423055387,0,0,8000,10,'54D21A18',1423055387,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 14:09:48, 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','54D21A18',1,1,1423055387,0,0,8000,10,'54D21A18',1423055387,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 14:09:48, 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','54D21A18',2,1,1423055388,0,0,8000,10,'54D21A18',1423055388,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 14:09:48, 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','54D21A18',3,1,1423055388,0,0,8000,10,'54D21A18',1423055388,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 14:09:58, UPDATE execute_data SET tstamp=1423055397,exectime=1423055388,answertime=1423055397,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='54D21A18' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:09:58, UPDATE execute_data SET tstamp=1423055397,exectime=1423055387,answertime=1423055397,endcalltime=1423055397,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='54D21A18' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 14:09:58, UPDATE execute_data SET tstamp=1423055397,exectime=1423055387,answertime=1423055397,endcalltime=1423055397,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='54D21A18' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 14:09:58, UPDATE execute_data SET tstamp=1423055397,exectime=1423055388,answertime=1423055397,endcalltime=1423055397,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='54D21A18' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 14:09:59, UPDATE execute_data SET tstamp=1423055398,exectime=1423055388,answertime=1423055397,endcalltime=1423055398,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21A18' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 14:10:10, UPDATE alarm_data SET tstamp=1423055410,alrstatus=2,endtime=1423055410,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D21A18'
04.02.2015, 14:10:10, UPDATE alarm_status SET reference='54D21A18',tstamp='1423055410',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 15:00:55, 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','54D22617',1423058455,1423058455,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 15:00:55, UPDATE alarm_data SET msg='ZLT:RZK_E08_O1_UV_SM_SSAB;Summenst”rung Verteiler O1 BTAB;',dispmsg1='ZLT:RZK_E08_O1_U',dispmsg2='_SSAB;Summenst”r',tstamp=1423058455 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617'
04.02.2015, 15:00:55, UPDATE alarm_status SET reference='54D22617',tstamp=1423058455,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 15:00:56, 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','54D22617',0,1,1423058456,0,0,8010,50,'54D22617',1423058456,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
04.02.2015, 15:00:57, 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','54D22617',1,1,1423058456,0,0,8010,50,'54D22617',1423058456,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
04.02.2015, 15:00:57, 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','54D22617',2,1,1423058456,0,0,8010,50,'54D22617',1423058456,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
04.02.2015, 15:00:57, 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','54D22617',4,1,1423058456,0,0,8010,50,'54D22617',1423058456,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
04.02.2015, 15:00:57, UPDATE execute_data SET tstamp=1423058457,exectime=1423058456,answertime=1423058457,endcalltime=1423058457,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 15:01:01, 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','54D22617',3,1,1423058461,0,0,8010,50,'54D22617',1423058461,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
04.02.2015, 15:01:02, UPDATE execute_data SET tstamp=1423058462,exectime=1423058456,answertime=1423058462,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 15:01:05, UPDATE execute_data SET tstamp=1423058465,exectime=1423058456,answertime=1423058462,endcalltime=1423058465,confirmtime=0,callduration=3,execstatus=1,substatus='555',answerdby='555',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 15:01:06, UPDATE execute_data SET tstamp=1423058466,execstatus=8,exectime=1423058462, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=4 AND dbfentrypos=1
04.02.2015, 15:01:09, UPDATE execute_data SET tstamp=1423058469,exectime=1423058456,answertime=1423058469,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 15:01:10, UPDATE execute_data SET tstamp=1423058469,exectime=1423058456,answertime=1423058469,endcalltime=1423058469,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 15:01:48, UPDATE execute_data SET tstamp=1423058508,exectime=1423058461,answertime=1423058508,endcalltime=1423058508,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 15:01:51, UPDATE alarm_data SET tstamp=1423058511,alrstatus=2,endtime=1423058511,duration=56, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D22617'
04.02.2015, 15:01:51, UPDATE alarm_status SET reference='54D22617',tstamp='1423058511',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 15:43:52, 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','54D23027',1423061032,1423061032,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 15:43:52, UPDATE alarm_data SET msg='ZLT:RZK_S0901__WA_SM_ENTH;Wasseraufb.Enth„rtung St”rung;',dispmsg1='ZLT:RZK_S0901__W',dispmsg2='_ENTH;Wasseraufb',tstamp=1423061032 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027'
04.02.2015, 15:43:52, UPDATE alarm_status SET reference='54D23027',tstamp=1423061032,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 15:43:53, 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','54D23027',0,1,1423061033,0,0,8010,50,'54D23027',1423061033,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
04.02.2015, 15:43:54, 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','54D23027',4,1,1423061033,0,0,8010,50,'54D23027',1423061033,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
04.02.2015, 15:43:54, 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','54D23027',1,1,1423061034,0,0,8010,50,'54D23027',1423061034,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
04.02.2015, 15:43:55, 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','54D23027',2,1,1423061035,0,0,8010,50,'54D23027',1423061035,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
04.02.2015, 15:43:56, UPDATE execute_data SET tstamp=1423061036,exectime=1423061035,answertime=1423061036,endcalltime=1423061036,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 15:43:57, 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','54D23027',3,1,1423061036,0,0,8010,50,'54D23027',1423061036,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
04.02.2015, 15:43:57, UPDATE execute_data SET tstamp=1423061036,exectime=1423061033,answertime=1423061036,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 15:43:57, UPDATE execute_data SET tstamp=1423061037,exectime=1423061034,answertime=1423061037,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 15:43:58, UPDATE execute_data SET tstamp=1423061038,exectime=1423061034,answertime=1423061037,endcalltime=1423061038,confirmtime=0,callduration=1,execstatus=1,substatus='8556',answerdby='8556',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 15:43:59, UPDATE execute_data SET tstamp=1423061039,exectime=1423061033,answertime=1423061036,endcalltime=1423061039,confirmtime=0,callduration=3,execstatus=1,substatus='555',answerdby='555',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 15:44:03, UPDATE execute_data SET tstamp=1423061043,execstatus=8,exectime=1423061038, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=4 AND dbfentrypos=1
04.02.2015, 15:44:34, UPDATE execute_data SET tstamp=1423061074,exectime=1423061036,answertime=1423061074,endcalltime=1423061074,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 15:44:36, UPDATE alarm_data SET tstamp=1423061076,alrstatus=2,endtime=1423061076,duration=44, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D23027'
04.02.2015, 15:44:36, UPDATE alarm_status SET reference='54D23027',tstamp='1423061076',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
04.02.2015, 17:35:47, 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','54D24A63',1423067747,1423067747,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
04.02.2015, 17:35:48, UPDATE alarm_data SET msg='W 112',dispmsg1='NORMAL W 112',dispmsg2='NORMAL W 112',tstamp=1423067747 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D24A63'
04.02.2015, 17:35:48, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423067747 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D24A63'
04.02.2015, 17:35:48, UPDATE alarm_status SET reference='54D24A63',tstamp=1423067747,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
04.02.2015, 17:35:48, 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','54D24A63',0,1,1423067747,0,0,8000,10,'54D24A63',1423067747,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
04.02.2015, 17:35:50, 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','54D24A63',1,1,1423067750,0,0,8000,10,'54D24A63',1423067750,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
04.02.2015, 17:35:50, 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','54D24A63',2,1,1423067749,0,0,8000,10,'54D24A63',1423067749,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
04.02.2015, 17:35:50, 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','54D24A63',3,1,1423067750,0,0,8000,10,'54D24A63',1423067750,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
04.02.2015, 17:35:58, UPDATE execute_data SET tstamp=1423067758,exectime=1423067747,answertime=1423067758,endcalltime=1423067758,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='54D24A63' AND dbfentry=0 AND dbfentrypos=1
04.02.2015, 17:35:58, UPDATE execute_data SET tstamp=1423067758,exectime=1423067749,answertime=1423067758,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D24A63' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 17:35:59, UPDATE execute_data SET tstamp=1423067758,exectime=1423067750,answertime=1423067758,endcalltime=1423067758,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='54D24A63' AND dbfentry=3 AND dbfentrypos=1
04.02.2015, 17:35:59, UPDATE execute_data SET tstamp=1423067758,exectime=1423067750,answertime=1423067758,endcalltime=1423067758,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='54D24A63' AND dbfentry=1 AND dbfentrypos=1
04.02.2015, 17:36:09, UPDATE execute_data SET tstamp=1423067769,exectime=1423067749,answertime=1423067758,endcalltime=1423067769,confirmtime=0,callduration=11,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D24A63' AND dbfentry=2 AND dbfentrypos=1
04.02.2015, 17:36:13, UPDATE alarm_data SET tstamp=1423067773,alrstatus=2,endtime=1423067773,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D24A63'
04.02.2015, 17:36:13, UPDATE alarm_status SET reference='54D24A63',tstamp='1423067773',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
