Tim Titus
asked on
Asterisk CDR database? schema?
Anyone know what database Asterisk uses for their CDR database? Anyone know what the schema is? Fields, etc.?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is no IP information recorded and there is also no separate table.
All attempted calls are logged regardless of the source or destination.
All attempted calls are logged regardless of the source or destination.
ASKER
So there's no ability to track which phone's IP address connected to which gateway for a call?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It looks like there is no SourceIP or DestinationIP for the phone IP that was used in the call -- is this true, or is this in a different table?
From how the table is formatted, it looks like it only records external to internal calls -- not internal to internal calls, true?