Clear the Call Details Records in Fusion PBX

Status
Not open for further replies.

kwangmien

Member
Oct 3, 2018
59
1
8
52
Hi,

I have a lot of call details records in my Fusion PBX. Clicking on the Delete button for every call details records is not practical.

I tried to click on the "Reset" button in the Call Details Records, but all the call details records were not removed.

Can anyone advise me how I can clear all the Call Details Records ?

Thank you.

Regards,
Kwang Mien
 

DigitalDaz

Administrator
Staff member
Sep 29, 2016
3,038
556
113
Code:
su - postgres
psql fusionpbx
delete from v_xml_cdr where start_stamp < NOW() - INTERVAL '90 days';
\q
exit
Change the 90 days to suit yourself.
 

kwangmien

Member
Oct 3, 2018
59
1
8
52
Thanks for the info. can you advise what would be the SQL if i would to delete CDR for a particular domain ?


Code:
su - postgres
psql fusionpbx
delete from v_xml_cdr where start_stamp < NOW() - INTERVAL '90 days';
\q
exit
Change the 90 days to suit yourself.
 
Status
Not open for further replies.