Delete all CDR for a single tenant

[Jiz]

Hello,

How can i delete all CDR entries just for a single tenant from database?

Appreciate your answers.

 

[ad5ou]

Go to "Advanced>Group Manager" and edit the permissions for superadmin to include "xml_cdr_delete"

Reload permissions or logout/log back in, and then you will have the option to delete CDR records from the CDR page.

Or with a properly crafted SQL statement, you could accomplish the same thing.

 

[Jiz]

Go to "Advanced>Group Manager" and edit the permissions for superadmin to include "xml_cdr_delete"
View attachment 3007
Reload permissions or logout/log back in, and then you will have the option to delete CDR records from the CDR page.

Or with a properly crafted SQL statement, you could accomplish the same thing.

Thanks,

I am aware about this method but difficult if I have 100's of pages. SQL statement method would be easier to achieve.

 

[ad5ou]

DELETE from v_xml_cdr WHERE domain_name = "thedomaintodelete";

 

[Jiz]

DELETE from v_xml_cdr WHERE domain_name = "thedomaintodelete";

Thank you.. appreciated