I am trying to find out where a call gets log when i pick up.
I have been looking at the CDR table and i see no answers but i don’t see my # until after i hung up
Please look into CEL logging. CEL stands for Channel Event Logging and is what is used to log each channel event. CEL logging in csv format is the most bare bones implementation of what you are looking to do. Please see cel.conf in the /etc/asterisk directory which has details about this.