Duplicate UNIQUEID on CDR

Discussion in 'General' started by mahanli, Nov 25, 2009.

  1. mahanli

    Joined:
    Nov 24, 2009
    Messages:
    2
    Likes Received:
    0
    Elastix1.6
    +----------------+-------------+-----+---------------------+
    | uniqueId | src | dst | calldate |
    +----------------+-------------+-----+---------------------+
    | 1258701374.273 | 108 | s | 2009-11-20 15:16:14 |
    | 1258701374.273 | 02580847104 | 107 | 2009-11-20 15:19:16 |
    | 1258704292.293 | 106 | s | 2009-11-20 16:04:52 |
    | 1258704292.293 | 01062987800 | 111 | 2009-11-20 16:05:41 |
    | 1258959190.351 | 52680354 | 101 | 2009-11-23 14:53:10 |
    | 1258959190.351 | 52680354 | 102 | 2009-11-23 14:53:57 |
    | 1259051567.910 | 18901601331 | 107 | 2009-11-24 16:33:03 |
    | 1259051567.910 | 18901601331 | 162 | 2009-11-24 16:34:42 |
    +----------------+-------------+-----+---------------------+
    8 rows in set (7.90 sec)
     
  2. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    Same "unique" call, different "leg" had you added the callsecs and billsecs fields to your query, you would see they don't overlap for billing but they do abut.
     
  3. mahanli

    Joined:
    Nov 24, 2009
    Messages:
    2
    Likes Received:
    0
    Thanks a lot,dicko
     

Share This Page