How to retrieve records for a particular ANI from CCon?

[Outbound Reportq]

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

[victor]

This should be simple:


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

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 

Tell me if you need help!

Best regards,
Vic