06.02.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
06.02.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1362276000  Code:0
06.02.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1362276000  Code:0
06.02.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1362276000  Code:0
06.02.2015, 03:00:01, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1362276000  Code:0
06.02.2015, 03:00:01, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1362276001  Code:0
06.02.2015, 03:00:01, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1362276001  Code:0
06.02.2015, 03:00:01, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1418112001  Code:0
06.02.2015, 03:00:01, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1418112001  Code:0
06.02.2015, 03:00:01, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1418112001  Code:0
06.02.2015, 03:00:01, Delete records from event database nv_event which are older then 720 days
06.02.2015, 03:00:01, Reposted 1 failed SQL alarm data jobs automatically from error dir: \nvt\nvawdir\sqljob\nv_alarm.\error
06.02.2015, 08:51:43, 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','54D4728F',1423209103,1423209103,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:51:43, UPDATE alarm_data SET msg='ZLT:ERR_E0_058_14A2;;',dispmsg1='ZLT:ERR_E0_058_1',dispmsg2=';',tstamp=1423209103 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F'
06.02.2015, 08:51:44, UPDATE alarm_status SET reference='54D4728F',tstamp=1423209103,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:51:44, 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','54D4728F',0,1,1423209104,0,0,8010,50,'54D4728F',1423209104,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:51: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','54D4728F',4,1,1423209105,0,0,8010,50,'54D4728F',1423209105,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:51: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','54D4728F',1,1,1423209107,0,0,8010,50,'54D4728F',1423209107,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:51: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','54D4728F',2,1,1423209107,0,0,8010,50,'54D4728F',1423209107,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:51: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','54D4728F',3,1,1423209107,0,0,8010,50,'54D4728F',1423209107,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:51:48, UPDATE execute_data SET tstamp=1423209108,exectime=1423209104,answertime=1423209108,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:51:49, UPDATE execute_data SET tstamp=1423209109,exectime=1423209104,answertime=1423209108,endcalltime=1423209109,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:51:51, UPDATE execute_data SET tstamp=1423209111,exectime=1423209107,answertime=1423209111,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='54D4728F' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:51:54, UPDATE execute_data SET tstamp=1423209114,exectime=1423209107,answertime=1423209111,endcalltime=1423209114,confirmtime=0,callduration=3,execstatus=1,substatus='8556',answerdby='8556',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:51:54, UPDATE execute_data SET tstamp=1423209113,execstatus=8,exectime=1423209110, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:52:07, 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','54D472A6',1423209126,1423209126,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:52:07, UPDATE alarm_data SET msg='ZLT:ERR_E0_069_15A1;;',dispmsg1='ZLT:ERR_E0_069_1',dispmsg2=';',tstamp=1423209127 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472A6'
06.02.2015, 08:52:07, UPDATE alarm_status SET reference='54D472A6',tstamp=1423209127,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:52:07, UPDATE execute_data SET tstamp=1423209126,exectime=1423209107,answertime=1423209126,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:08, UPDATE execute_data SET tstamp=1423209127,exectime=1423209107,answertime=1423209126,endcalltime=1423209127,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:08, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D472A6',0,1,1423209128,0,0,8010,50,'54D472A6',1423209128,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:52:08, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D472A6',4,1,1423209128,0,0,8010,50,'54D472A6',1423209128,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:52:09, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D472A6',1,1,1423209129,0,0,8010,50,'54D472A6',1423209129,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:52: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','54D472A6',2,1,1423209130,0,0,8010,50,'54D472A6',1423209130,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:52: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','54D472A6',3,1,1423209130,0,0,8010,50,'54D472A6',1423209130,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:52:11, UPDATE execute_data SET tstamp=1423209130,exectime=1423209128,answertime=1423209130,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='54D472A6' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:52:12, UPDATE execute_data SET tstamp=1423209131,exectime=1423209128,answertime=1423209130,endcalltime=1423209131,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472A6' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:52:17, UPDATE execute_data SET tstamp=1423209137,execstatus=8,exectime=1423209133, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472A6' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:52:19, UPDATE execute_data SET tstamp=1423209139,exectime=1423209130,answertime=1423209139,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='54D472A6' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:20, UPDATE execute_data SET tstamp=1423209140,exectime=1423209130,answertime=1423209139,endcalltime=1423209140,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='54D472A6' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:30, 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','54D472BE',1423209150,1423209150,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:52:31, UPDATE alarm_data SET msg='ZLT:ERR_E0_071_15A2;;',dispmsg1='ZLT:ERR_E0_071_1',dispmsg2=';',tstamp=1423209150 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE'
06.02.2015, 08:52:31, UPDATE alarm_status SET reference='54D472BE',tstamp=1423209150,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:52:31, 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','54D472BE',0,1,1423209151,0,0,8010,50,'54D472BE',1423209151,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:52:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D472BE',4,1,1423209152,0,0,8010,50,'54D472BE',1423209152,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:52:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D472BE',1,1,1423209152,0,0,8010,50,'54D472BE',1423209152,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:52:33, UPDATE execute_data SET tstamp=1423209153,exectime=1423209151,answertime=1423209153,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:52:34, UPDATE execute_data SET tstamp=1423209154,exectime=1423209151,answertime=1423209153,endcalltime=1423209154,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:52:35, 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','54D472BE',2,1,1423209154,0,0,8010,50,'54D472BE',1423209154,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:52:35, 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','54D472BE',3,1,1423209155,0,0,8010,50,'54D472BE',1423209155,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:52:35, UPDATE execute_data SET tstamp=1423209155,exectime=1423209107,answertime=1423209155,endcalltime=1423209155,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:52:37, UPDATE alarm_data SET tstamp=1423209157,alrstatus=2,endtime=1423209157,duration=54, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4728F'
06.02.2015, 08:52:38, UPDATE alarm_status SET reference='54D4728F',tstamp='1423209157',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:52:40, UPDATE execute_data SET tstamp=1423209160,execstatus=8,exectime=1423209157, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:52:41, UPDATE execute_data SET tstamp=1423209161,exectime=1423209130,answertime=1423209160,endcalltime=1423209161,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472A6' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:52:44, UPDATE execute_data SET tstamp=1423209163,exectime=1423209154,answertime=1423209163,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:44, UPDATE execute_data SET tstamp=1423209164,exectime=1423209154,answertime=1423209163,endcalltime=1423209164,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:52:52, UPDATE execute_data SET tstamp=1423209172,exectime=1423209129,answertime=1423209172,endcalltime=1423209172,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='54D472A6' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:52:55, UPDATE alarm_data SET tstamp=1423209175,alrstatus=2,endtime=1423209175,duration=49, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472A6'
06.02.2015, 08:52:55, UPDATE alarm_status SET reference='54D472A6',tstamp='1423209175',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:53:08, UPDATE execute_data SET tstamp=1423209187,exectime=1423209152,answertime=1423209187,endcalltime=1423209187,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:53:25, UPDATE execute_data SET tstamp=1423209205,exectime=1423209155,answertime=1423209205,endcalltime=1423209205,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:53:26, UPDATE alarm_data SET tstamp=1423209206,alrstatus=2,endtime=1423209206,duration=56, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D472BE'
06.02.2015, 08:53:26, UPDATE alarm_status SET reference='54D472BE',tstamp='1423209206',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:56: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','54D473BB',1423209404,1423209404,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:56:44, UPDATE alarm_data SET msg='ZLT:ERR_E0_078_21A1;;',dispmsg1='ZLT:ERR_E0_078_2',dispmsg2=';',tstamp=1423209404 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB'
06.02.2015, 08:56:44, UPDATE alarm_status SET reference='54D473BB',tstamp=1423209404,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:56: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','54D473BB',0,1,1423209405,0,0,8010,50,'54D473BB',1423209405,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:56: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','54D473BB',4,1,1423209405,0,0,8010,50,'54D473BB',1423209405,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:56: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','54D473BB',1,1,1423209406,0,0,8010,50,'54D473BB',1423209406,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:56: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','54D473BB',2,1,1423209408,0,0,8010,50,'54D473BB',1423209408,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:56: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','54D473BB',3,1,1423209409,0,0,8010,50,'54D473BB',1423209409,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:56:50, UPDATE execute_data SET tstamp=1423209410,exectime=1423209406,answertime=1423209410,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:56:50, UPDATE execute_data SET tstamp=1423209410,exectime=1423209406,answertime=1423209410,endcalltime=1423209410,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:56:52, UPDATE execute_data SET tstamp=1423209411,exectime=1423209408,answertime=1423209411,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:56:52, UPDATE execute_data SET tstamp=1423209412,exectime=1423209408,answertime=1423209411,endcalltime=1423209412,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:56:55, UPDATE execute_data SET tstamp=1423209415,execstatus=8,exectime=1423209411, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:57:28, UPDATE execute_data SET tstamp=1423209448,exectime=1423209405,answertime=1423209448,endcalltime=1423209448,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:57: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','54D473BB',0,2,1423209449,0,0,8010,50,'54D473BB',1423209449,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:57:30, 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','54D473EA',1423209450,1423209450,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:57:30, UPDATE alarm_data SET msg='ZLT:ERR_E0_081_20A2;;',dispmsg1='ZLT:ERR_E0_081_2',dispmsg2=';',tstamp=1423209450 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA'
06.02.2015, 08:57:30, UPDATE alarm_status SET reference='54D473EA',tstamp=1423209450,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:57:31, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D473EB',1423209451,1423209451,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 08:57:31, UPDATE alarm_data SET msg='ZLT:ERR_E0_088_21A2;;',dispmsg1='ZLT:ERR_E0_088_2',dispmsg2=';',tstamp=1423209451 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB'
06.02.2015, 08:57:31, UPDATE alarm_status SET reference='54D473EB',tstamp=1423209451,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:57:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D473EA',0,1,1423209451,0,0,8010,50,'54D473EA',1423209451,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:57:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D473EA',1,1,1423209452,0,0,8010,50,'54D473EA',1423209452,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:57:32, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D473EA',4,1,1423209452,0,0,8010,50,'54D473EA',1423209452,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:57: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','54D473EB',4,1,1423209452,0,0,8010,50,'54D473EB',1423209452,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 08:57: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','54D473EB',0,1,1423209453,0,0,8010,50,'54D473EB',1423209453,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:57:33, UPDATE execute_data SET tstamp=1423209453,exectime=1423209453,answertime=1423209453,endcalltime=1423209453,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:57:34, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D473EB',0,2,1423209454,0,0,8010,50,'54D473EB',1423209454,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:57:35, 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','54D473EA',2,1,1423209454,0,0,8010,50,'54D473EA',1423209454,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:57:35, 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','54D473EB',1,1,1423209454,0,0,8010,50,'54D473EB',1423209454,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 08:57:35, UPDATE execute_data SET tstamp=1423209454,exectime=1423209454,answertime=1423209454,endcalltime=1423209454,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 08:57:35, 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','54D473EA',3,1,1423209455,0,0,8010,50,'54D473EA',1423209455,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:57:37, UPDATE execute_data SET tstamp=1423209456,exectime=1423209409,answertime=1423209456,endcalltime=1423209456,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:57:37, 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','54D473EB',2,1,1423209457,0,0,8010,50,'54D473EB',1423209457,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 08:57:38, UPDATE execute_data SET tstamp=1423209457,execstatus=8,exectime=1423209453, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:57:38, UPDATE execute_data SET tstamp=1423209458,exectime=1423209454,answertime=1423209458,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='54D473EA' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:57:39, UPDATE execute_data SET tstamp=1423209459,exectime=1423209454,answertime=1423209458,endcalltime=1423209459,confirmtime=0,callduration=1,execstatus=1,substatus='8557',answerdby='8557',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:57:39, 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','54D473EB',3,1,1423209459,0,0,8010,50,'54D473EB',1423209459,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 08:57:41, UPDATE execute_data SET tstamp=1423209461,execstatus=8,exectime=1423209456, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 08:57:46, UPDATE execute_data SET tstamp=1423209466,exectime=1423209452,answertime=1423209466,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:58:00, UPDATE execute_data SET tstamp=1423209480,exectime=1423209452,answertime=1423209466,endcalltime=1423209480,confirmtime=0,callduration=14,execstatus=1,substatus='8556',answerdby='8556',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:58:07, UPDATE execute_data SET tstamp=1423209486,exectime=1423209455,answertime=1423209486,endcalltime=1423209486,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:58:10, UPDATE execute_data SET tstamp=1423209490,exectime=1423209454,answertime=1423209490,endcalltime=1423209490,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 08:58:12, UPDATE execute_data SET tstamp=1423209492,exectime=1423209449,answertime=1423209492,endcalltime=1423209492,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 08:58:13, UPDATE execute_data SET tstamp=1423209493,exectime=1423209457,answertime=1423209492,endcalltime=1423209492,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 08:58:14, UPDATE alarm_data SET tstamp=1423209494,alrstatus=2,endtime=1423209494,duration=90, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473BB'
06.02.2015, 08:58:14, UPDATE alarm_status SET reference='54D473BB',tstamp='1423209494',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:58:17, UPDATE execute_data SET tstamp=1423209497,exectime=1423209451,answertime=1423209497,endcalltime=1423209497,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='54D473EA' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 08:58: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','54D473EA',0,2,1423209498,0,0,8010,50,'54D473EA',1423209498,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 08:58:21, UPDATE execute_data SET tstamp=1423209501,exectime=1423209498,answertime=1423209501,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 08:58:21, UPDATE execute_data SET tstamp=1423209501,exectime=1423209498,answertime=1423209501,endcalltime=1423209501,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=1,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 08:58:22, UPDATE alarm_data SET tstamp=1423209502,alrstatus=2,endtime=1423209502,duration=52, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EA'
06.02.2015, 08:58:23, UPDATE alarm_status SET reference='54D473EA',tstamp='1423209502',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 08:58:24, UPDATE execute_data SET tstamp=1423209504,exectime=1423209459,answertime=1423209503,endcalltime=1423209503,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='54D473EB' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 08:58:25, UPDATE alarm_data SET tstamp=1423209505,alrstatus=2,endtime=1423209505,duration=54, voicefile='d:\dbv1\.\v8010_1.wav',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D473EB'
06.02.2015, 08:58:25, UPDATE alarm_status SET reference='54D473EB',tstamp='1423209505',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:54:39, 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','54D4814E',1423212878,1423212878,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 09:54:39, UPDATE alarm_data SET msg='ZLT:ERR_E0_033_32A1;;',dispmsg1='ZLT:ERR_E0_033_3',dispmsg2=';',tstamp=1423212879 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E'
06.02.2015, 09:54:39, UPDATE alarm_status SET reference='54D4814E',tstamp=1423212879,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:54:39, 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','54D4814F',1423212879,1423212879,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 09:54:40, UPDATE alarm_data SET msg='ZLT:ERR_E0_034_30A1;;',dispmsg1='ZLT:ERR_E0_034_3',dispmsg2=';',tstamp=1423212879 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F'
06.02.2015, 09:54:40, UPDATE alarm_status SET reference='54D4814F',tstamp=1423212879,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:54:40, 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','54D4814E',0,1,1423212880,0,0,8010,50,'54D4814E',1423212880,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:54:41, 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','54D4814E',1,1,1423212880,0,0,8010,50,'54D4814E',1423212880,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 09:54:41, 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','54D4814E',4,1,1423212880,0,0,8010,50,'54D4814E',1423212880,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 09:54:41, 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','54D4814F',4,1,1423212881,0,0,8010,50,'54D4814F',1423212881,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 09:54:42, 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','54D4814F',0,1,1423212881,0,0,8010,50,'54D4814F',1423212881,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:54:42, UPDATE execute_data SET tstamp=1423212882,exectime=1423212881,answertime=1423212882,endcalltime=1423212882,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 09:54:42, 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','54D4814F',0,2,1423212882,0,0,8010,50,'54D4814F',1423212882,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:54:44, 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','54D4814E',2,1,1423212884,0,0,8010,50,'54D4814E',1423212884,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 09:54:45, UPDATE execute_data SET tstamp=1423212884,exectime=1423212882,answertime=1423212884,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:54:45, UPDATE execute_data SET tstamp=1423212885,exectime=1423212882,answertime=1423212884,endcalltime=1423212885,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:54: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','54D4814F',1,1,1423212885,0,0,8010,50,'54D4814F',1423212885,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 09:54:46, UPDATE execute_data SET tstamp=1423212886,execstatus=8,exectime=1423212882, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 09:54: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','54D4814E',3,1,1423212887,0,0,8010,50,'54D4814E',1423212887,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 09:54: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','54D4814F',2,1,1423212887,0,0,8010,50,'54D4814F',1423212887,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 09:54: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','54D4814F',3,1,1423212888,0,0,8010,50,'54D4814F',1423212888,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 09:54:49, UPDATE execute_data SET tstamp=1423212889,execstatus=8,exectime=1423212885, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 09:55:00, UPDATE execute_data SET tstamp=1423212900,exectime=1423212884,answertime=1423212900,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 09:55:01, UPDATE execute_data SET tstamp=1423212900,exectime=1423212884,answertime=1423212900,endcalltime=1423212900,confirmtime=0,callduration=0,execstatus=1,substatus='8557',answerdby='8557',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 09:55:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D48166',1423212903,1423212903,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 09:55:03, UPDATE alarm_data SET msg='ZLT:ERR_E0_035_34A2;;',dispmsg1='ZLT:ERR_E0_035_3',dispmsg2=';',tstamp=1423212903 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166'
06.02.2015, 09:55:03, UPDATE alarm_status SET reference='54D48166',tstamp=1423212903,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:55:05, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D48166',4,1,1423212904,0,0,8010,50,'54D48166',1423212904,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 09:55:09, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D48166',0,1,1423212909,0,0,8010,50,'54D48166',1423212909,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:55:10, UPDATE execute_data SET tstamp=1423212909,exectime=1423212909,answertime=1423212909,endcalltime=1423212909,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 09:55: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','54D48166',0,2,1423212910,0,0,8010,50,'54D48166',1423212910,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:55:11, 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','54D48166',1,1,1423212911,0,0,8010,50,'54D48166',1423212911,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 09:55:12, UPDATE execute_data SET tstamp=1423212912,exectime=1423212910,answertime=1423212912,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='555',answerdby='555',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:55:13, UPDATE execute_data SET tstamp=1423212913,exectime=1423212910,answertime=1423212912,endcalltime=1423212913,confirmtime=0,callduration=1,execstatus=1,substatus='555',answerdby='555',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:55: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','54D48166',2,1,1423212913,0,0,8010,50,'54D48166',1423212913,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 09:55:14, UPDATE execute_data SET tstamp=1423212913,execstatus=8,exectime=1423212909, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 09:55:19, UPDATE execute_data SET tstamp=1423212919,exectime=1423212888,answertime=1423212919,endcalltime=1423212919,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='54D4814F' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 09:55: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','54D48166',3,1,1423212920,0,0,8010,50,'54D48166',1423212920,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 09:55:20, UPDATE execute_data SET tstamp=1423212920,exectime=1423212885,answertime=1423212920,endcalltime=1423212920,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:55:22, UPDATE execute_data SET tstamp=1423212922,exectime=1423212880,answertime=1423212922,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='54D4814E' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:55:23, UPDATE execute_data SET tstamp=1423212922,exectime=1423212880,answertime=1423212922,endcalltime=1423212922,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='54D4814E' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:55:23, UPDATE execute_data SET tstamp=1423212923,exectime=1423212887,answertime=1423212923,endcalltime=1423212923,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 09:55:23, UPDATE execute_data SET tstamp=1423212923,exectime=1423212880,answertime=1423212923,endcalltime=1423212923,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 09:55:24, 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','54D4814E',0,2,1423212923,0,0,8010,50,'54D4814E',1423212923,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:55:25, UPDATE alarm_data SET tstamp=1423212925,alrstatus=2,endtime=1423212925,duration=46, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814F'
06.02.2015, 09:55:25, UPDATE alarm_status SET reference='54D4814F',tstamp='1423212925',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:55:25, UPDATE execute_data SET tstamp=1423212925,exectime=1423212923,answertime=1423212925,endcalltime=1423212925,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:55:33, UPDATE execute_data SET tstamp=1423212933,exectime=1423212887,answertime=1423212932,endcalltime=1423212933,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 09:55:35, UPDATE alarm_data SET tstamp=1423212935,alrstatus=2,endtime=1423212935,duration=57, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4814E'
06.02.2015, 09:55:35, UPDATE alarm_status SET reference='54D4814E',tstamp='1423212935',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:55:47, UPDATE execute_data SET tstamp=1423212946,exectime=1423212911,answertime=1423212946,endcalltime=1423212946,confirmtime=0,callduration=0,execstatus=0,substatus='[0x9F] Unspecified cause',answerdby='',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:55:51, UPDATE execute_data SET tstamp=1423212951,exectime=1423212920,answertime=1423212951,endcalltime=1423212951,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='54D48166' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 09:55:57, UPDATE execute_data SET tstamp=1423212957,exectime=1423212913,answertime=1423212956,endcalltime=1423212957,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=2,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 09:55:59, UPDATE alarm_data SET tstamp=1423212959,alrstatus=2,endtime=1423212959,duration=56, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D48166'
06.02.2015, 09:55:59, UPDATE alarm_status SET reference='54D48166',tstamp='1423212959',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:56:12, 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','54D481AC',1423212972,1423212972,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 09:56:13, UPDATE alarm_data SET msg='ZLT:ERR_E0_026_35A1;;',dispmsg1='ZLT:ERR_E0_026_3',dispmsg2=';',tstamp=1423212972 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC'
06.02.2015, 09:56:13, UPDATE alarm_status SET reference='54D481AC',tstamp=1423212972,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 09:56:13, 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','54D481AC',0,1,1423212973,0,0,8010,50,'54D481AC',1423212973,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:56: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','54D481AC',4,1,1423212974,0,0,8010,50,'54D481AC',1423212974,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
06.02.2015, 09:56: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','54D481AC',1,1,1423212974,0,0,8010,50,'54D481AC',1423212974,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
06.02.2015, 09:56:15, 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','54D481AC',2,1,1423212974,0,0,8010,50,'54D481AC',1423212974,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
06.02.2015, 09:56: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','54D481AC',3,1,1423212976,0,0,8010,50,'54D481AC',1423212976,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
06.02.2015, 09:56:18, UPDATE execute_data SET tstamp=1423212977,exectime=1423212974,answertime=1423212977,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8556',answerdby='8556',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:56:18, UPDATE execute_data SET tstamp=1423212978,exectime=1423212974,answertime=1423212977,endcalltime=1423212978,confirmtime=0,callduration=1,execstatus=1,substatus='8556',answerdby='8556',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 09:56:23, UPDATE execute_data SET tstamp=1423212982,execstatus=8,exectime=1423212979, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=4 AND dbfentrypos=1
06.02.2015, 09:56:57, UPDATE execute_data SET tstamp=1423213016,exectime=1423212973,answertime=1423213016,endcalltime=1423213016,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 09:56: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','54D481AC',0,2,1423213017,0,0,8010,50,'54D481AC',1423213017,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
06.02.2015, 09:56:58, UPDATE execute_data SET tstamp=1423213018,exectime=1423213017,answertime=1423213017,endcalltime=1423213017,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=7,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=0 AND dbfentrypos=2
06.02.2015, 09:56:58, UPDATE execute_data SET tstamp=1423213018,exectime=1423212974,answertime=1423213017,endcalltime=1423213018,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=3,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 09:57:05, UPDATE execute_data SET tstamp=1423213024,exectime=1423212976,answertime=1423213024,endcalltime=1423213024,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 09:57:06, UPDATE alarm_data SET tstamp=1423213026,alrstatus=2,endtime=1423213026,duration=54, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D481AC'
06.02.2015, 09:57:06, UPDATE alarm_status SET reference='54D481AC',tstamp='1423213026',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
06.02.2015, 13:14: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','54D4B03C',1423224892,1423224892,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 13:14:53, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423224892 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B03C'
06.02.2015, 13:14:53, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423224892 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B03C'
06.02.2015, 13:14:53, UPDATE alarm_status SET reference='54D4B03C',tstamp=1423224892,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:14: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','54D4B03C',0,1,1423224893,0,0,8000,10,'54D4B03C',1423224893,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 13:14: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','54D4B03C',1,1,1423224893,0,0,8000,10,'54D4B03C',1423224893,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 13:14: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','54D4B03C',2,1,1423224897,0,0,8000,10,'54D4B03C',1423224897,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 13:14: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','54D4B03C',3,1,1423224897,0,0,8000,10,'54D4B03C',1423224897,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 13:14:58, UPDATE execute_data SET tstamp=1423224898,exectime=1423224893,answertime=1423224898,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8632',answerdby='8632',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B03C' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:14:59, UPDATE execute_data SET tstamp=1423224898,exectime=1423224893,answertime=1423224898,endcalltime=1423224898,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='54D4B03C' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 13:14:59, UPDATE execute_data SET tstamp=1423224898,exectime=1423224897,answertime=1423224898,endcalltime=1423224898,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='54D4B03C' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 13:14:59, UPDATE execute_data SET tstamp=1423224898,exectime=1423224897,answertime=1423224898,endcalltime=1423224898,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='54D4B03C' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:15:00, UPDATE execute_data SET tstamp=1423224899,exectime=1423224893,answertime=1423224898,endcalltime=1423224899,confirmtime=0,callduration=1,execstatus=1,substatus='8632',answerdby='8632',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B03C' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:15:14, UPDATE alarm_data SET tstamp=1423224914,alrstatus=2,endtime=1423224914,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B03C'
06.02.2015, 13:15:14, UPDATE alarm_status SET reference='54D4B03C',tstamp='1423224914',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:15: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','54D4B078',1423224952,1423224952,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 13:15:52, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423224952 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B078'
06.02.2015, 13:15:53, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423224952 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B078'
06.02.2015, 13:15:53, UPDATE alarm_status SET reference='54D4B078',tstamp=1423224952,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:15: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','54D4B078',0,1,1423224953,0,0,8000,10,'54D4B078',1423224953,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 13:15: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','54D4B078',1,1,1423224954,0,0,8000,10,'54D4B078',1423224954,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 13:15: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','54D4B078',2,1,1423224954,0,0,8000,10,'54D4B078',1423224954,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 13:15:57, UPDATE execute_data SET tstamp=1423224957,exectime=1423224954,answertime=1423224957,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8632',answerdby='8632',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B078' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:15:58, UPDATE execute_data SET tstamp=1423224957,exectime=1423224953,answertime=1423224957,endcalltime=1423224957,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='54D4B078' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 13:15:58, UPDATE execute_data SET tstamp=1423224957,exectime=1423224954,answertime=1423224957,endcalltime=1423224957,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='54D4B078' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 13:15:58, 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','54D4B078',3,1,1423224958,0,0,8000,10,'54D4B078',1423224958,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 13:15:58, UPDATE execute_data SET tstamp=1423224958,exectime=1423224954,answertime=1423224957,endcalltime=1423224958,confirmtime=0,callduration=1,execstatus=1,substatus='8632',answerdby='8632',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B078' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:15:58, UPDATE execute_data SET tstamp=1423224958,exectime=1423224958,answertime=1423224958,endcalltime=1423224958,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='54D4B078' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:16:14, UPDATE alarm_data SET tstamp=1423224974,alrstatus=2,endtime=1423224974,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B078'
06.02.2015, 13:16:14, UPDATE alarm_status SET reference='54D4B078',tstamp='1423224974',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:16: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','54D4B0B4',1423225012,1423225012,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 13:16:53, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423225012 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0B4'
06.02.2015, 13:16:53, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423225012 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0B4'
06.02.2015, 13:16:53, UPDATE alarm_status SET reference='54D4B0B4',tstamp=1423225012,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:16:59, 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','54D4B0B4',0,1,1423225019,0,0,8000,10,'54D4B0B4',1423225019,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 13:17:00, 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','54D4B0B4',1,1,1423225019,0,0,8000,10,'54D4B0B4',1423225019,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 13:17:00, 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','54D4B0B4',2,1,1423225020,0,0,8000,10,'54D4B0B4',1423225020,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 13:17: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','54D4B0B4',3,1,1423225021,0,0,8000,10,'54D4B0B4',1423225021,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 13:17:04, UPDATE execute_data SET tstamp=1423225024,exectime=1423225021,answertime=1423225024,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8634',answerdby='8634',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0B4' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:17:04, UPDATE execute_data SET tstamp=1423225024,exectime=1423225019,answertime=1423225024,endcalltime=1423225024,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='54D4B0B4' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 13:17:05, UPDATE execute_data SET tstamp=1423225024,exectime=1423225019,answertime=1423225024,endcalltime=1423225024,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='54D4B0B4' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:17:05, UPDATE execute_data SET tstamp=1423225024,exectime=1423225020,answertime=1423225024,endcalltime=1423225024,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='54D4B0B4' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 13:17:05, UPDATE execute_data SET tstamp=1423225025,exectime=1423225021,answertime=1423225024,endcalltime=1423225025,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0B4' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:17:18, UPDATE alarm_data SET tstamp=1423225038,alrstatus=2,endtime=1423225038,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0B4'
06.02.2015, 13:17:18, UPDATE alarm_status SET reference='54D4B0B4',tstamp='1423225038',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:17: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','54D4B0F0',1423225072,1423225072,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 13:17:52, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423225072 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0F0'
06.02.2015, 13:17:53, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423225072 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0F0'
06.02.2015, 13:17:53, UPDATE alarm_status SET reference='54D4B0F0',tstamp=1423225072,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 13:17: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','54D4B0F0',0,1,1423225076,0,0,8000,10,'54D4B0F0',1423225076,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 13:17: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','54D4B0F0',1,1,1423225076,0,0,8000,10,'54D4B0F0',1423225076,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 13:17: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','54D4B0F0',2,1,1423225076,0,0,8000,10,'54D4B0F0',1423225076,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 13:17: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','54D4B0F0',3,1,1423225076,0,0,8000,10,'54D4B0F0',1423225076,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 13:18:00, UPDATE execute_data SET tstamp=1423225080,exectime=1423225076,answertime=1423225080,endcalltime=1423225080,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='54D4B0F0' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 13:18:00, UPDATE execute_data SET tstamp=1423225080,exectime=1423225076,answertime=1423225079,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8634',answerdby='8634',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0F0' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:18:00, UPDATE execute_data SET tstamp=1423225080,exectime=1423225076,answertime=1423225080,endcalltime=1423225080,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='54D4B0F0' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 13:18:00, UPDATE execute_data SET tstamp=1423225080,exectime=1423225076,answertime=1423225080,endcalltime=1423225080,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='54D4B0F0' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 13:18:01, UPDATE execute_data SET tstamp=1423225080,exectime=1423225076,answertime=1423225079,endcalltime=1423225080,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0F0' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 13:18:14, UPDATE alarm_data SET tstamp=1423225094,alrstatus=2,endtime=1423225094,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4B0F0'
06.02.2015, 13:18:14, UPDATE alarm_status SET reference='54D4B0F0',tstamp='1423225094',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 16:07:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D4D896',1423235223,1423235223,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 16:07:03, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423235223 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D896'
06.02.2015, 16:07:03, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423235223 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D896'
06.02.2015, 16:07:03, UPDATE alarm_status SET reference='54D4D896',tstamp=1423235223,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 16:07:04, 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','54D4D896',0,1,1423235223,0,0,8000,10,'54D4D896',1423235223,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 16:07:11, 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','54D4D896',1,1,1423235230,0,0,8000,10,'54D4D896',1423235230,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 16:07:12, 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','54D4D896',2,1,1423235231,0,0,8000,10,'54D4D896',1423235231,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 16:07:12, 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','54D4D896',3,1,1423235231,0,0,8000,10,'54D4D896',1423235231,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 16:07:14, UPDATE execute_data SET tstamp=1423235234,exectime=1423235230,answertime=1423235234,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8632',answerdby='8632',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D896' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 16:07:15, UPDATE execute_data SET tstamp=1423235234,exectime=1423235223,answertime=1423235234,endcalltime=1423235234,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='54D4D896' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 16:07:15, UPDATE execute_data SET tstamp=1423235234,exectime=1423235231,answertime=1423235234,endcalltime=1423235234,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='54D4D896' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 16:07:15, UPDATE execute_data SET tstamp=1423235234,exectime=1423235231,answertime=1423235234,endcalltime=1423235234,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='54D4D896' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 16:07:15, UPDATE execute_data SET tstamp=1423235235,exectime=1423235230,answertime=1423235234,endcalltime=1423235235,confirmtime=0,callduration=1,execstatus=1,substatus='8632',answerdby='8632',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D896' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 16:07:29, UPDATE alarm_data SET tstamp=1423235248,alrstatus=2,endtime=1423235248,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D896'
06.02.2015, 16:07:29, UPDATE alarm_status SET reference='54D4D896',tstamp='1423235248',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 16:08:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D4D8D2',1423235283,1423235283,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 16:08:03, UPDATE alarm_data SET msg='W 138',dispmsg1='NORMAL W 138',dispmsg2='NORMAL W 138',tstamp=1423235283 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D8D2'
06.02.2015, 16:08:03, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423235283 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D8D2'
06.02.2015, 16:08:03, UPDATE alarm_status SET reference='54D4D8D2',tstamp=1423235283,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 16:08:04, 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','54D4D8D2',0,1,1423235283,0,0,8000,10,'54D4D8D2',1423235283,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 16:08:06, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4D8D2',1,1,1423235286,0,0,8000,10,'54D4D8D2',1423235286,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 16:08:06, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4D8D2',2,1,1423235286,0,0,8000,10,'54D4D8D2',1423235286,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 16:08:07, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4D8D2',3,1,1423235286,0,0,8000,10,'54D4D8D2',1423235286,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 16:08:10, UPDATE execute_data SET tstamp=1423235289,exectime=1423235286,answertime=1423235289,endcalltime=1423235289,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='54D4D8D2' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 16:08:10, UPDATE execute_data SET tstamp=1423235289,exectime=1423235286,answertime=1423235289,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D8D2' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 16:08:10, UPDATE execute_data SET tstamp=1423235289,exectime=1423235286,answertime=1423235289,endcalltime=1423235289,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='54D4D8D2' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 16:08:10, UPDATE execute_data SET tstamp=1423235289,exectime=1423235283,answertime=1423235289,endcalltime=1423235289,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='54D4D8D2' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 16:08:11, UPDATE execute_data SET tstamp=1423235291,exectime=1423235286,answertime=1423235289,endcalltime=1423235291,confirmtime=0,callduration=2,execstatus=1,substatus='8633',answerdby='8633',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D8D2' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 16:08:25, UPDATE alarm_data SET tstamp=1423235304,alrstatus=2,endtime=1423235304,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4D8D2'
06.02.2015, 16:08:25, UPDATE alarm_status SET reference='54D4D8D2',tstamp='1423235304',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:31:21, 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','54D4FA68',1423243881,1423243881,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 18:31:21, UPDATE alarm_data SET msg='BAD-WC W 152',dispmsg1='BAD-WC W 152',dispmsg2='BAD-WC W 152',tstamp=1423243881 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FA68'
06.02.2015, 18:31:21, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423243881 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FA68'
06.02.2015, 18:31:21, UPDATE alarm_status SET reference='54D4FA68',tstamp=1423243881,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:31:22, 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','54D4FA68',0,1,1423243882,0,0,8000,10,'54D4FA68',1423243882,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 18:31:22, 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','54D4FA68',1,1,1423243882,0,0,8000,10,'54D4FA68',1423243882,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 18:31:25, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4FA68',2,1,1423243885,0,0,8000,10,'54D4FA68',1423243885,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 18:31: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','54D4FA68',3,1,1423243889,0,0,8000,10,'54D4FA68',1423243889,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 18:31:30, UPDATE execute_data SET tstamp=1423243890,exectime=1423243885,answertime=1423243889,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='54D4FA68' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 18:31:30, UPDATE execute_data SET tstamp=1423243890,exectime=1423243882,answertime=1423243890,endcalltime=1423243890,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='54D4FA68' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 18:31:30, UPDATE execute_data SET tstamp=1423243890,exectime=1423243882,answertime=1423243890,endcalltime=1423243890,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='54D4FA68' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 18:31:30, UPDATE execute_data SET tstamp=1423243890,exectime=1423243889,answertime=1423243890,endcalltime=1423243890,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='54D4FA68' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 18:31:31, UPDATE execute_data SET tstamp=1423243891,exectime=1423243885,answertime=1423243889,endcalltime=1423243891,confirmtime=0,callduration=2,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FA68' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 18:31:47, UPDATE alarm_data SET tstamp=1423243906,alrstatus=2,endtime=1423243906,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FA68'
06.02.2015, 18:31:47, UPDATE alarm_status SET reference='54D4FA68',tstamp='1423243906',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:55:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D4FFF6',1423245302,1423245302,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 18:55:03, UPDATE alarm_data SET msg='W 217',dispmsg1='NORMAL W 217',dispmsg2='NORMAL W 217',tstamp=1423245302 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FFF6'
06.02.2015, 18:55:03, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423245302 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FFF6'
06.02.2015, 18:55:03, UPDATE alarm_status SET reference='54D4FFF6',tstamp=1423245302,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:55:09, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4FFF6',0,1,1423245309,0,0,8000,10,'54D4FFF6',1423245309,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 18:55:09, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D4FFF6',1,1,1423245309,0,0,8000,10,'54D4FFF6',1423245309,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 18:55: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','54D4FFF6',2,1,1423245310,0,0,8000,10,'54D4FFF6',1423245310,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 18:55: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','54D4FFF6',3,1,1423245310,0,0,8000,10,'54D4FFF6',1423245310,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 18:55:15, UPDATE execute_data SET tstamp=1423245314,exectime=1423245309,answertime=1423245314,endcalltime=1423245314,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='54D4FFF6' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 18:55:15, UPDATE execute_data SET tstamp=1423245314,exectime=1423245310,answertime=1423245314,endcalltime=1423245314,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='54D4FFF6' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 18:55:15, UPDATE execute_data SET tstamp=1423245314,exectime=1423245310,answertime=1423245314,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='54D4FFF6' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 18:55:15, UPDATE execute_data SET tstamp=1423245315,exectime=1423245309,answertime=1423245315,endcalltime=1423245315,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='54D4FFF6' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 18:55:15, UPDATE execute_data SET tstamp=1423245315,exectime=1423245310,answertime=1423245314,endcalltime=1423245315,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FFF6' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 18:55:29, UPDATE alarm_data SET tstamp=1423245328,alrstatus=2,endtime=1423245328,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D4FFF6'
06.02.2015, 18:55:29, UPDATE alarm_status SET reference='54D4FFF6',tstamp='1423245328',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:56:03, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D50032',1423245362,1423245362,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
06.02.2015, 18:56:03, UPDATE alarm_data SET msg='W 217',dispmsg1='NORMAL W 217',dispmsg2='NORMAL W 217',tstamp=1423245362 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D50032'
06.02.2015, 18:56:03, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423245362 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D50032'
06.02.2015, 18:56:03, UPDATE alarm_status SET reference='54D50032',tstamp=1423245362,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
06.02.2015, 18:56:06, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D50032',0,1,1423245366,0,0,8000,10,'54D50032',1423245366,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
06.02.2015, 18:56:07, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D50032',1,1,1423245366,0,0,8000,10,'54D50032',1423245366,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
06.02.2015, 18:56:07, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D50032',2,1,1423245366,0,0,8000,10,'54D50032',1423245366,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
06.02.2015, 18:56:07, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D50032',3,1,1423245366,0,0,8000,10,'54D50032',1423245366,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
06.02.2015, 18:56:11, UPDATE execute_data SET tstamp=1423245370,exectime=1423245366,answertime=1423245370,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='54D50032' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 18:56:11, UPDATE execute_data SET tstamp=1423245371,exectime=1423245366,answertime=1423245371,endcalltime=1423245371,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='54D50032' AND dbfentry=0 AND dbfentrypos=1
06.02.2015, 18:56:11, UPDATE execute_data SET tstamp=1423245371,exectime=1423245366,answertime=1423245370,endcalltime=1423245371,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='54D50032' AND dbfentry=1 AND dbfentrypos=1
06.02.2015, 18:56:11, UPDATE execute_data SET tstamp=1423245371,exectime=1423245366,answertime=1423245370,endcalltime=1423245371,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D50032' AND dbfentry=2 AND dbfentrypos=1
06.02.2015, 18:56:11, UPDATE execute_data SET tstamp=1423245371,exectime=1423245366,answertime=1423245370,endcalltime=1423245371,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='54D50032' AND dbfentry=3 AND dbfentrypos=1
06.02.2015, 18:56:25, UPDATE alarm_data SET tstamp=1423245384,alrstatus=2,endtime=1423245384,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D50032'
06.02.2015, 18:56:25, UPDATE alarm_status SET reference='54D50032',tstamp='1423245384',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
