SOLVED Best Practice to Extract CDR Report for a Tenant in Multi-Tenant Setup

[Sunny Gosain]

SYSTEM VERSION:V4.4.3 Debian 9.9

Our Multi Tenant Setup is as follows:

--Dial Plans at the "Global" level.

--Extensions - At the "Tenant" Level

We can query CDR across all Tenant. But if we want to query CDR for calls/traffic at the Tenant Level. One way I can think is to filter traffic by caller_id_number and/or destination_number to match the numbers allocated to the Tenant. Alternatively, there is a wealth of session/channel data available in the json column of the CDR table that can be used to extract the tenant specific CDR records.

I'm sure there are several ways to accomplish this. Just curious to see how others provide a "tenant filtered view of the CDR" to their tenants.

 

[Andyd358]

Morning,

I know this is question to your question but I dont understand why you have Dial Plans at Global level and not at tenant level. On ours all the diaplans are at Tenant level

 

[Sunny Gosain]

Closing the issue as there is a wealth of information is available under json.variables that can be used to query CDR