[asterisk-users] Condensing queue CDRs into single entry

[Rajkumar S]

Hi,

When a call is made to a queue and picked up by agents at least 2 CDR
entries are made, one from local to the agent's (sip) phone, and from
incoming line to Agent. There are other entries generated when other
conditions happen, like agent do not pickup phones and so on.

Going through the cdr entries, there seems to be no common filelds by
which all entries belonging to a single call can be picked up, so how
can I extract all entries belonging to a single call, say if I have
the CDR in a database.

raj