How to retrieve records for a particular ANI from CCon?

General Discussion
1

Hi,

please do not flame me for asking too many questions and not answering any. :-\

Can someone tell me please the way to retrieve all the relevant records from ccon based on ANI? I look at Ccon table structure and cannot tell where ANI is less alone how to get it from there.

Thank you so much.

OR

2

This should be simple:

you are looking for FIRST_PHONE field in GCDR. This is your ANI :slight_smile:

SELECT FIRST_PHONE FROM GCDR where FIRST_PHONE = ‘NUMBER HERE’ will return all the records you need.

For detailed info, you then just need to SELECT SCDR table ;D

Tell me if you need help!

Best regards,
Vic

2 Likes