How to retrieve a Call Log for inbound/outbound calls on a specific extension. Mitel 3300 system

[dan737]

How to retrieve a Call Log for all inbound/outbound calls on a specific extension. Mitel 3300 system

Thank you

 

[kwbMitel]

Maintenance Commands (This assumes the system is configured for SMDR and nothing is streaming the data (20,000 calls buffered))

Option A
LOGSYS READ SMDR ALL MATCH XXXX or LOGSYS READ SMDR NEWEST ????? MATCH XXXX

You will get call records that dont match the extension as the numbers will match within the dialed digits on occasion but it will usually get you what you need.


Option B (my Method)
LOGSYS READ SMDR INTO SM160114 ALL

then FTP into the system and transfer the file from /db/cc directory
then copy data into excel
then use text to columns to format the data
then sort


**********************************************
What's most important is that you realise ... There is no spoon.

 

[dan737]

I did option (A)
LOGSYS READ SMDR ALL MATCH XXXX
How can I tell which is inbound and outbound?

Thank you,


01/13 05:29P 00:01:06 5630 004 5680 I 5680
001
%01/13 04:25P 00:11:16 5630 006 5680 I 5680
001
01/13 04:09P 00:00:45 5680 1300 AS
001
01/13 04:02P 00:00:40 T104 016 5680 1111 1300
001 2167741974 5680
01/13 03:45P 00:00:59 5680 4192596434 A T222
001
01/13 03:32P 00:00:10 T102 015 5680 1111 1300
001 5680
01/13 03:31P 00:00:09 T102 *** 5680 5680
001 5680
01/13 03:28P 00:00:16 5680 1300 AS
001
01/13 03:26P 00:00:06 5680 1300 AS
001
01/13 03:12P 00:00:29 T101 006 5680 5680
001 4193346102 5680
01/13 02:08P 00:00:04 5680 2169708644 A T221
001
01/13 01:45P 00:01:12 T102 011 5680 5680
001 5680
01/13 01:11P 00:04:42 T101 012 5680 5680
001 5680
01/13 12:59P 00:01:34 T101 010 5680 5680
001 5680
%01/13 12:24P 00:10:21 T101 009 5680 5680
001 5680
01/13 11:57A 00:00:16 5680 1300 AS
001
%01/13 08:47A 00:19:45 5630 005 5680 I 5680
001
01/13 08:20A 00:00:17 5680 1300 AS
001
01/13 08:20A 00:00:30 5680 1300 AS
001

 

[kwbMitel]

The originating device is located next to the duration of the call


