Reporting on Dialled numbers

[Gambit88]

Is there a way to report on dialled numbers? Who called that number etc.

I know you can do this on other call reporting software even on CCR just can not see an option on IPOCC at the moment so any help would be great.

 

[Alfalis]

Hi,

of course there is - use the statistic module for that or grab the necessary data from the database directly.
If you could describe in more detail what reports you want I'm sure we can help you

 

[janni78]

If you just want a quick search on a specific phone number the supervisor can do that from the Contact Detail Reports screen in IPOCC UI.

"Trying is the first step to failure..." - Homer

 

[Gambit88]

Thank you,

It is our client is trying to find out if either someone or a dialler has called a certain number and I just cant seem to find a report that lets you do this

 

[Alfalis]

That looks like a perfect scenario for what janni said

Here you can filter by date and/or topic, caller, dialed address etc.

 

[Gambit88]

Thanks Janni78, that is exactly what I am looking for.

Appreciate the help everyone.

 

[Gambit88]

Would anyone know of any other way that you would be able to search for dialled numbers on IPOCC or the IP Office.

Our client has an issue where someone has complained that they have been dialled 183 times but when you search for the number in the Contact Detail Report the number does not show up but when they have asked their line provider they have been able to trace the call has came from their system.

So is there any other way other than Monitor can trace this?

 

[janni78]

Monitor would actually be a good place to start as that shows if the call actually comes to the system and where it goes.
You'll see if it goes to IPOCC, what Topic number and if it goes to an agent, who the agent is.

"Trying is the first step to failure..." - Homer

 

[Gambit88]

Thanks Janni78 but the problem with monitor it would need to have been running to get this information.

The calls allegedly happened on Monday so would be unable to get that from Monitor

 

[Alfalis]

You can't get the logs from the past, but you can leave the monitor running on some server and log to files.
That way you'll be prepared for the next time it happens.

EDIT: Have you had a look at the TTrace logfiles from monday?

 

[Gambit88]

Hi Alfalis,

No I have not, not really sure were I should be looking with that.

 

[janni78]

You can try looking in the database.

Start with searching for the number in the TR database, table zeroleveldata, column cck_callingnumber
That should show date, time, topic etc if that number called the system.

But I think this is the same place that Contact Detail Report looks in.



"Trying is the first step to failure..." - Homer

 

[Gambit88]

Well it would have been an outgoing call, this show the same information?

 

[Alfalis]

Ok so just to make sure: What exactly are you looking for? Inbound calls that apparently didn't get through or outbound calls?

 

[janni78]

Outbound calls should show in the same table, considering the amount of calls it sound like there would be a dialer involved.

"Trying is the first step to failure..." - Homer

 

[Gambit88]

It is an outbound number.

The number was on the diallers list and when it tried it came back with the return code from dialler as destination busy.

However when I look at the Contact Detail reports and look that number does not show up at all for that date so unless it has not logged that information

 

[janni78]

Can you post a pic of your search?

"Trying is the first step to failure..." - Homer

 

[Alfalis]

Did you initiate the call from your phone or via the IPOCC UI?
Also you could run a select * from levelzerodata where cck_callednumber like '123456789' - if that doesn't return anything the call did not happen (or was not initiated via the UI). You may also use "%" as a placeholder, so for example like '%123' if you want all numbers that end in "123".

 

[Alfalis]

@janni: btw, Homer actually said "trying is the first step towards failure ;D
[URL unfurl="true"]https://www.youtube.com/watch?v=CNOutomr5XI[/url]

 

[Gambit88]

I have never used the TTrace before unfortunately, is it the TT Console you use?

It was a dialler that was meant to have made the call.