Avatar of HaulnSS
HaulnSS asked on

Tracking call usage with Mitel 3300 and 5330 IP Phones

We have a Chatty Cathy that management would like me to track phone calls to and from and duration.  We have a Mitel 3300 Switch and she has a Mitel 5330 IP Phone.  I know how to check the call history information on her phone itself, is there a way I can print something out from the switch?
Voice Over IP

Avatar of undefined
Last Comment
HaulnSS

8/22/2022 - Mon
Joel_Sisko

Are you using some form of Call Accounting software? What you need is the SMDR from the system? Do yo have the manual around?

The SMDR is the entire log of all calls the system is making (usually is a raw format ASCII based), so the call accounting programs take the raw data, parse it and make reportable. But if you are savy with Excel you can whip up something in an hour to do that for you for at least some basic information.

Joel
Joel_Sisko

Normally you can establish a telnet session that will allow you to view the SMDR from the system.

Joel
ASKER
HaulnSS

That is where I am hung up.  I have the SMDR setup to report the calls I need, but I don't know how to retrieve the file.  The only option I can find in the system is to hook a printer to the switch.  I would prefer to format it, as you have suggested.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Joel_Sisko

I believe you can telnet to the ip address of the controller using port 1752 (not 23) and should start receiving the raw smdr.


Telnet xxx.xxx.xxx 1752


Joel
ASKER
HaulnSS

Where would this information be downloaded to on the computer?
ASKER
HaulnSS

You can disregard my last question...  I used Hyperterminal to connect, but am not seeing any data.  Does that mean I don't have the switch configured properly?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Joel_Sisko

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
HaulnSS

I did connect with 1752 and didn't need login info.  I even connected a computer to the serial port and didn't get anything.  I will check the setttings again.  I just don't know enough about these things to be productive with it.
Joel_Sisko

Just a quick troubleshooting thought, do not use port 1752 what is the response, if challenged then you know that at least you are reaching the system. Then try connecting with port "8435" if fails then you know port 1752 is open and your connection is good. If still not receiving information then I would say it is turned off globally. If you receive garbled data then it could be a format/settings issue with the baud rate, parity and such.

Joel
ASKER
HaulnSS

Port 23 says Welcome to the SX-2000, which is kind of weird...  We have a SX-2000 at a remote office...

Unable to connect to 8435.....so...port is open......still no data....hmmmmmmm
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
HaulnSS

Still haven't gotten any futher, but appreciate your help!
Joel_Sisko

Do have the manual via PDF for the PBX? I can thumb through it and see what the system settings should be for SMDR...you can use my email in my profile to send it to.

Joel Sisko
Joel_Sisko

Any luck?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
HaulnSS

Joel, I was able to get the data spooling to HyperTerminal...  Can you give me guidance on how to do something with this data?  How do I get into a file I can use in Excel?

Thanks,
John
Joel_Sisko

Well you have to do some formating, which means you have to understand the filed structure, that I am not the best to help you with. Google this phrase:

Mitel 3300 SMDR  format

There are a few resources that may help. If this is something you will be looking at on a regular basis, look for call accounting software, the few hundred bucks for a package will save you time and produce some useful reports.

Joel Sisko
ASKER
HaulnSS

Excellent, Thanks for the help!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck