lunes, 14 de junio de 2021

key report on survey campaing

Method 1

mysql  -e "select * from vicidial_list order by entry_date desc limit 100\G;" asterisk



-------------------------------------

Method 2

database name  asterisk

select asterisk;

MariaDB [asterisk]> select * from vicidial_list order by entry_date desc limit 10\G;

*************************** 1. row ***************************

                lead_id: 2874301

             entry_date: 2021-06-14 16:57:51

            modify_date: 2021-06-14 16:58:18

                 status: SVYHU

                   user: VDAD

       vendor_lead_code: 999999

              source_id: NULL

                list_id: 998

         gmt_offset_now: 0.00

called_since_last_reset: Y

             phone_code:

           phone_number: 393333635186

                  title: NULL

             first_name: Test

         middle_initial: NULL

              last_name: Call

               address1: Test Call

               address2: 2

               address3: 3

                   city: Springfield

                  state: IL

               province: NULL

            postal_code: NULL

           country_code: NULL

                 gender: U

          date_of_birth: NULL

              alt_phone: NULL

                  email: NULL

        security_phrase: 6

               comments: ROBOCALL test call placed 2021-06-14 16:57:51

           called_count: 1

   last_local_call_time: 2021-06-14 16:57:51

                   rank: 99

                  owner: Test Outbound Call

          entry_list_id: 0


 http://www.eflo.net/VICIDIALforum/viewtopic.php?f=2&t=38605

No hay comentarios:

Publicar un comentario