[Spce-user] Reports and cdr

[Jiri Ptacnik]

Best reports you get directly from SQL database. Accounting - CDR table.
Not best idea to do this above live system, you should work on replica or
export in different system for example.

čt 15. 10. 2020 v 19:17 odesílatel Matthias Hohl <
matthias.hohl at telematica.at> napsal:

> First:
>
> You create a peering group and define a “contract” for this peering group.
>
> Vial “Reseller and Peering Contracts” you can define a Billing Profile for
> this peering group of this contract.
>
>
>
> That’s it.
>
>
>
> Second:
>
> You have to merge all cdr files at the end of the day manually. SPCE is
> generating 2 cdr files each hour. You can define this interval also via
> config.yml or in customtt. Don’t know now in detail.
>
> Anyway, a monthly file will not be generated automatically.
>
> Download it to a directory and open CMD, then use “copy *.cdr 2020-10.cdr”
>
>
>
> Also “That’s it.” 😊
>
>
>
> *Von:* Diego Ramos <diego.ramos1 at gmail.com>
> *Gesendet:* Donnerstag, 15. Oktober 2020 16:58
> *An:* spce-user at lists.sipwise.com
> *Betreff:* [Spce-user] Reports and cdr
>
>
>
> Hi,
>
>
>
>
>
> How do I get a separate usage report by peerings group or peerings servers?
>
>
>
> And how do I remove the cdr with ngcp-cdr-exporter with a period of the
> last 30 days. In the system it generates day by day and I don't know how to
> generate one at the end of the month.
>
> Diego Ramos
>
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20201019/d790523a/attachment-0002.html>