08.02.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
08.02.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1362448800  Code:0
08.02.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1362448800  Code:0
08.02.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1362448800  Code:0
08.02.2015, 03:00:01, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1362448800  Code:0
08.02.2015, 03:00:01, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1362448801  Code:0
08.02.2015, 03:00:01, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1362448801  Code:0
08.02.2015, 03:00:01, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1418284801  Code:0
08.02.2015, 03:00:01, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1418284801  Code:0
08.02.2015, 03:00:01, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1418284801  Code:0
08.02.2015, 03:00:01, Delete records from event database nv_event which are older then 720 days
08.02.2015, 03:15:13, INSERT INTO alarm_data (id,servername,reference,tstamp,starttime,week,alrnumber,alrname,grpnumber,grpname,type,alrstatus,icon,confirmation,priority,launchtype,launchedby,srcalrnumber,alrinnumber,replication,locking) VALUES (NEXTVAL('alarm_data_id_seq'),'WINDOWS-VY7ULCW','54D6C6B0',1423361712,1423361712,06,8010,'ZLT',50,'Technik',0,1,3,0,0,0,'ESPA',0,0,0,1)
08.02.2015, 03:15:13, UPDATE alarm_data SET msg='ZLT:RZK_E02_EG_UV_SM_SS_C;Summenst”rung Verteiler E0 BTC;',dispmsg1='ZLT:RZK_E02_EG_U',dispmsg2='_SS_C;Summenst”r',tstamp=1423361713 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6C6B0'
08.02.2015, 03:15:13, UPDATE alarm_status SET reference='54D6C6B0',tstamp=1423361713,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
08.02.2015, 03:15: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','54D6C6B0',4,1,1423361714,0,0,8010,50,'54D6C6B0',1423361714,7,41,'Haustechnik Hotline SMS','06765613901','SMS','','','','4d208335-3318-450e-a2f0-1a3f163a174d',1)
08.02.2015, 03:15: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','54D6C6B0',0,1,1423361714,0,0,8010,50,'54D6C6B0',1423361714,6,69,'Haustechnik','8555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
08.02.2015, 03:15: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','54D6C6B0',1,1,1423361714,0,0,8010,50,'54D6C6B0',1423361714,6,45,'IT-Haustechnik','8556','INT','','','','778fa03c-e0c4-4a17-9bc2-d608654f41eb',1)
08.02.2015, 03:15:15, UPDATE execute_data SET tstamp=1423361715,exectime=1423361714,answertime=1423361715,endcalltime=1423361715,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='54D6C6B0' AND dbfentry=0 AND dbfentrypos=1
08.02.2015, 03:15:15, UPDATE execute_data SET tstamp=1423361715,exectime=1423361714,answertime=1423361715,endcalltime=1423361715,confirmtime=0,callduration=0,execstatus=3,substatus='[0x9B] Destination out of order',answerdby='',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6C6B0' AND dbfentry=1 AND dbfentrypos=1
08.02.2015, 03:15:16, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D6C6B0',0,2,1423361716,0,0,8010,50,'54D6C6B0',1423361716,6,69,'Haustechnik','555','INT','','','','889fb532-e671-482e-8b7b-ca502ed17601',1)
08.02.2015, 03:15: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','54D6C6B0',2,1,1423361719,0,0,8010,50,'54D6C6B0',1423361719,6,46,'Haustechnik allgemein','8557','INT','','','','9724a334-9339-4159-922b-82486ceebb8d',1)
08.02.2015, 03:15:21, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D6C6B0',3,1,1423361720,0,0,8010,50,'54D6C6B0',1423361720,6,32,'Haustechnik_Hotline','06765613901','GSM','','','','e70738e7-545c-4b05-9de4-26e0f3bce3e8',1)
08.02.2015, 03:15:23, UPDATE execute_data SET tstamp=1423361723,execstatus=8,exectime=1423361719, specconf='' WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6C6B0' AND dbfentry=4 AND dbfentrypos=1
08.02.2015, 03:15:35, UPDATE execute_data SET tstamp=1423361735,exectime=1423361720,answertime=1423361735,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='54D6C6B0' AND dbfentry=3 AND dbfentrypos=1
08.02.2015, 03:15:37, UPDATE execute_data SET tstamp=1423361737,exectime=1423361720,answertime=1423361735,endcalltime=1423361737,confirmtime=0,callduration=2,execstatus=1,substatus='',answerdby='',linenumber=6,specconf='',callingparty='191897',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6C6B0' AND dbfentry=3 AND dbfentrypos=1
08.02.2015, 03:15:59, UPDATE execute_data SET tstamp=1423361759,exectime=1423361716,answertime=1423361759,endcalltime=1423361759,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='54D6C6B0' AND dbfentry=0 AND dbfentrypos=2
08.02.2015, 03:16:03, UPDATE execute_data SET tstamp=1423361763,exectime=1423361719,answertime=1423361763,endcalltime=1423361763,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='54D6C6B0' AND dbfentry=2 AND dbfentrypos=1
08.02.2015, 03:16:05, UPDATE alarm_data SET tstamp=1423361764,alrstatus=2,endtime=1423361764,duration=52, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D6C6B0'
08.02.2015, 03:16:05, UPDATE alarm_status SET reference='54D6C6B0',tstamp='1423361764',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8010
08.02.2015, 10:27: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','54D72BEB',1423387627,1423387627,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
08.02.2015, 10:27:08, UPDATE alarm_data SET msg='PHYSIO 3',dispmsg1='NORMAL PHYSIO 3',dispmsg2='NORMAL PHYSIO 3',tstamp=1423387627 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72BEB'
08.02.2015, 10:27:08, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423387627 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72BEB'
08.02.2015, 10:27:08, UPDATE alarm_status SET reference='54D72BEB',tstamp=1423387627,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
08.02.2015, 10:27: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','54D72BEB',0,1,1423387628,0,0,8000,10,'54D72BEB',1423387628,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
08.02.2015, 10:27: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','54D72BEB',1,1,1423387630,0,0,8000,10,'54D72BEB',1423387630,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
08.02.2015, 10:27: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','54D72BEB',2,1,1423387630,0,0,8000,10,'54D72BEB',1423387630,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
08.02.2015, 10:27: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','54D72BEB',3,1,1423387632,0,0,8000,10,'54D72BEB',1423387632,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
08.02.2015, 10:27:14, UPDATE execute_data SET tstamp=1423387634,exectime=1423387630,answertime=1423387634,endcalltime=1423387634,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='54D72BEB' AND dbfentry=1 AND dbfentrypos=1
08.02.2015, 10:27:14, UPDATE execute_data SET tstamp=1423387634,exectime=1423387630,answertime=1423387634,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='54D72BEB' AND dbfentry=2 AND dbfentrypos=1
08.02.2015, 10:27:15, UPDATE execute_data SET tstamp=1423387634,exectime=1423387632,answertime=1423387634,endcalltime=1423387634,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='54D72BEB' AND dbfentry=3 AND dbfentrypos=1
08.02.2015, 10:27:15, UPDATE execute_data SET tstamp=1423387634,exectime=1423387628,answertime=1423387634,endcalltime=1423387634,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='54D72BEB' AND dbfentry=0 AND dbfentrypos=1
08.02.2015, 10:27:19, UPDATE execute_data SET tstamp=1423387639,exectime=1423387630,answertime=1423387634,endcalltime=1423387639,confirmtime=0,callduration=5,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72BEB' AND dbfentry=2 AND dbfentrypos=1
08.02.2015, 10:27:29, UPDATE alarm_data SET tstamp=1423387649,alrstatus=2,endtime=1423387649,duration=22, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72BEB'
08.02.2015, 10:27:29, UPDATE alarm_status SET reference='54D72BEB',tstamp='1423387649',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
08.02.2015, 10:28: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','54D72C27',1423387687,1423387687,06,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
08.02.2015, 10:28:08, UPDATE alarm_data SET msg='PHYSIO 3',dispmsg1='NORMAL PHYSIO 3',dispmsg2='NORMAL PHYSIO 3',tstamp=1423387687 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72C27'
08.02.2015, 10:28:08, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1423387687 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72C27'
08.02.2015, 10:28:08, UPDATE alarm_status SET reference='54D72C27',tstamp=1423387687,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
08.02.2015, 10:28: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','54D72C27',0,1,1423387690,0,0,8000,10,'54D72C27',1423387690,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
08.02.2015, 10:28: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','54D72C27',1,1,1423387692,0,0,8000,10,'54D72C27',1423387692,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
08.02.2015, 10:28: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','54D72C27',2,1,1423387692,0,0,8000,10,'54D72C27',1423387692,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
08.02.2015, 10:28:16, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54D72C27',3,1,1423387695,0,0,8000,10,'54D72C27',1423387695,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
08.02.2015, 10:28:18, UPDATE execute_data SET tstamp=1423387698,exectime=1423387690,answertime=1423387698,endcalltime=1423387698,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='54D72C27' AND dbfentry=0 AND dbfentrypos=1
08.02.2015, 10:28:18, UPDATE execute_data SET tstamp=1423387698,exectime=1423387692,answertime=1423387698,endcalltime=1423387698,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='54D72C27' AND dbfentry=1 AND dbfentrypos=1
08.02.2015, 10:28:18, UPDATE execute_data SET tstamp=1423387698,exectime=1423387692,answertime=1423387698,endcalltime=1423387698,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='54D72C27' AND dbfentry=2 AND dbfentrypos=1
08.02.2015, 10:28:18, UPDATE execute_data SET tstamp=1423387698,exectime=1423387695,answertime=1423387697,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8634',answerdby='8634',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72C27' AND dbfentry=3 AND dbfentrypos=1
08.02.2015, 10:28:19, UPDATE execute_data SET tstamp=1423387698,exectime=1423387695,answertime=1423387697,endcalltime=1423387698,confirmtime=0,callduration=1,execstatus=1,substatus='8634',answerdby='8634',linenumber=7,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72C27' AND dbfentry=3 AND dbfentrypos=1
08.02.2015, 10:28:33, UPDATE alarm_data SET tstamp=1423387713,alrstatus=2,endtime=1423387713,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54D72C27'
08.02.2015, 10:28:34, UPDATE alarm_status SET reference='54D72C27',tstamp='1423387713',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
