18.01.2015, 00:04:17, 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','54BAEA71',1421535857,1421535857,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
18.01.2015, 00:04:17, UPDATE alarm_data SET msg='W 112',dispmsg1='NORMAL W 112',dispmsg2='NORMAL W 112',tstamp=1421535857 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEA71'
18.01.2015, 00:04:18, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421535857 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEA71'
18.01.2015, 00:04:18, UPDATE alarm_status SET reference='54BAEA71',tstamp=1421535857,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 00:04: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','54BAEA71',0,1,1421535859,0,0,8000,12,'54BAEA71',1421535859,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
18.01.2015, 00:04: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','54BAEA71',1,1,1421535859,0,0,8000,12,'54BAEA71',1421535859,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
18.01.2015, 00:04:27, UPDATE execute_data SET tstamp=1421535867,exectime=1421535859,answertime=1421535867,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='54BAEA71' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 00:04:28, UPDATE execute_data SET tstamp=1421535867,exectime=1421535859,answertime=1421535867,endcalltime=1421535867,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='54BAEA71' AND dbfentry=1 AND dbfentrypos=1
18.01.2015, 00:04:28, UPDATE execute_data SET tstamp=1421535868,exectime=1421535859,answertime=1421535867,endcalltime=1421535868,confirmtime=0,callduration=1,execstatus=1,substatus='8633',answerdby='8633',linenumber=1,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEA71' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 00:04:42, UPDATE alarm_data SET tstamp=1421535882,alrstatus=2,endtime=1421535882,duration=25, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEA71'
18.01.2015, 00:04:43, UPDATE alarm_status SET reference='54BAEA71',tstamp='1421535882',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 00:20:20, 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','54BAEE33',1421536820,1421536820,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
18.01.2015, 00:20:20, UPDATE alarm_data SET msg='W 120',dispmsg1='NORMAL W 120',dispmsg2='NORMAL W 120',tstamp=1421536820 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEE33'
18.01.2015, 00:20:20, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421536820 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEE33'
18.01.2015, 00:20:20, UPDATE alarm_status SET reference='54BAEE33',tstamp=1421536820,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 00:20: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','54BAEE33',0,1,1421536820,0,0,8000,12,'54BAEE33',1421536820,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
18.01.2015, 00:20:22, INSERT INTO execute_data (id,servername,reference,dbfentry,dbfentrypos,tstamp,escalcnt,ccxescalcnt,alrnumber,grpnumber,srcreference,exectime,execstatus,entryindex,entryname,entryvalue,entrytype,department,costcenter,language,uuid,locking) VALUES (NEXTVAL('execute_data_id_seq'),'WINDOWS-VY7ULCW','54BAEE33',1,1,1421536821,0,0,8000,12,'54BAEE33',1421536821,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
18.01.2015, 00:20:27, UPDATE execute_data SET tstamp=1421536827,exectime=1421536820,answertime=1421536827,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='54BAEE33' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 00:20:27, UPDATE execute_data SET tstamp=1421536827,exectime=1421536821,answertime=1421536827,endcalltime=1421536827,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='54BAEE33' AND dbfentry=1 AND dbfentrypos=1
18.01.2015, 00:20:29, UPDATE execute_data SET tstamp=1421536829,exectime=1421536820,answertime=1421536827,endcalltime=1421536829,confirmtime=0,callduration=2,execstatus=1,substatus='8633',answerdby='8633',linenumber=2,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEE33' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 00:20:41, UPDATE alarm_data SET tstamp=1421536841,alrstatus=2,endtime=1421536841,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BAEE33'
18.01.2015, 00:20:41, UPDATE alarm_status SET reference='54BAEE33',tstamp='1421536841',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 03:00:00, Delete records from alarm database nv_alarm which are older then 720 days
18.01.2015, 03:00:00, Delete records from table alarm_data. Execute SQL command: delete from alarm_data where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table alarm_escalation. Execute SQL command: delete from alarm_escalation where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table incoming_data. Execute SQL command: delete from incoming_data where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table execute_data. Execute SQL command: delete from execute_data where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table conference_data. Execute SQL command: delete from conference_data where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table conference_execute_data. Execute SQL command: delete from conference_execute_data where TSTAMP<1360634400  Code:0
18.01.2015, 03:00:00, Delete records from table messenger_data. Execute SQL command: delete from messenger_data where TSTAMP<1416470400  Code:0
18.01.2015, 03:00:00, Delete records from table messenger_escalation. Execute SQL command: delete from messenger_escalation where TSTAMP<1416470400  Code:0
18.01.2015, 03:00:00, Delete records from table messenger_execute_data. Execute SQL command: delete from messenger_execute_data where TSTAMP<1416470400  Code:0
18.01.2015, 03:00:00, Delete records from event database nv_event which are older then 720 days
18.01.2015, 06:03:49, 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','54BB3EB4',1421557429,1421557429,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
18.01.2015, 06:03:49, UPDATE alarm_data SET msg='W 123',dispmsg1='NORMAL W 123',dispmsg2='NORMAL W 123',tstamp=1421557429 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EB4'
18.01.2015, 06:03:49, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421557429 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EB4'
18.01.2015, 06:03:49, UPDATE alarm_status SET reference='54BB3EB4',tstamp=1421557429,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 06:03: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','54BB3EB4',0,1,1421557433,0,0,8000,12,'54BB3EB4',1421557433,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
18.01.2015, 06:03: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','54BB3EB4',1,1,1421557433,0,0,8000,12,'54BB3EB4',1421557433,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
18.01.2015, 06:04:03, UPDATE execute_data SET tstamp=1421557443,exectime=1421557433,answertime=1421557443,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EB4' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 06:04:03, UPDATE execute_data SET tstamp=1421557443,exectime=1421557433,answertime=1421557443,endcalltime=1421557443,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='54BB3EB4' AND dbfentry=1 AND dbfentrypos=1
18.01.2015, 06:04:06, UPDATE execute_data SET tstamp=1421557446,exectime=1421557433,answertime=1421557443,endcalltime=1421557446,confirmtime=0,callduration=3,execstatus=1,substatus='8633',answerdby='8633',linenumber=4,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EB4' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 06:04:20, UPDATE alarm_data SET tstamp=1421557460,alrstatus=2,endtime=1421557460,duration=31, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EB4'
18.01.2015, 06:04:20, UPDATE alarm_status SET reference='54BB3EB4',tstamp='1421557460',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 06:04:49, 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','54BB3EF0',1421557489,1421557489,03,8000,'NORMAL',12,'Pflege_Nachtschaltung',0,1,6,0,0,0,'ESPA',0,0,0,1)
18.01.2015, 06:04:49, UPDATE alarm_data SET msg='W 123',dispmsg1='NORMAL W 123',dispmsg2='NORMAL W 123',tstamp=1421557489 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EF0'
18.01.2015, 06:04:49, UPDATE alarm_data SET weekplan='8000',weekaction='12 (GRP)',tstamp=1421557489 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EF0'
18.01.2015, 06:04:49, UPDATE alarm_status SET reference='54BB3EF0',tstamp=1421557489,alrstatus=1 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
18.01.2015, 06:04: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','54BB3EF0',0,1,1421557489,0,0,8000,12,'54BB3EF0',1421557489,6,88,'8633','8633','INT','','','','cb4002ec-8b84-4291-b258-bdf7445bc070',1)
18.01.2015, 06:04: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','54BB3EF0',1,1,1421557495,0,0,8000,12,'54BB3EF0',1421557495,6,36,'Dienstzimmer Pflege','611','INT','','','','ca7c9ab2-b9c8-40db-8b3c-3d988430cec1',1)
18.01.2015, 06:04:57, UPDATE execute_data SET tstamp=1421557496,exectime=1421557489,answertime=1421557496,endcalltime=0,confirmtime=0,callduration=0,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EF0' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 06:04:57, UPDATE execute_data SET tstamp=1421557496,exectime=1421557495,answertime=1421557496,endcalltime=1421557496,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='54BB3EF0' AND dbfentry=1 AND dbfentrypos=1
18.01.2015, 06:05:00, UPDATE execute_data SET tstamp=1421557500,exectime=1421557489,answertime=1421557496,endcalltime=1421557500,confirmtime=0,callduration=4,execstatus=1,substatus='8633',answerdby='8633',linenumber=8,specconf='',callingparty='',replication=0,locking=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EF0' AND dbfentry=0 AND dbfentrypos=1
18.01.2015, 06:05:10, UPDATE alarm_data SET tstamp=1421557510,alrstatus=2,endtime=1421557510,duration=21, voicefile='d:\dbv1\.\v8xxx_1.vox',locking=0,canceledstatus=0 WHERE servername='WINDOWS-VY7ULCW' AND reference='54BB3EF0'
18.01.2015, 06:05:10, UPDATE alarm_status SET reference='54BB3EF0',tstamp='1421557510',alrstatus=2 WHERE servername='WINDOWS-VY7ULCW' AND alrnumber=8000
