Sometimes, admin would like to change / reset only specific dial statuses within only specific campaign – i.e. Reset all NA, NI, NP and similar statuses while keeping others (like DNC, SALE etc.) intact.
To do so, log SSH in and open mysql:
mysql -ucron -p1234use asterisk
Afterwards, run the following command (Example – reset all statuses for all lists in campaign ID 4000 except for leads, callbacks and DNC):
update vicidial_list set status='NEW' where list_id in (select list_id from vicidial_lists where campaign_id='4000') and status not in ('DNC','DNCL','CALLBK','CBHOLD','SALE');