17.01.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
17.01.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1360548000  Code:0
17.01.2015, 03:00:00, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1416384000  Code:0
17.01.2015, 03:00:00, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1416384000  Code:0
17.01.2015, 03:00:00, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1416384000  Code:0
17.01.2015, 03:00:00, Delete records from event database nv_event which are older then 720 days
17.01.2015, 07:42:57, 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','54BA0471',1421476977,1421476977,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
17.01.2015, 07:42:57, UPDATE alarm_data SET msg='W 132',dispmsg1='NORMAL W 132',dispmsg2='NORMAL W 132',tstamp=1421476977 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA0471'
17.01.2015, 07:42:57, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421476977 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA0471'
17.01.2015, 07:42:57, UPDATE alarm_status SET reference='54BA0471',tstamp=1421476977,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
17.01.2015, 07:43: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','54BA0471',0,1,1421476981,0,0,8000,10,'54BA0471',1421476981,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
17.01.2015, 07:43: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','54BA0471',1,1,1421476981,0,0,8000,10,'54BA0471',1421476981,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
17.01.2015, 07:43:02, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54BA0471',2,1,1421476982,0,0,8000,10,'54BA0471',1421476982,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
17.01.2015, 07:43:02, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54BA0471',3,1,1421476982,0,0,8000,10,'54BA0471',1421476982,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
17.01.2015, 07:43:08, UPDATE execute_data SET tstamp=1421476988,exectime=1421476981,answertime=1421476988,endcalltime=1421476988,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='54BA0471' AND dbfentry=0 AND dbfentrypos=1
17.01.2015, 07:43:08, UPDATE execute_data SET tstamp=1421476988,exectime=1421476982,answertime=1421476988,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='54BA0471' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 07:43:09, UPDATE execute_data SET tstamp=1421476988,exectime=1421476982,answertime=1421476988,endcalltime=1421476988,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='54BA0471' AND dbfentry=3 AND dbfentrypos=1
17.01.2015, 07:43:09, UPDATE execute_data SET tstamp=1421476988,exectime=1421476981,answertime=1421476988,endcalltime=1421476988,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='54BA0471' AND dbfentry=1 AND dbfentrypos=1
17.01.2015, 07:43:09, UPDATE execute_data SET tstamp=1421476989,exectime=1421476982,answertime=1421476988,endcalltime=1421476989,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA0471' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 07:43:23, UPDATE alarm_data SET tstamp=1421477003,alrstatus=2,endtime=1421477003,duration=26, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA0471'
17.01.2015, 07:43:23, UPDATE alarm_status SET reference='54BA0471',tstamp='1421477003',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
17.01.2015, 12:05:34, 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','54BA41FD',1421492734,1421492734,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
17.01.2015, 12:05:34, UPDATE alarm_data SET msg='W 126',dispmsg1='NORMAL W 126',dispmsg2='NORMAL W 126',tstamp=1421492734 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA41FD'
17.01.2015, 12:05:34, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421492734 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA41FD'
17.01.2015, 12:05:34, UPDATE alarm_status SET reference='54BA41FD',tstamp=1421492734,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
17.01.2015, 12:05:38, 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','54BA41FD',0,1,1421492737,0,0,8000,10,'54BA41FD',1421492737,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
17.01.2015, 12:05:38, 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','54BA41FD',1,1,1421492737,0,0,8000,10,'54BA41FD',1421492737,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
17.01.2015, 12:05:38, 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','54BA41FD',2,1,1421492737,0,0,8000,10,'54BA41FD',1421492737,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
17.01.2015, 12:05:38, 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','54BA41FD',3,1,1421492737,0,0,8000,10,'54BA41FD',1421492737,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
17.01.2015, 12:05:43, UPDATE execute_data SET tstamp=1421492743,exectime=1421492737,answertime=1421492743,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='54BA41FD' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 12:05:43, UPDATE execute_data SET tstamp=1421492743,exectime=1421492737,answertime=1421492743,endcalltime=1421492743,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='54BA41FD' AND dbfentry=0 AND dbfentrypos=1
17.01.2015, 12:05:43, UPDATE execute_data SET tstamp=1421492743,exectime=1421492737,answertime=1421492743,endcalltime=1421492743,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='54BA41FD' AND dbfentry=1 AND dbfentrypos=1
17.01.2015, 12:05:43, UPDATE execute_data SET tstamp=1421492743,exectime=1421492737,answertime=1421492743,endcalltime=1421492743,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='54BA41FD' AND dbfentry=3 AND dbfentrypos=1
17.01.2015, 12:05:45, UPDATE execute_data SET tstamp=1421492744,exectime=1421492737,answertime=1421492743,endcalltime=1421492744,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA41FD' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 12:06:00, UPDATE alarm_data SET tstamp=1421492759,alrstatus=2,endtime=1421492759,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA41FD'
17.01.2015, 12:06:00, UPDATE alarm_status SET reference='54BA41FD',tstamp='1421492759',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
17.01.2015, 12:06:34, 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','54BA4239',1421492794,1421492794,03,8000,'NORMAL',10,'Pflege_1_OG',0,1,6,0,0,0,'ESPA',0,0,0,1)
17.01.2015, 12:06:34, UPDATE alarm_data SET msg='W 126',dispmsg1='NORMAL W 126',dispmsg2='NORMAL W 126',tstamp=1421492794 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA4239'
17.01.2015, 12:06:34, UPDATE alarm_data SET weekplan='8000',weekaction='10 (GRP)',tstamp=1421492794 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA4239'
17.01.2015, 12:06:34, UPDATE alarm_status SET reference='54BA4239',tstamp=1421492794,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
17.01.2015, 12:06: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','54BA4239',0,1,1421492794,0,0,8000,10,'54BA4239',1421492794,6,28,'Pflege OG 2 / Mobil 1','8631','INT','','','','a4170e52-450d-4651-8692-04fcc3683349',1)
17.01.2015, 12:06: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','54BA4239',1,1,1421492794,0,0,8000,10,'54BA4239',1421492794,6,29,'Pflege OG 2 / Mobil 2','8632','INT','','','','48235d69-21ba-4de4-9a3a-aaa924e4aff9',1)
17.01.2015, 12:06:36, 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','54BA4239',2,1,1421492795,0,0,8000,10,'54BA4239',1421492795,6,34,'Pflege OG 1 / Mobil 1','8633','INT','','','','548553f0-3386-4af7-9e93-15f0cba30639',1)
17.01.2015, 12:06:39, UPDATE execute_data SET tstamp=1421492799,exectime=1421492795,answertime=1421492799,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='54BA4239' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 12:06:40, UPDATE execute_data SET tstamp=1421492799,exectime=1421492794,answertime=1421492799,endcalltime=1421492799,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='54BA4239' AND dbfentry=0 AND dbfentrypos=1
17.01.2015, 12:06:40, UPDATE execute_data SET tstamp=1421492799,exectime=1421492794,answertime=1421492799,endcalltime=1421492799,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='54BA4239' AND dbfentry=1 AND dbfentrypos=1
17.01.2015, 12:06:40, UPDATE execute_data SET tstamp=1421492800,exectime=1421492795,answertime=1421492799,endcalltime=1421492800,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=5,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA4239' AND dbfentry=2 AND dbfentrypos=1
17.01.2015, 12:06: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','54BA4239',3,1,1421492800,0,0,8000,10,'54BA4239',1421492800,6,35,'Pflege OG 1 / Mobil 2','8634','INT','','','','ca233278-51c1-4db3-8ca8-78239d2aea34',1)
17.01.2015, 12:06:41, UPDATE execute_data SET tstamp=1421492800,exectime=1421492800,answertime=1421492800,endcalltime=1421492800,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='54BA4239' AND dbfentry=3 AND dbfentrypos=1
17.01.2015, 12:06:56, UPDATE alarm_data SET tstamp=1421492815,alrstatus=2,endtime=1421492815,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BA4239'
17.01.2015, 12:06:56, UPDATE alarm_status SET reference='54BA4239',tstamp='1421492815',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