[pre] 01/13 05:29P 00:01:06 [highlight #FCE94F]5630[/highlight] 004 5680 I 5680 001
%01/13 04:25P 00:11:16 [highlight #FCE94F]5630[/highlight] 006 5680 I 5680 001
01/13 04:09P 00:00:45 [highlight #FCE94F]5680[/highlight] 1300 AS 001
01/13 04:02P 00:00:40 T104 016 5680 1111 1300 001 2167741974 5680
01/13 03:45P 00:00:59 [highlight #FCE94F]5680[/highlight] 4192596434 A T222 001
01/13 03:32P 00:00:10 T102 015 5680 1111 1300 001 5680
01/13 03:31P 00:00:09 T102 *** 5680 5680 001 5680
01/13 03:28P 00:00:16 [highlight #FCE94F]5680[/highlight] 1300 AS 001
01/13 03:26P 00:00:06 [highlight #FCE94F]5680[/highlight] 1300 AS 001
01/13 03:12P 00:00:29 T101 006 5680 5680 001 4193346102 5680
01/13 02:08P 00:00:04 [highlight #FCE94F]5680[/highlight] 2169708644 A T221 001
[/pre]

When the originating device is a Trunk it will typically show TXXX followed by Time to answer

[pre] 01/13 04:02P 00:00:40 [Highlight #8AE234]T104 016[/highlight] 5680 1111 1300 001 2167741974 5680
[/pre]

The Help files are very informative

**********************************************
What's most important is that you realise ... There is no spoon.

 

[dan737]

So 01/13 04:02P 00:00:40 T104 016 5680 1111 1300 001 2167741974 5680 , would be an inbound call?

Thank you for clarifying

 

[kwbMitel]

Yes that is inbound

Without having the proper spacing I can't tell you much more but it looks like

5860 are the received digits after digit modification (DNIS)
1111 is what 5860 terminated to
T104 is the calling trunk
016 is the number of seconds before the call was answered
00:00:40 is the duration of the call
1300 is the device that answered the call
2167741974 is the calling line ID of the caller

To post with proper spacing use the Pre option in the formatting options above

e.g.

with pre
[pre]1 20 300 4000 50000
12 201 3111 410 5
[/pre]
without
1 20 300 4000 50000
12 201 3111 410 5


**********************************************
What's most important is that you realise ... There is no spoon.

 

[dan737]

KwbMitel,

Were investigating a possible International "inbound" call that came in on 1/13/2016 around 12:24PM, 12:59PM, 1:11PM, 1:45PM, 3:31PM, and 3:3PM
Since the log did not caller ID the international number...is there any possible way to get it from the phone system or do I have to call Telco?

Your help is greatly appreciated.
Thank you,

 

[kwbMitel]

Read the log without the filter

LOGSYS Read SMDR Newest 500

Depending on the size of your system 500 should be enough to get back to Noon yesterday. If not, run again with higher number until you do get back that far.

NEVER try to report all to the screen. It can cause call processes to fail and it will run F O R E V E R

Post some results that likely have the suspect call in them. Keep in mind the SMDR record prints when the call completes, not when it starts.

Remember to use the PRE option above to maintain the formatting.

**********************************************
What's most important is that you realise ... There is no spoon.

 

[dan737]

I don't mean to sound stupid, but what is PRE option and how to use it?

Thanks

 

[dan737]

I did a LOGSYS READ SMDR NEWEST 4000 to pull the records for 1/13
I did not see anything for the time 12:24 although I do see 12:24 when I run LOGSYS SMDR ALL MATCH 5680

LOGSYS READ SMDR NEWEST 4000
01/13 12:39P 00:00:47 5600 4193072144 A T123
001
01/13 12:23P 00:00:06 5620 4193074945 A T122
001
01/13 12:18P 00:04:57 X999 * 10024608 ASX999
001
01/13 12:23P X999 13001002461810024618 AS
001
01/13 12:22P 00:00:48 X999 000 4040 1300
001 4192080143 4040

LOGSYS SMDR ALL MATCH 5680
01/13 01:45P 00:01:12 T102 011 5680 5680 001 5680
01/13 01:11P 00:04:42 T101 012 5680 5680 00 5680
01/13 12:59P 00:01:34 T101 010 5680 5680 001 5680
%01/13 12:24P 00:10:21 T101 009 5680 5680 001 5680
01/13 11:57A 00:00:16 5680 1300 AS 001
%01/13 08:47A 00:19:45 5630 005 5680 I 5680 001 “Direct Dial” x5630
01/13 08:20A 00:00:17 5680 1300 AS 001
01/13 08:20A 00:00:30 5680 1300 AS 001

 

[kwbMitel]

but what is PRE option and how to use it?

When you are posting there is an action bar with formatting options [pre]B I U S X² X₂ TT PRE[/pre]

I used each of those options to present the options above with the exception of TT which I've forgotten what it does.

Use your cursor to select the text you want to affect and then press the formatting button

As for the Target call record not showing up in the unfiltered output - impossible

As I mentioned, the records do not output in exact chronological order but in the order they completed. I would have expected the call to appear around the 12:34 mark relative to other calls but it is not an exact science.

Cut and paste the unfiltered data from 12:00 to 2:00 into a notepad file and search for 5680. You'll find it then.

**********************************************
What's most important is that you realise ... There is no spoon.