• Sip Trunk;
• Inbound/Outbound;
• CDRs;
• CDRs;

On the first day of every month at 8 A.M. UTC, a cronjob scheduled in the machine named “Monitoring” runs a script that automatically retrieves the graph from Grafana showing the concurrent calls of the previous month and sends an email with the updated data in the tables.

As per the Concurrent Usage, I'm more than happy to let you know that I've developed a script for it! :)
In order to run the script you need something beforehand:

• To install Python on your device (from 3.12 >): https://www.python.org/downloads/;
• To install Python-Pandas: https://pandas.pydata.org/;
• Download my script: Concurrent Usage Script

If it's your first time doing this procedure, you must first create a folder in your pc where you can store the usages files and the script. Once done that, proceed with the next step.

The procedure goes as follows:

1. Go to the sysmgmt page of the region (FK or SYD), to “Usage” and click on “Concurrent Users License Report 3 months” to download the usage;
2. Extract the file onto the folder where the .py script is located;
3. Ensure that the file is named as “license_usage_report.csv”;
4. Launch the .py script;
5. The only input from the user will be to declare whether it's Frankfurt or Sydney;
6. Then, you will be printed with “This is the max –>” and a value, you must pass this file to whom's following the Usage update, and if you want you can even hand them the usage_(month)_(year)_(region).csv file, which is already parsed with the correct month;
7. Repeat the process with the next region;

As you could've guessed, this one was an oddly easy task, and with the help of my script, you perform it in a matter of seconds.

This topic is rather important since it involves an economic value for the company. And guess what? I've developed a script for this part as well! :)