Clear the Call Details Records in Fusion PBX

[kwangmien]

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]

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]

Thanks for the info. can you advise what would be the SQL if i would to delete CDR for a particular domain ?

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.