Search Results

Hi all,
I'd like to thank RudiC, and durden_tyler for help. I'm wondering how to improve those scripts, also how to add formulas in perl script...

1. Daily reports script:


#!/bin/bash
...

Maybe I can use these:

1479585616|1479585585.136581|2041|NONE|EXITWITHTIMEOUT|1|1|30
1479585687|1479585657.136613|2031|NONE|EXITWITHTIMEOUT|1|1|30...

it it possible to use unix time?

This works very well.
How I can make it write output if there is RingNoAnswer between Start-End time of ExitWithTimeout?

Like this:
EXITWITHTIMEOUT

17 Nov 2016,10:06:07 EST,17 Nov...

I have two sheets:

sheet one - ringnoanswer event:


Day Start Date Start Time End Date End Time Queue Operator Issue WaitTime
Mon 07 Nov 2016 09:12:48 EST 07...

Or maybe it is possible to do this without macro. If column C (ringnoanswer) is equal with column C (exitwithtimeout), then write in new sheet Columns F,G,I from RingNoAnswer

Hello all,
I'm here again with new trouble. I need to find any possible way to apply excel macro on excel file in SLES server, or to convert that macro somehow.

Could you please share your...

Thanks Don for your help. Your code looks much better than mine, I will use it. Later will update..

Hey Don, thank you for answer :)

I'm trying to do the following two things. I'm stuck right now :(

- when RINGNOANSWER for a particular operator hits count 10 for WAITTIME > 14000. alert with...

#!/bin/bash

#Subject - Mail body
echo "Subject: Everyday call report - $( date '+%d/%m/%Y' )" > /var/log/asterisk_agents_log/everyday.html
echo "FROM: Alert system <alerts@mail.com>" >>...

print strftime("%c|", $2) strftime("%c|", $1)is changed to

print strftime("%a %d %b %Y %H:%M:%S %Z|",$2) strftime("%a %d %b %Y %H:%M:%S %Z|",$1)because when it's executed by cron, some mismatch...

These are my three scripts-like running every hour with cron.


RINGNOANSWER:


mysql -u select -D zabbix -e "select clock,value from history_log where itemid=25143;" |
grep -v -e...

Thanks Jim. I'll try with AWK and will reply with results.

May be someone will ask why I'm not using logs directly from Asterisk. Well the pbx server is on different machine, and it's not...

For RINGNOANSWER:
current output (first column is zabbix alert time - not needed) :
1458182148 1458182148|1458182143.44543|1111|NAME NAME|RINGNOANSWER|4000

it should look like:
Date time...

Dear all,
I start to build script(s) for few tasks, and I'll use log files to complete the following:


1) when ringnoanswer for a particular operator hits count 10 for waittime > 14000 send...