CDR / limits

[D Ellis]

Hi all,

We are live testing Vodia for a client who potentially could have a multi tenant system with hundreds of tenants.

Curious on the limits to CDR records and call reporting records. I see that it's 1,000,000 system wide ( each for CDR and call recordings ) of which assuming it's a flat file, I can understand that. What do people do over that limit as on other PBX systems, we've limited recordings generally to 30 days on other systems, but given higher range on how long the CDR's stay on the system. Assume some must have customers who want to keep 2-3 years for legal reasons of CDR records and in our case most don't want to keep it for long, but there are some customers. On a multi tenant level certainly there could be issues everyone having years worth of CDR records, but we need to flexibility to have some that can have a higher number.

Am I reading it correctly that system wide on a multi tenant its 1,000,000 and then after that we should be looking to export them? Which of course requires a frontend for customers to access, so it's development we'd like to avoid. Are there 3rd party companies, maybe tools others have used to export to and use. We are worried if we use Vodia for a customer who is putting a lot of customers on it, to pay the license fee and then also to pay for a 3rd party solution, it may price them out of the market they are looking at. I'd be curious what solutions others have come up with to going over the limits or use other methods used.

**EDIT** even something like a2billing, it would be better than developing something from scratch.

Thanks

[D Ellis]

Is this not an issue with most people?

[Vodia PBX]

There is no hardcoded limit. 1 MM records should be no big deal for a regular server, but you can also make to 2 MM or 10 MM if you like. It will just take up more space on the hard drive and also in RAM, though we try to keep the memory part small. Also it will make the restart slower because the PBX has to read the index files before it gets operational.

For each tenant there is a retention period, which serves as additional limit. Typically the tenant limitation should be the one that really limits it. If you promise tenants to keep the records for a year then you want to make sure that the number of total records in the system is far more than you would expect from that tenant.

Some Vodia partners have written external CDR storage solutions. For example the PBX can push records straight into MongoDB. However (at this point) it's a one-way ticket from the PBX point of view. 

[Brandywine]

We use CDR-Reports for all of our advanced customer reporting and long term record retention.  Have been using them for years and works well.  Here is the contact info if you want to reach out craig@cdr-reports.com 

We have 14 server and 5k+ users, its pretty much the best thing out there for long term retention and reporting if you dont want to startt from scratch. Craig built alot of it around Vodia specifically, have him do a demo for you , handles all the ACD and billing level records ... Yori 

[D Ellis]

On 10/20/2023 at 9:33 PM, Vodia PBX said:

There is no hardcoded limit. 1 MM records should be no big deal for a regular server, but you can also make to 2 MM or 10 MM if you like. It will just take up more space on the hard drive and also in RAM, though we try to keep the memory part small. Also it will make the restart slower because the PBX has to read the index files before it gets operational.

For each tenant there is a retention period, which serves as additional limit. Typically the tenant limitation should be the one that really limits it. If you promise tenants to keep the records for a year then you want to make sure that the number of total records in the system is far more than you would expect from that tenant.

Some Vodia partners have written external CDR storage solutions. For example the PBX can push records straight into MongoDB. However (at this point) it's a one-way ticket from the PBX point of view. 

Hi,

Thanks for this. A little confused by the option in Settings>General>Recording/CDR. First option listing size, get this is the limit in the GUI. Duration of keeping CDR, assume if we want two years or one year its 104/52 respectively? Then it's the next one that's confusing, Maximum number of CDR system wide. It only allows up to 1000000, how do I set 10MM? Then which comes first the duration of keeping CDR or the maximum number of CDRs system wide? Can you just say 104 weeks for any tenant, unless individual ones are reduced increased in the tenant settings?

Thanks

[Vodia PBX]

It's actually really a little confusing. The one settings comes from the requirement to keep the system from overloading (absolute number of CDR), and today I would say you can have more than a million records on a reasonable large system. The other requirements comes from the need for clients to retain records for so-and-so many weeks (or years). I would day if its really legally important to a client, you will not get around an external solution because its not about the storage itself, its also about other things like tampering. 

[D Ellis]

Hi,

How do I increase it over a million? It's less than a legal requirement, but customer currently deploys individual PBX systems and wants to explore multi tenant. So I guess if we can push over 1 million how and apart from the 3rd party reporting system (which we are exploring) what do other people do? Just output to a database and create their own front end or are there other front end options that can tap into the database output?

Kind regards