Skip to content

Instantly share code, notes, and snippets.

@MefhigosetH
Created Jun 21, 2016
Embed
What would you like to do?
queue_log - odbc vs AMI
Event: Cdr
Privilege: cdr,all
AccountCode: CesarReyna
Source: 2021
Destination: 02964482342
DestinationContext: subDialTrunk
CallerID: "2021_DialApplet" <2021>
Channel: SIP/2021-0009b60f
DestinationChannel: IAX2/gedco-ar-11191
LastApplication: Dial
LastData: IAX2/gedco-ar/XXXXXXXXXX,300
StartTime: 2016-06-20 18:02:08
AnswerTime: 2016-06-20 18:02:32
EndTime: 2016-06-20 18:03:48
Duration: 100
BillableSeconds: 76
Disposition: ANSWERED
AMAFlags: DOCUMENTATION
UniqueID: nodo2-1466463728.1147533
UserField: nodo2-1466463732.1147542_2021_2770
asterisk=> SELECT * FROM cdr WHERE dst='XXXXXXXXXX' ORDER BY calldate DESC LIMIT 3;\x\g\x
-[ RECORD 1 ]--------------------------------------------------------------------------------------------------------------------------
calldate | 2016-06-20 18:02:08-05
clid | "2021_DialApplet" <2021>
src | 2021
dst | XXXXXXXXXX
dcontext | subDialTrunk
channel | SIP/2021-0009b60f
dstchannel | IAX2/gedco-ar-11191
lastapp | Dial
lastdata | IAX2/gedco-ar/XXXXXXXXXX,300
duration | 100
billsec | 76
disposition | ANSWERED
amaflags | 3
accountcode | CesarReyna
uniqueid | nodo2-1466463728.1147533
userfield | nodo2-1466463732.1147542_2021_2770
peeraccount |
linkedid | nodo2-1466463728.1147533
sequence | 1493846
groupcount | 58
rtpqos | ssrc=1987245103;themssrc=3252328439;lp=0;rxjitter=0.000042;rxcount=4812;txjitter=0.000000;txcount=954;rlp=0;rtt=0.000000
asterisk=> \d cdr
Tabla «public.cdr»
Columna | Tipo | Modificadores
-------------+--------------------------+--------------------------------------------------
calldate | timestamp with time zone | not null valor por omisión now()
clid | character varying(80) | not null valor por omisión ''::character varying
src | character varying(80) | not null valor por omisión ''::character varying
dst | character varying(80) | not null valor por omisión ''::character varying
dcontext | character varying(80) | not null valor por omisión ''::character varying
channel | character varying(80) | not null valor por omisión ''::character varying
dstchannel | character varying(80) | not null valor por omisión ''::character varying
lastapp | character varying(80) | not null valor por omisión ''::character varying
lastdata | character varying(80) | not null valor por omisión ''::character varying
duration | integer | not null valor por omisión 0
billsec | bigint | not null valor por omisión 0
disposition | character varying(11) | not null valor por omisión ''::character varying
amaflags | integer | not null valor por omisión 0
accountcode | character varying(20) | not null valor por omisión ''::character varying
uniqueid | character varying(32) | not null valor por omisión ''::character varying
userfield | character varying(255) | not null valor por omisión ''::character varying
peeraccount | character varying(20) | not null valor por omisión ''::character varying
linkedid | character varying(32) | not null valor por omisión ''::character varying
sequence | integer | not null valor por omisión 0
groupcount | integer |
rtpqos | character varying(255) | valor por omisión NULL::character varying
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment