SMDR Collection Post R 6.0

[mlaurence]

I have a few customers that are needing SMDR collection abilities now that Delta Server isn't supported with R6.

These customers don't have any call accounting software that can be configured to 'listen' for the info directed by the new IPO settings, they have just manually dug through the data in the past.

I've found some SMDR collection software out there, but the cheapest is ~ $62 (

http://www.aggsoft.com/pbx-data-logger/buy.htm

) A tough ticket to sell when it used to be free.

Has anyone come across a cheaper/free solution to collect the SMDR data?

 

[hairlessupportmonkey]

There are several posts in here about this, and there is a few products (free) to use.

http://www.tek-tips.com/gsearch.cfm...?SearchString=smdr+6.0&type=Forum&sub=Go#1149

threw up a few of them

 

[mlaurence]

Thanks for the info, previous searches didn't yield any leads. Will look into it...

Cisco-CCNA; Avaya- ACSS

 

[BrightTech]

Hi there, dont know if you came right with your software search.

I use Kiwi Syslog Server 9.1.0. It runs as basic for free, can write to a file of your choice, and just wrote a bat file to rename the file on a daily basis.
It runs as a service so is hassle free.

Hope this helps

 

[tlpeter]

Can you connect hyperterminal to an ip port and collect the smdr that way?

I never tried but I think you can.



Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[IPGuru]

as some other options
nearly all Linux flavors have a syslog daemon that can accept this info
I have also writen a crude python script that cann cssess the smdr information, this can then easily be writen to a file or saved in an sql database for later programmig

I havnt given it much attention recently but with 6.1 moving to a linux server I think I might start to clean it up. Polite sugestions welcome

(python is availabel as open source software for windows as well as Linux)

I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[Pepp77]

TLPeter yes you can - I use this if Oak isnt collecting data to try and pinpoint the issue.

The other option of course is to install oak, you get 30 days full usage and then after that it will continue to collect SMDR output, but you just wont be able to report on it.

| ACSS SME |

 

[Mlck]

There are a free SMDR App under Tool in Avaya Knowledge Base.

 

[tlpeter]

IPGuru, I did se phyton on the Linux machine.
So perhaps it is already on it?

Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[IPGuru]

TLPeter I would be supprised if it isn't

Python is used for may of the red hat administration tools, & is also heavily used in most linux distributions
It is worth a look as it is a very easy & flexible language.



I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[tlpeter]

Can you tell me how to activate it ?
I do not mind braking down a server
at the moment my Linux skills are about zero but I don't mind learning it.


Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[hairlessupportmonkey]

peter - python is a programming language.

http://www.python.org/

good luck ;-)

 

[IPGuru]

A very crude example of reading the SMDR buffer with Python
it should work on the VM Pro Linux without problem

#!/usr/bin/env python
from telnetlib import Telnet
host='192.168.42.1' # Address of IPO to connect to
port=23 # Whateve you have set in the IPO
conn=Telnet(host,port) #connect to IPO
while True:
    smdr=conn.read_until('\n',1) #read 1 line
    if smdr="": break  # exit loop if no more data
    print smdr  #print to screen.

I think you will agree it is a pretty readable language (readability if one of the prime tennants of python)


I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[IPGuru]

Slight typo
change line to read " if smdr=="":break"

I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[tlpeter]

Do you have this working ?
I get 111 connection refused.

If you have it working, do you have it working on the ipo linix ?


Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[IPGuru]

It was typed by hand rather that cut & paste but I have an expanded version that runs ( & writes data to a Mysql Database)
I havn't tried it on the Avaya Linux distro yet

"111 connection refused" is not a Python error so i suspect yo do not have the IPO configured correctly (or they have changed it in V6.0, i have been testing with V5.0)

in system SMDR
enable SMDR output
leave the IP address as 0.0.0.0
set the port to match the script.


I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[tlpeter]

The 0.0.0.0 instead of the ipaddress did it but now i get an error on "smdr=conn.read_untill"

It gives:

File "<stdin>", line 1, in ?
Attribute error: Telnet instance has no attribute 'read_untill'


Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[IPGuru]

Sorry Typo on my behalf
should be " smdr=conn.read_until('\n',1)"

as I said it was typed direct (form memory) rather than cut & paste so a few of these aslmos certainly have slipped in.

Laws of programming:

Any programm contains at least 1 bug
Any programm can be reduced by at least 1 instruction

Therfore any programm can be reduced to 1 instruction that does not work

I do not Have A.D.D. im just easily, Hey look a Squirrel!

 

[tlpeter]

Then the last line should be " print smdr" ???

When i do: print smdr i get an error that smdr is not defined.
" print smdr" does not give an error.


Homo sapiens non urinat in ventum

honey, i fried the IP Office !!!

Sarcasm, it's only one of the services I offer.

 

[IPGuru]

I have coppied & pasted the code ( & corrected my if statement)
it seems to work for me
remember Indentation is significant in python also python is case sensitive

this script was only an example, it needs expanding with error checking & processing of the recieved data to be any use.

http://openbookproject.net/thinkcs/python/english2e/

is quite a good looking tutorial aimed at novice programmers.

I do not Have A.D.D. im just easily, Hey look a Squirrel!