07.02.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
07.02.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1362362400  Code:0
07.02.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1362362400  Code:0
07.02.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1362362400  Code:0
07.02.2015, 03:00:01, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1362362400  Code:0
07.02.2015, 03:00:01, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1362362401  Code:0
07.02.2015, 03:00:01, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1362362401  Code:0
07.02.2015, 03:00:01, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1418198401  Code:0
07.02.2015, 03:00:01, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1418198401  Code:0
07.02.2015, 03:00:01, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1418198401  Code:0
07.02.2015, 03:00:01, Delete records from event database nv_event which are older then 720 days
07.02.2015, 03:00:01, Reposted 1 failed SQL alarm data jobs automatically from error dir: \nvt\nvawdir\sqljob\nv_alarm.\error
07.02.2015, 06:47:48, 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','54D5A703',1423288067,1423288067,06,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 06:47:48, UPDATE alarm_data SET msg='BAD-WC W 150',dispmsg1='BAD-WC W 150',dispmsg2='BAD-WC W 150',tstamp=1423288067 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703'
07.02.2015, 06:47:48, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1423288067 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703'
07.02.2015, 06:47:48, UPDATE alarm_status SET reference='54D5A703',tstamp=1423288067,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 06:47:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5A703',0,1,1423288072,0,0,8000,12,'54D5A703',1423288072,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
07.02.2015, 06:47:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5A703',1,1,1423288072,0,0,8000,12,'54D5A703',1423288072,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
07.02.2015, 06:48:00, UPDATE execute_data SET tstamp=1423288080,exectime=1423288072,answertime=1423288080,endcalltime=1423288080,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 06:48:17, UPDATE execute_data SET tstamp=1423288097,exectime=1423288072,answertime=1423288096,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='611',answerdby='611',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 06:48:18, UPDATE execute_data SET tstamp=1423288098,exectime=1423288072,answertime=1423288096,endcalltime=1423288098,confirmtime=0,callduration=2,execstatus=1,substatus='611',answerdby='611',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 06:48:33, UPDATE alarm_data SET tstamp=1423288112,alrstatus=2,endtime=1423288112,duration=45, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A703'
07.02.2015, 06:48:33, UPDATE alarm_status SET reference='54D5A703',tstamp='1423288112',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 06:48:47, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D5A73F',1423288127,1423288127,06,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 06:48:48, UPDATE alarm_data SET msg='BAD-WC W 150',dispmsg1='BAD-WC W 150',dispmsg2='BAD-WC W 150',tstamp=1423288127 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A73F'
07.02.2015, 06:48:48, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1423288127 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A73F'
07.02.2015, 06:48:48, UPDATE alarm_status SET reference='54D5A73F',tstamp=1423288127,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 06:48: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','54D5A73F',0,1,1423288129,0,0,8000,12,'54D5A73F',1423288129,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
07.02.2015, 06:48:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5A73F',1,1,1423288131,0,0,8000,12,'54D5A73F',1423288131,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
07.02.2015, 06:48:52, UPDATE execute_data SET tstamp=1423288132,exectime=1423288129,answertime=1423288132,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A73F' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 06:48:52, UPDATE execute_data SET tstamp=1423288132,exectime=1423288131,answertime=1423288132,endcalltime=1423288132,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='54D5A73F' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 06:48:53, UPDATE execute_data SET tstamp=1423288133,exectime=1423288129,answertime=1423288132,endcalltime=1423288133,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A73F' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 06:49:09, UPDATE alarm_data SET tstamp=1423288148,alrstatus=2,endtime=1423288148,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5A73F'
07.02.2015, 06:49:09, UPDATE alarm_status SET reference='54D5A73F',tstamp='1423288148',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 09:20:09, 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','54D5CAB8',1423297209,1423297209,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 09:20:09, UPDATE alarm_data SET msg='ZLT:RZK_H00U___FW_SM_DMIN;MIN-Druckw„chter St”rung;',dispmsg1='ZLT:RZK_H00U___F',dispmsg2='_DMIN;MIN-Druckw',tstamp=1423297209 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8'
07.02.2015, 09:20:09, UPDATE alarm_status SET reference='54D5CAB8',tstamp=1423297209,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 09:20:10, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5CAB8',0,1,1423297209,0,0,8010,50,'54D5CAB8',1423297209,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 09:20:10, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5CAB8',1,1,1423297209,0,0,8010,50,'54D5CAB8',1423297209,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 09:20:10, UPDATE execute_data SET tstamp=1423297210,exectime=1423297209,answertime=1423297210,endcalltime=1423297210,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 09:20:11, UPDATE execute_data SET tstamp=1423297210,exectime=1423297209,answertime=1423297210,endcalltime=1423297210,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 09:20: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','54D5CAB8',0,2,1423297211,0,0,8010,50,'54D5CAB8',1423297211,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 09:20: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','54D5CAB8',4,1,1423297210,0,0,8010,50,'54D5CAB8',1423297210,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 09:20: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','54D5CAB8',2,1,1423297211,0,0,8010,50,'54D5CAB8',1423297211,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 09:20:19, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5CAB8',3,1,1423297218,0,0,8010,50,'54D5CAB8',1423297218,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 09:20:20, UPDATE execute_data SET tstamp=1423297219,execstatus=8,exectime=1423297216, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 09:20:36, UPDATE execute_data SET tstamp=1423297236,exectime=1423297218,answertime=1423297236,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 09:20:38, UPDATE execute_data SET tstamp=1423297238,exectime=1423297218,answertime=1423297236,endcalltime=1423297238,confirmtime=0,callduration=2,execstatus=1,substatus='',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 09:20:54, UPDATE execute_data SET tstamp=1423297254,exectime=1423297211,answertime=1423297254,endcalltime=1423297254,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 09:20:54, UPDATE execute_data SET tstamp=1423297254,exectime=1423297211,answertime=1423297254,endcalltime=1423297254,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='54D5CAB8' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 09:20:57, UPDATE alarm_data SET tstamp=1423297257,alrstatus=2,endtime=1423297257,duration=48, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CAB8'
07.02.2015, 09:20:57, UPDATE alarm_status SET reference='54D5CAB8',tstamp='1423297257',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 09:25:09, 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','54D5CBE4',1423297508,1423297508,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 09:25:09, UPDATE alarm_data SET msg='ZLT:RZK_H08____WW_SM_____;St”rung Warmwasserbereitung;',dispmsg1='ZLT:RZK_H08____W',dispmsg2='_____;St”rung Wa',tstamp=1423297508 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4'
07.02.2015, 09:25:09, UPDATE alarm_status SET reference='54D5CBE4',tstamp=1423297508,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 09:25: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','54D5CBE4',4,1,1423297510,0,0,8010,50,'54D5CBE4',1423297510,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 09:25: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','54D5CBE4',0,1,1423297512,0,0,8010,50,'54D5CBE4',1423297512,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 09:25: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','54D5CBE4',1,1,1423297513,0,0,8010,50,'54D5CBE4',1423297513,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 09:25: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','54D5CBE4',2,1,1423297513,0,0,8010,50,'54D5CBE4',1423297513,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 09:25: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','54D5CBE4',3,1,1423297513,0,0,8010,50,'54D5CBE4',1423297513,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 09:25:13, UPDATE execute_data SET tstamp=1423297512,exectime=1423297512,answertime=1423297512,endcalltime=1423297512,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=6,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 09:25: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','54D5CBE4',0,2,1423297513,0,0,8010,50,'54D5CBE4',1423297513,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 09:25:14, UPDATE execute_data SET tstamp=1423297513,exectime=1423297513,answertime=1423297513,endcalltime=1423297513,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 09:25:20, UPDATE execute_data SET tstamp=1423297520,execstatus=8,exectime=1423297515, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 09:25:25, UPDATE execute_data SET tstamp=1423297524,exectime=1423297513,answertime=1423297524,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 09:25:26, UPDATE execute_data SET tstamp=1423297526,exectime=1423297513,answertime=1423297524,endcalltime=1423297526,confirmtime=0,callduration=2,execstatus=1,substatus='',answerdby='',linenumber=8,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 09:25:56, UPDATE execute_data SET tstamp=1423297556,exectime=1423297513,answertime=1423297556,endcalltime=1423297556,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='54D5CBE4' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 09:25:57, UPDATE execute_data SET tstamp=1423297556,exectime=1423297513,answertime=1423297556,endcalltime=1423297556,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='54D5CBE4' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 09:25:59, UPDATE alarm_data SET tstamp=1423297558,alrstatus=2,endtime=1423297558,duration=50, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5CBE4'
07.02.2015, 09:25:59, UPDATE alarm_status SET reference='54D5CBE4',tstamp='1423297558',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 10:00:48, 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','54D5D440',1423299648,1423299648,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 10:00:49, UPDATE alarm_data SET msg='ZLT:RZK_H00U___FW_SM_DMIN;MIN-Druckw„chter St”rung;',dispmsg1='ZLT:RZK_H00U___F',dispmsg2='_DMIN;MIN-Druckw',tstamp=1423299648 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5D440'
07.02.2015, 10:00:49, UPDATE alarm_status SET reference='54D5D440',tstamp=1423299648,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 10:00:50, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5D440',4,1,1423299650,0,0,8010,50,'54D5D440',1423299650,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 10:00:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5D440',0,1,1423299652,0,0,8010,50,'54D5D440',1423299652,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 10:00:53, UPDATE execute_data SET tstamp=1423299653,exectime=1423299652,answertime=1423299653,endcalltime=1423299653,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5D440' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 10:00: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','54D5D440',1,1,1423299653,0,0,8010,50,'54D5D440',1423299653,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 10:00: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','54D5D440',0,2,1423299653,0,0,8010,50,'54D5D440',1423299653,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 10:00: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','54D5D440',2,1,1423299654,0,0,8010,50,'54D5D440',1423299654,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 10:00:54, UPDATE execute_data SET tstamp=1423299654,exectime=1423299653,answertime=1423299654,endcalltime=1423299654,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5D440' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 10:00:55, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5D440',3,1,1423299655,0,0,8010,50,'54D5D440',1423299655,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 10:01:00, UPDATE execute_data SET tstamp=1423299659,execstatus=8,exectime=1423299655, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5D440' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 10:01:37, UPDATE execute_data SET tstamp=1423299697,exectime=1423299653,answertime=1423299697,endcalltime=1423299697,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='54D5D440' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 10:01:37, UPDATE execute_data SET tstamp=1423299697,exectime=1423299654,answertime=1423299697,endcalltime=1423299697,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='54D5D440' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 10:01:41, UPDATE execute_data SET tstamp=1423299701,exectime=1423299655,answertime=1423299701,endcalltime=1423299701,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='54D5D440' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 10:01:43, UPDATE alarm_data SET tstamp=1423299702,alrstatus=2,endtime=1423299702,duration=54, voicefile='d:\dbv1\.\v8010_1.wav',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5D440'
07.02.2015, 10:01:43, UPDATE alarm_status SET reference='54D5D440',tstamp='1423299702',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 10:43:45, 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','54D5DE51',1423302225,1423302225,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 10:43:45, UPDATE alarm_data SET msg='ZLT:RZK_H00U___FW_SM_DMIN;MIN-Druckw„chter St”rung;',dispmsg1='ZLT:RZK_H00U___F',dispmsg2='_DMIN;MIN-Druckw',tstamp=1423302225 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51'
07.02.2015, 10:43:46, UPDATE alarm_status SET reference='54D5DE51',tstamp=1423302225,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 10:43: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','54D5DE51',0,1,1423302227,0,0,8010,50,'54D5DE51',1423302227,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 10:43: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','54D5DE51',4,1,1423302227,0,0,8010,50,'54D5DE51',1423302227,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 10:43:47, UPDATE execute_data SET tstamp=1423302227,exectime=1423302227,answertime=1423302227,endcalltime=1423302227,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 10:43: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','54D5DE51',0,2,1423302228,0,0,8010,50,'54D5DE51',1423302228,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 10:43:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5DE51',1,1,1423302231,0,0,8010,50,'54D5DE51',1423302231,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 10:43:52, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5DE51',2,1,1423302231,0,0,8010,50,'54D5DE51',1423302231,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 10:43:52, UPDATE execute_data SET tstamp=1423302232,exectime=1423302231,answertime=1423302232,endcalltime=1423302232,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 10:43:52, UPDATE execute_data SET tstamp=1423302232,execstatus=8,exectime=1423302228, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 10:43:53, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5DE51',3,1,1423302232,0,0,8010,50,'54D5DE51',1423302232,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 10:44:31, UPDATE execute_data SET tstamp=1423302271,exectime=1423302228,answertime=1423302271,endcalltime=1423302271,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='54D5DE51' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 10:44:33, UPDATE execute_data SET tstamp=1423302272,exectime=1423302232,answertime=1423302272,endcalltime=1423302272,confirmtime=0,callduration=0,execstatus=2,substatus='[0x91] User busy',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 10:44:35, UPDATE execute_data SET tstamp=1423302275,exectime=1423302231,answertime=1423302275,endcalltime=1423302275,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='54D5DE51' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 10:44:37, UPDATE alarm_data SET tstamp=1423302277,alrstatus=2,endtime=1423302277,duration=52, voicefile='d:\dbv1\.\v8010_1.wav',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5DE51'
07.02.2015, 10:44:38, UPDATE alarm_status SET reference='54D5DE51',tstamp='1423302277',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 11:16: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','54D5E60C',1423304204,1423304204,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 11:16:44, UPDATE alarm_data SET msg='ZLT:RZK_H00U___FW_SM_DMIN;MIN-Druckw„chter St”rung;',dispmsg1='ZLT:RZK_H00U___F',dispmsg2='_DMIN;MIN-Druckw',tstamp=1423304204 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C'
07.02.2015, 11:16:45, UPDATE alarm_status SET reference='54D5E60C',tstamp=1423304204,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 11:16: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','54D5E60C',4,1,1423304206,0,0,8010,50,'54D5E60C',1423304206,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 11:16: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','54D5E60C',0,1,1423304209,0,0,8010,50,'54D5E60C',1423304209,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 11:16:50, UPDATE execute_data SET tstamp=1423304209,exectime=1423304209,answertime=1423304209,endcalltime=1423304209,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 11:16:50, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5E60C',0,2,1423304210,0,0,8010,50,'54D5E60C',1423304210,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 11:16:50, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5E60C',1,1,1423304210,0,0,8010,50,'54D5E60C',1423304210,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 11:16:50, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5E60C',2,1,1423304210,0,0,8010,50,'54D5E60C',1423304210,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 11:16:50, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D5E60C',3,1,1423304210,0,0,8010,50,'54D5E60C',1423304210,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 11:16:51, UPDATE execute_data SET tstamp=1423304210,exectime=1423304210,answertime=1423304210,endcalltime=1423304210,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 11:16:56, UPDATE execute_data SET tstamp=1423304215,execstatus=8,exectime=1423304211, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 11:17:17, UPDATE execute_data SET tstamp=1423304237,exectime=1423304210,answertime=1423304237,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 11:17:19, UPDATE execute_data SET tstamp=1423304239,exectime=1423304210,answertime=1423304237,endcalltime=1423304239,confirmtime=0,callduration=2,execstatus=1,substatus='',answerdby='',linenumber=5,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 11:17:33, UPDATE execute_data SET tstamp=1423304253,exectime=1423304210,answertime=1423304253,endcalltime=1423304253,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='54D5E60C' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 11:17:34, UPDATE execute_data SET tstamp=1423304253,exectime=1423304210,answertime=1423304253,endcalltime=1423304253,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='54D5E60C' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 11:17:36, UPDATE alarm_data SET tstamp=1423304256,alrstatus=2,endtime=1423304256,duration=52, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5E60C'
07.02.2015, 11:17:36, UPDATE alarm_status SET reference='54D5E60C',tstamp='1423304256',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 12:09: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','54D5F273',1423307379,1423307379,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 12:09:39, UPDATE alarm_data SET msg='ZLT:RZK_H08____WW_SM_ZIRK;St”rung Zirkulationstemperatur;',dispmsg1='ZLT:RZK_H08____W',dispmsg2='_ZIRK;St”rung Zi',tstamp=1423307379 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273'
07.02.2015, 12:09:40, UPDATE alarm_status SET reference='54D5F273',tstamp=1423307379,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 12:09: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','54D5F273',4,1,1423307380,0,0,8010,50,'54D5F273',1423307380,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
07.02.2015, 12:09:43, 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','54D5F273',0,1,1423307382,0,0,8010,50,'54D5F273',1423307382,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 12:09:43, UPDATE execute_data SET tstamp=1423307383,exectime=1423307382,answertime=1423307383,endcalltime=1423307383,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 12:09: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','54D5F273',0,2,1423307383,0,0,8010,50,'54D5F273',1423307383,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
07.02.2015, 12:09: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','54D5F273',1,1,1423307384,0,0,8010,50,'54D5F273',1423307384,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
07.02.2015, 12:09: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','54D5F273',2,1,1423307385,0,0,8010,50,'54D5F273',1423307385,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
07.02.2015, 12:09:45, UPDATE execute_data SET tstamp=1423307384,exectime=1423307384,answertime=1423307384,endcalltime=1423307384,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 12:09: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','54D5F273',3,1,1423307385,0,0,8010,50,'54D5F273',1423307385,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
07.02.2015, 12:09:50, UPDATE execute_data SET tstamp=1423307390,execstatus=8,exectime=1423307386, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273' AND dbfentry=4 AND dbfentrypos=1
07.02.2015, 12:10:27, UPDATE execute_data SET tstamp=1423307427,exectime=1423307383,answertime=1423307427,endcalltime=1423307427,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='54D5F273' AND dbfentry=0 AND dbfentrypos=2
07.02.2015, 12:10:28, UPDATE execute_data SET tstamp=1423307428,exectime=1423307385,answertime=1423307428,endcalltime=1423307428,confirmtime=0,callduration=0,execstatus=0,substatus='[0x90] Normal clearing',answerdby='',linenumber=4,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 12:10:32, UPDATE execute_data SET tstamp=1423307432,exectime=1423307385,answertime=1423307431,endcalltime=1423307432,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='54D5F273' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 12:10:33, UPDATE alarm_data SET tstamp=1423307433,alrstatus=2,endtime=1423307433,duration=54, voicefile='d:\dbv1\.\v8010_1.wav',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D5F273'
07.02.2015, 12:10:33, UPDATE alarm_status SET reference='54D5F273',tstamp='1423307433',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
07.02.2015, 15:23:23, 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','54D61FDB',1423319003,1423319003,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 15:23:23, UPDATE alarm_data SET msg='SOFT-P 1',dispmsg1='NORMAL SOFT-P 1',dispmsg2='NORMAL SOFT-P 1',tstamp=1423319003 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D61FDB'
07.02.2015, 15:23:23, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423319003 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D61FDB'
07.02.2015, 15:23:23, UPDATE alarm_status SET reference='54D61FDB',tstamp=1423319003,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 15:23:26, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D61FDB',0,1,1423319006,0,0,8000,10,'54D61FDB',1423319006,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
07.02.2015, 15:23:26, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D61FDB',1,1,1423319006,0,0,8000,10,'54D61FDB',1423319006,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
07.02.2015, 15:23:27, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D61FDB',2,1,1423319007,0,0,8000,10,'54D61FDB',1423319007,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
07.02.2015, 15:23:28, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D61FDB',3,1,1423319008,0,0,8000,10,'54D61FDB',1423319008,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
07.02.2015, 15:23:39, UPDATE execute_data SET tstamp=1423319019,exectime=1423319006,answertime=1423319018,endcalltime=1423319019,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='54D61FDB' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 15:23:39, UPDATE execute_data SET tstamp=1423319018,exectime=1423319007,answertime=1423319018,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D61FDB' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:23:39, UPDATE execute_data SET tstamp=1423319019,exectime=1423319008,answertime=1423319018,endcalltime=1423319019,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='54D61FDB' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 15:23:39, UPDATE execute_data SET tstamp=1423319019,exectime=1423319006,answertime=1423319019,endcalltime=1423319019,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='54D61FDB' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 15:23:48, UPDATE execute_data SET tstamp=1423319028,exectime=1423319007,answertime=1423319018,endcalltime=1423319028,confirmtime=0,callduration=10,execstatus=1,substatus='8633',answerdby='8633',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D61FDB' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:23:55, UPDATE alarm_data SET tstamp=1423319035,alrstatus=2,endtime=1423319035,duration=32, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D61FDB'
07.02.2015, 15:23:55, UPDATE alarm_status SET reference='54D61FDB',tstamp='1423319035',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 15:24:23, 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','54D62017',1423319063,1423319063,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 15:24:23, UPDATE alarm_data SET msg='SOFT-P 1',dispmsg1='NORMAL SOFT-P 1',dispmsg2='NORMAL SOFT-P 1',tstamp=1423319063 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62017'
07.02.2015, 15:24:24, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423319063 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62017'
07.02.2015, 15:24:24, UPDATE alarm_status SET reference='54D62017',tstamp=1423319063,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 15:24: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','54D62017',0,1,1423319063,0,0,8000,10,'54D62017',1423319063,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
07.02.2015, 15:24: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','54D62017',1,1,1423319069,0,0,8000,10,'54D62017',1423319069,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
07.02.2015, 15:24: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','54D62017',2,1,1423319069,0,0,8000,10,'54D62017',1423319069,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
07.02.2015, 15:24: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','54D62017',3,1,1423319069,0,0,8000,10,'54D62017',1423319069,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
07.02.2015, 15:24:37, UPDATE execute_data SET tstamp=1423319077,exectime=1423319069,answertime=1423319077,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62017' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:24:38, UPDATE execute_data SET tstamp=1423319077,exectime=1423319063,answertime=1423319077,endcalltime=1423319077,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='54D62017' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 15:24:38, UPDATE execute_data SET tstamp=1423319077,exectime=1423319069,answertime=1423319077,endcalltime=1423319077,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='54D62017' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 15:24:38, UPDATE execute_data SET tstamp=1423319077,exectime=1423319069,answertime=1423319077,endcalltime=1423319077,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='54D62017' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 15:24:38, UPDATE execute_data SET tstamp=1423319078,exectime=1423319069,answertime=1423319077,endcalltime=1423319078,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62017' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:24:55, UPDATE alarm_data SET tstamp=1423319095,alrstatus=2,endtime=1423319095,duration=32, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62017'
07.02.2015, 15:24:55, UPDATE alarm_status SET reference='54D62017',tstamp='1423319095',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 15:25:23, 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','54D62053',1423319123,1423319123,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 15:25:23, UPDATE alarm_data SET msg='SOFT-P 1',dispmsg1='NORMAL SOFT-P 1',dispmsg2='NORMAL SOFT-P 1',tstamp=1423319123 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62053'
07.02.2015, 15:25:24, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423319123 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62053'
07.02.2015, 15:25:24, UPDATE alarm_status SET reference='54D62053',tstamp=1423319123,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 15:25: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','54D62053',0,1,1423319129,0,0,8000,10,'54D62053',1423319129,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
07.02.2015, 15:25: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','54D62053',1,1,1423319129,0,0,8000,10,'54D62053',1423319129,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
07.02.2015, 15:25: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','54D62053',2,1,1423319129,0,0,8000,10,'54D62053',1423319129,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
07.02.2015, 15:25: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','54D62053',3,1,1423319129,0,0,8000,10,'54D62053',1423319129,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
07.02.2015, 15:25:35, UPDATE execute_data SET tstamp=1423319135,exectime=1423319129,answertime=1423319135,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62053' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:25:35, UPDATE execute_data SET tstamp=1423319135,exectime=1423319129,answertime=1423319135,endcalltime=1423319135,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='54D62053' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 15:25:35, UPDATE execute_data SET tstamp=1423319135,exectime=1423319129,answertime=1423319135,endcalltime=1423319135,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='54D62053' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 15:25:36, UPDATE execute_data SET tstamp=1423319135,exectime=1423319129,answertime=1423319135,endcalltime=1423319135,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='54D62053' AND dbfentry=3 AND dbfentrypos=1
07.02.2015, 15:25:36, UPDATE execute_data SET tstamp=1423319135,exectime=1423319129,answertime=1423319135,endcalltime=1423319135,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62053' AND dbfentry=2 AND dbfentrypos=1
07.02.2015, 15:25:49, UPDATE alarm_data SET tstamp=1423319149,alrstatus=2,endtime=1423319149,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D62053'
07.02.2015, 15:25:49, UPDATE alarm_status SET reference='54D62053',tstamp='1423319149',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 23:35:08, 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','54D6931C',1423348508,1423348508,06,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
07.02.2015, 23:35:09, UPDATE alarm_data SET msg='W 231',dispmsg1='NORMAL W 231',dispmsg2='NORMAL W 231',tstamp=1423348508 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6931C'
07.02.2015, 23:35:09, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1423348508 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6931C'
07.02.2015, 23:35:09, UPDATE alarm_status SET reference='54D6931C',tstamp=1423348508,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
07.02.2015, 23:35: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','54D6931C',0,1,1423348512,0,0,8000,12,'54D6931C',1423348512,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
07.02.2015, 23:35: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','54D6931C',1,1,1423348512,0,0,8000,12,'54D6931C',1423348512,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
07.02.2015, 23:35:18, UPDATE execute_data SET tstamp=1423348518,exectime=1423348512,answertime=1423348518,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6931C' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 23:35:19, UPDATE execute_data SET tstamp=1423348518,exectime=1423348512,answertime=1423348518,endcalltime=1423348518,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='54D6931C' AND dbfentry=1 AND dbfentrypos=1
07.02.2015, 23:35:19, UPDATE execute_data SET tstamp=1423348519,exectime=1423348512,answertime=1423348518,endcalltime=1423348519,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=3,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6931C' AND dbfentry=0 AND dbfentrypos=1
07.02.2015, 23:35:34, UPDATE alarm_data SET tstamp=1423348533,alrstatus=2,endtime=1423348533,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6931C'
07.02.2015, 23:35:34, UPDATE alarm_status SET reference='54D6931C',tstamp='1423348533',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
